Forum Discussion

amelia's avatar
amelia
ETL
03-10-2022

Filtering of null values out from Sisense

Hi! I am currently facing an issue with one of my dashboards - rows with null values are being hidden after some filters are applied. This affects other columns of data, since some of them use RSUM. The RSUM values are wrong since the rows with null values are being deleted. Can i check if there is any way I can resolve this? 

dashboards & reporting

1 Reply

Replies have been turned off for this discussion
  • ronenavidor's avatar
    ronenavidor
    Sisense Employee
    03-16-2022

    Hi Amelia,

    You can create a custom column in you data model, and replace all null values with the value of zero. Then use the newly created column as part of your RSUM function.

    Hopefully that helps.

    Ronen