Forum Discussion

amelia's avatar
05-30-2022
Solved

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

4 Replies

Replies have been turned off for this discussion
  • harikm007's avatar
    harikm007
    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)

    -Hari

     

    • amelia's avatar
      amelia
      ETL

      Thank you so much Hari!

       

  • Ophir_Buchman's avatar
    Ophir_Buchman
    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