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


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.


Best Answer

  • ColemenWilson
    Answer ✓


    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:

    If I solved your problem, please select "yes" above