Forum Discussion

ajaydavidluke's avatar
ajaydavidluke
Helper I
3 years ago

Turnover Groups

Good afternoon Community,    I have a connundrum that I wanted some help with 🙂    I have a simple list of turnover by account 2022.  What I would like to do is  create a measure that sums the t...
saravanan_p's avatar
saravanan_p
Resolver III
3 years ago

Hi,
Its straight forward.

First create buckets in calculated column to capture category by using nested if. There you get group 1,2,3, etc according to your needs.

Now drag and drop turnover in values and maps with location and legends as this calculated column.

Hope its clear and kindly mark it as solution 

 

ajaydavidluke's avatar
ajaydavidluke
Helper I
3 years ago

Thank you for the response, please correct me where I am wrong, I'm new to this functionality, your help is greatly appriciated 🙂  from the below I am not getting the desired result!

 

I should be seeing more colours on the map?

 

I've also tried this but same results:

 

  • saravanan_p's avatar
    saravanan_p
    Resolver III
    3 years ago

    Hi,

    Thats perfect. And your results are correct. I see different color in maps. Check deeply, you see legends with different colors, but data is more for blue. You can obserev 1 or 2 orange color spots too. So its working. 
    Kindly mark as solution , as this would support our community. 

    • msbiuser1's avatar
      msbiuser1
      Advocate I
      3 years ago

      saravanan_p  Eagle eyes. Nice observation. Good work!!. 
      ajaydavidluke Hope its clear, kindly mark this as a solution 

    • ajaydavidluke's avatar
      ajaydavidluke
      Helper I
      3 years ago

      The issue I can see is that I have accounts with large turnovers but this group is no where to be seen, for example the biggest account is >750,000 but this isnt reflected in the map, ideally I would want only one colour to represent the final figure?

       

       

      I created a group >150k and this should be visible on the above account

       

      • saravanan_p's avatar
        saravanan_p
        Resolver III
        3 years ago

        Dear I believe for the same location , there may be different account codes having more categories.
        Thats the reason you see 3 color for same location.
        Can you bring location in table along with account code and turnover, this would conclude and solve your use case