Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to cluster data in circle chart?

Dear All,

 

I created a circle chart, as mentioned below, with a bunch of values. 

 

I would like to show the first 5-10 values seperately, but how can I cluster the rest of the values to one value, labelled for instance like 'Others'. The values are populated by a measure. 

Any suggestion how to arrange?

 

Thanks!

Kind regards,

  • MAwwad's avatar
    MAwwad
    3 years ago

    Switch(TRUE(), Values(Name of Supplier) = "ABC"," Group 1",
                            Values(Name of Supplier) ="BCD"," Group 1",
                            Values(Name of Supplier) ="CDE","Group 1",

    etc.....

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      How would this look likke with a sample set of data?

       

      • MAwwad's avatar
        MAwwad
        Solution Sage

        Switch(TRUE(), Values(Name of Supplier) = "ABC"," Group 1",
                                Values(Name of Supplier) ="BCD"," Group 1",
                                Values(Name of Supplier) ="CDE","Group 1",

        etc.....

    • Anonymous's avatar
      Anonymous
      Not applicable

      How does this work? What do I see?