Adding a column with no aggregation
Hi Sisense community 🙂 I have imported an excel sheet into my elasticube data model and would like to display the columns in the excel sheet in a pivot table in a widget. I do not want to aggregate ...
Forum Discussion
Sure, here is a screenshot of the sample data in Excel:
I would like the column called 'Target' to show up as is, in the pivot table widget. I plan to add a column called 'Target' in the pivot table with these exact values, so I do not want to aggregate them.
Just to make sure if I understood the problem correctly:
There are 2 connected tables. One contains data back from 2020 and the another table, which is created from excel, contains data from 2022.
You need to create a pivot that contains all dates (from 2020) and display corresponding 'Target' (So if date is 2020 'Target' would be blank and if date is 2022 it would show the target value)
Screenshot above shows 'Weeks in calendar_date' instead of 'Days in calendar_date'. Is that expected?
-Hari
