Forum Discussion

wskallmeyer's avatar
wskallmeyer
Advocate II
9 years ago
Solved

Stacked Column Visual: Merge multiple columns/values into 1

Hi,   I have a Stacked Column visual with 8 columns( 1 db column with 8 different values).  I would like merge 2 columns (or more) so that I would end up for 4 columns showing on my visual.  Each o...
Need Help
  • MFelix's avatar
    MFelix
    9 years ago

    wskallmeyer,

     

    As you can see below I have made a chart based on the grouping, you need to add the grouping on the States and then add the count/sum based on the values of each state please check the print below.

     

    Any additional question please tell me.

     

    Regards 

    MFelix

wskallmeyer's avatar
wskallmeyer
Advocate II
9 years ago

This is what I had in mind.  Take the 2 left columns and have them show as 1 column on the visual.  The total would then be ~44. Adding their values in the process.  And the same all the way across the chart.  Grouping only seems to make their colors the same.  That is not what I need.

 

Thanks!

MFelix's avatar
MFelix
Super User
9 years ago

wskallmeyer,

 

As you can see below I have made a chart based on the grouping, you need to add the grouping on the States and then add the count/sum based on the values of each state please check the print below.

 

Any additional question please tell me.

 

Regards 

MFelix