Total of All States on State Map

cochoa

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!

david_cunningham

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

https://domo-support.domo.com/s/article/4408174643607?language=en_US

david_cunningham

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

https://domo-support.domo.com/s/article/4408174643607?language=en_US

cochoa

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!