Group by Column values (Count)

[Anonymous]

Hi , Please I have a Table in this format(FROM) and I will like to count it and group up in this format(TO), is this a

modelling issues . I tried to use a matrix but it will only work for a column. Thanks

[Washivale · Accepted solution]

Hello @Anonymous ,

This would be easier if you can unpivot columns in edit query,

Select columns and click Unpivot Columns option under Transform menu in edit queries, this will change your dataset in preferred format for your visualization

let me know if it helps.

Thank You,

Washivale

[jtownsend21 · Accepted solution]

I believe what you need to do is unpivot your data. 

This can be achieved by using the query editor and selecting unpivot columns in the transform tab. (See below) 

After this you may need to rename some of the columns, but the when you have this done, You can throw the corresponding columns into a matrix. 

[Washivale · Accepted solution]

Hello @Anonymous ,

This would be easier if you can unpivot columns in edit query,

Select columns and click Unpivot Columns option under Transform menu in edit queries, this will change your dataset in preferred format for your visualization

let me know if it helps.

Thank You,

Washivale

[Anonymous]

Thanks