Advanced Filter Function

[amelia]

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 🙂 

[harikm007 · Accepted solution]

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)

-Hari

[Ophir_Buchman · Accepted solution]

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

[harikm007 · Accepted solution]

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)

-Hari

[amelia · Accepted solution]

Thank you so much Hari!

[Ophir_Buchman · Accepted solution]

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

[amelia]

Thanks Ophir!