Forum Discussion

amelia's avatar
amelia
ETL
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 curre...
Dashboards & Reporting
  • harikm007's avatar
    harikm007
    05-30-2022

    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's avatar
    Ophir_Buchman
    06-02-2022

    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's avatar
    amelia
    06-07-2022

    Thank you so much Hari!

     

Ophir_Buchman's avatar
Ophir_Buchman
Data Integration
06-02-2022

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's avatar
amelia
ETL
06-07-2022

Thanks Ophir!