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

Lu_zhang · June 4

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 · June 4

Yes.

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

ColemenWilson · June 4

Yes.

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

Lu_zhang · June 5

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 · June 5

@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 · June 5

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

Lu_zhang · June 6

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

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

Best Answer

Answers

Categories