2 Replies Latest reply on Jul 31, 2018 7:23 PM by Jonathon Lake

    Is it possible show a percentage of  filtered value over an unfiltered value

    Jonathon Lake

      Hey,

       

      I have a chart that shows the area of a sub category (filtered) and then another that shows the area of all the categories (unfiltered).

       

      I want to be able to have textbox that show the % of the sub category over the total % of all categories.

       

      For Example.

       

      Category 1: total area: 100,000 m2

      Category 1+2+3 (All categories): 340,000 m2

       

      Textbox 1 (Category 1 as a percentage of the overall area) = 29.4%

      (100,000/340,000 * 100)

       

      Category 1 has a few sub-sections as well. I was wondering whether I can show these as a percentage when clicked on in the dashboard as well.

       

      Textbox 2 (sub category of category 1): 40%

      (40,000 / 100,000 * 100)

       

      I've been playing around with creating calculations but can't seem to come up with a solution.

       

      Maybe you guys have an idea.

       

      Thanks in advance.