Forum Discussion

amelia's avatar
amelia
ETL
05-26-2022

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 the values from the Excel sheet using SUM() or COUNT(), but I get an error if I do not do an aggregation. 

Attached are screenshots - the column from the excel sheet is how I would like the data to appear on Sisense pivot table, but the column I am seeing on Sisense has different values as it uses the SUM() function.

dashboards & reporting

7 Replies

Replies have been turned off for this discussion
    • amelia's avatar
      amelia
      ETL
      05-26-2022

      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? 

      ā€ƒ

      • harikm007's avatar
        harikm007
        Data Warehouse
        05-26-2022

        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