2 Replies Latest reply on Nov 28, 2018 1:36 AM by Kofi Ramsay

    Filter where data is missing for all filtered settings

    Kofi Ramsay

      I have been trying to filter a dimension based on information missing from all years selected.


      The data that I have is all dates where the data is missing. The dashboard works as planned when there is only one year selected. The problem is whenever 2 or more years are selected at a time I will like only attributes where all selected years are missing.


      I have tried a combination of parameters and level of detail calculations but none seem to work correctly. I would like to use a table calculation but cannot since I would like a filter.


      Packaged Workbook Attached.


      For example: I will only want those attributes with number of records of 2 to show. Those with number of records of 1 should be hidden because they are not missing from both of the years in the filter 2016 & 2017.

      Screenshot 2018-11-27 23.03.33.png



      In this example all years are selected and only those attributes that are missing every year should be shown.


      Screenshot 2018-11-27 23.03.18.png