5 Replies Latest reply on Jan 2, 2019 9:33 PM by megha gawali

    Showing all filter values

    Lusiana Djie

      I have records containing the rating given to each individual, ranging from 1 to 5. With these records, I created a bar chart to see how each individual compares to one another.

      I want my dashboard to have the ability to filter down this bar chart based on the rating. Therefore, I created a table calculation field called "Rating Criteria" with the following formula:

       

      IF [Rating] >= 4.5 THEN "Excellent [>= 4.5]"

      ELSEIF [Rating] >= 4 THEN "Very Good [>= 4 AND < 4.5]"

      ELSEIF [Rating] >= 3.5 THEN "Good [>= 3.5 AND < 4]"

      ELSEIF [Rating] >= 3 THEN "OK >= 3 AND < 3.5"

      ELSEIF [Rating] >= 2.5 THEN "Fair >= 2.5 AND < 3"

      ELSEIF [Rating] >= 2 THEN "Poor >= 2 AND < 2.5"

      ELSEIF [Rating] >= 1.5 THEN "Very Poor >= 1.5 AND < 2"

      ELSEIF [Rating] >= 1 THEN "Terrible >= 1 AND < 1.5"

      END

       

      Then, I added this "Rating Criteria" field as a filter. Turns out that the lowest rating in my records is 3.8.

      Instead of showing all possible values, the filter only shows:

       

       

      I find that this is confusing for my end users, and I want to be able to show all possible filter values even though the current lowest rating in the record is 3.8. I have tried ticking "Show all values in the database" and it didn't work in this case

       

      Would really appreciate your help, thank you!