Advanced Filter Function
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 🙂
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
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
Thank you so much Hari!