cancel
Showing results for 
Search instead for 
Did you mean: 

Advanced Filter Function

amelia
10 - ETL
10 - ETL

Hi Sisense Community! I am currently building a sales dashboard and would like to compare actual sales numbers and sales target. However, the data that I have for actual sales is only until the current date, but the sales targets are until end of year. Hence, my current dashboard has a lot of empty values in the 'Sales Amount' column, since the sales didn't happen yet (first screenshot). 

 

My goal is to filter out the 'Sales Target' values where the 'Sales Amount' column is still null. Is there a way to do so with the help of an advanced filter? Thank you 🙂 

3 ACCEPTED SOLUTIONS

harikm007
13 - Data Warehouse
13 - Data Warehouse

Hi @amelia ,

Not sure how to filter out rows with null values here. 

But one alternative is to add a condition 'greater than very small number' (eg : > -99999999)

harikm007_0-1653937326464.png

-Hari

 

View solution in original post

Ophir_Buchman
12 - Data Integration
12 - Data Integration

Hi @amelia 

Consider adding a custom column to your date dimension that indicates whether this date is in the future.

Then, add a filter for that value in the widget

View solution in original post

Thank you so much Hari!

 

View solution in original post

4 REPLIES 4

harikm007
13 - Data Warehouse
13 - Data Warehouse

Hi @amelia ,

Not sure how to filter out rows with null values here. 

But one alternative is to add a condition 'greater than very small number' (eg : > -99999999)

harikm007_0-1653937326464.png

-Hari

 

Thank you so much Hari!

 

Ophir_Buchman
12 - Data Integration
12 - Data Integration

Hi @amelia 

Consider adding a custom column to your date dimension that indicates whether this date is in the future.

Then, add a filter for that value in the widget

Thanks Ophir!