Is it possible to show the parcel percentage instead of parcel quantity on DOMO map?

Lu_zhang

Currently it is showing the parcel quantity by province.

I want the parcel percentage each province takes to be shown on the map.

How to design it?

Do I have to use ETL to create a new aggregated column in % for the raw data?

I do not prefer to change the original dataset because I've created too many beast mode calculated fields. I know once I change the dataset the calculated fields I've created will disappear. So ask for help. thanks.

ColemenWilson

Yes.

1. Create a new beastmode: SUM(revenue) /SUM(SUM(revenue) FIXED ())
2. Use that beastmode as your Province/fsa value
3. Change the Province/fsa Value to a percentage as shown below:

ColemenWilson

Yes.

1. Create a new beastmode: SUM(revenue) /SUM(SUM(revenue) FIXED ())
2. Use that beastmode as your Province/fsa value
3. Change the Province/fsa Value to a percentage as shown below:

Lu_zhang

https://community-forums.domo.com/main/discussion/comment/96352#Comment_96352

@ColemenWilson

can you help look why it doesn't work for me? thank you so much

Lu_zhang

@ColemenWilson I make it by count(快递单号)/sum(COUNT(快递单号) fixed ()).

I'd like to say you are so great a beast mode man!!

Even though I've made it, I do not understand the design especially fixed (). My understanding it is fixed by (Province）

can you pls explain some to me on it? thank you very much.

ColemenWilson

@Lu_zhang this should help! https://domo-support.domo.com/s/article/4408174643607?language=en_US I used example #1.

Lu_zhang

https://community-forums.domo.com/main/discussion/comment/96397#Comment_96397

feel like it opens a new beast mode world to me!

really useful and solved the problem which had kept bothering me a lot recently!

@ColemenWilson THANK YOU VERY MUCH