Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Default Values for Card Counting between categories

Hello, 

I was looking to inquire if it was possible to set up a default value for a card when it is filtered by a top 1 filter such that if all categories being compared in number of entries are the same or zero, it shows a blank? Currently when all categories are the same or 0, one of the category names is shown even though it does not have the highest number of entries.


Need Help
Tips and Tricks

4 Replies

  • MFelix's avatar
    MFelix
    Super User
    4 years ago

    Hi Anonymous ,

     

    Do you want to return the value of the highest count, is this to be filtered out based on a selection or is it a fixed value.

     

    What do you want to present on the card the name or the total?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi MFelix,

      I was looking to present the name of the category with the highest count, but have the card output a blank if all categories have zero counts or if the top categories have the same values.

      • MFelix's avatar
        MFelix
        Super User
        4 years ago

        So assuming you have 3 categories you have the following results:

         

        Cat A = 10

        Cat B = 15

        Cat C = 20

         

        Result Cat C

         

        Cat A = 10

        Cat B = 10

        Cat C = 10

         

        Result Blank

         

        Cat A = 0

        Cat B = 0

        Cat C = 0

         

        Result Blank

         

        Is this it?