kwmacd
10-11-2023Cloud Apps
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 ...
- 10-12-2023
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