Skip to content

    • Datasets

    Datasets

    Total of All States on State Map

    Member
    in Datasets

    Is there a way to display the percent of a total of one state against the total of all states.

    Example: CA had 20 files but there were 100 across the country. I want to display 20% over the state of CA on the data label.

    Or will it only provide by state information?

    Thanks!

    Best Answer

    • Coach
      Answer ✓

      Yes, create a beast mode to calculate the % of total. Then use that as your value.

      SUM(value) / SUM(SUM(value) fixed())

      Here is a reference on FIXED functions

      Site faviconCustomer Support Community

      David Cunningham

      ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
      ** Did this solve your problem? Accept it as a solution! ✔️**

    Answers

    • Coach
      Answer ✓

      Yes, create a beast mode to calculate the % of total. Then use that as your value.

      SUM(value) / SUM(SUM(value) fixed())

      Here is a reference on FIXED functions

      Site faviconCustomer Support Community

      David Cunningham

      ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
      ** Did this solve your problem? Accept it as a solution! ✔️**

    • Member

      Thank you @david_cunningham ! I knew there was something I could do but still learning. :) This pointed me in the right direction. Still some tweaks I needed to do with my data and use nested calculations but it worked! Appreciate the help!

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories