1 Reply Latest reply on Sep 24, 2018 2:46 AM by Thomas Rones

    Action Filter Multiple Datasources -- Show something when all marks are filtered out.

    Thomas Rones

      I have an action filter that navigates from one dashboard to the next.

      Dashnboard 1 uses datasource 1

      On Dashboard 2 I have multiple sheets, some use datasource 1 some use datasource 2.

       

      I am trying to create a label that will say something like "No data available for this country."

      Datasource 2 does not have all the countries that datasource 1 has.

       

      Example:

      Datasource1.Country
      Datasource2.Country
      USAUSA
      UKUK
      Germany
      France

       

      I figured out how to do this manually, but it is not dynamic, I have to compare the list of countries in each datasource and then write a case statement:

       

      Case ATTR(Datasource1.Country)

      when "Germany" then "No Data for Germany"

      when "France" then No Data for France"

      else null

      end

       

      Note: It is ok if it just says "this country" rather than "Germany", I just want it to be dynamic so I dont have to update this calculated field all the time

       

      I tried things like ISNULL(COUNT(Country)) and also if COUNT(country) = 0... but there are no marks in my view (due to the action filter), so I can't get anything to show up