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
Hi Hari, I tried that and it wouldn't work, since the rows that are missing in the Excel sheet will not show up (The data from the excel sheet only starts April 2022, but the rest of the data is from 2020 onwards) if I do this - is there any workaround for this that you would recommend?
ā
Can you try Max() or Min() aggregators?
If its not giving expected result, can you show sample data from excel and the expected result?
-Hari
