Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help With Mekko Chart - Dynamically summarizing data

Hello Everyone,   I am trying to build a Mekko chart as below.Sample data sheet is attached here Mekko Data Sheet    Now,the only thing constant in the data is Market share for Comp1 to Com...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    So i was able to work this out with little research.Sharing if it helps someone else.There could be a better way to do it though 🙂

     
    Created a new column.
    Mekko_Competitors = IF([Competitor]="Comp1","Comp1",IF([Competitor]="Comp2","Comp2",IF([Competitor]="Comp3","Comp3",IF([Competitor]="Comp4","Comp4",IF([Competitor]="Comp5","Comp5",IF([Competitor]="Comp6","Comp6","Others")))))
     
    And now i can use this new measure in Mekko which will summarize competitors other than 1-6 in mekko graph.
     
    Regards
    Biru
  • Icey's avatar
    Icey
    4 years ago

    Hi Anonymous ,

     

    Glad to here that. Please accept your reply as the solution. Your contribution is highly appreciated.

     

    In addition, you can also create the column like so:

    Competitors 2 = 
IF (
    [Competitors] IN { "Comp1", "Comp2", "Comp3", "Comp4", "Comp5", "Comp6" },
    [Competitors],
    "Other Competitors"
)

     

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

So i was able to work this out with little research.Sharing if it helps someone else.There could be a better way to do it though 🙂

 
Created a new column.
Mekko_Competitors = IF([Competitor]="Comp1","Comp1",IF([Competitor]="Comp2","Comp2",IF([Competitor]="Comp3","Comp3",IF([Competitor]="Comp4","Comp4",IF([Competitor]="Comp5","Comp5",IF([Competitor]="Comp6","Comp6","Others")))))
 
And now i can use this new measure in Mekko which will summarize competitors other than 1-6 in mekko graph.
 
Regards
Biru
Icey's avatar
Icey
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

 

Glad to here that. Please accept your reply as the solution. Your contribution is highly appreciated.

 

In addition, you can also create the column like so:

Competitors 2 = 
IF (
    [Competitors] IN { "Comp1", "Comp2", "Comp3", "Comp4", "Comp5", "Comp6" },
    [Competitors],
    "Other Competitors"
)

 

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.