How to allow users to download a table with 300+ columns
I have been given a SQL query that has a column for each day of the year, and about 50 rows with different business metrics. I have also been told that I need to host this query in Sisense for users to download the data. Given the restrictions on table widgets, how should I best go about serving up this data?
Currently, I have the query stored in an Elasticube as a table query. Our Sisense subscription also includes the Report Manager add-on.
Thanks in advance for any help!
Hello kwmacd
Is there a specific reason why your sql has a horizontally (365 columns) orientated table instead of a vertical one? The last one would make it way easier. Furthermore I think that sisense has a max on the amount of columns. I dont know if it is possible to include 365 individual fields.
I am unfamiliar with your dataset, however I would advice to make it have a vertical orientation. For example
Instead of
KPI | day 1 | day 2 | day 3 | day x
KPI #1 | 1 | 1 | 1 | 1
go for this
KPI #| Day
KPI # 1 | 01-01-2023
KPI # 1 | 02-01-2023
Then you can easily add those two fields and let users download it or send it via the report manager
Hamza
