cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
redsilk Frequent Visitor
Frequent Visitor

Group by Column values (Count)

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

image.png

2 ACCEPTED SOLUTIONS

Accepted Solutions
Washivale Regular Visitor
Regular Visitor

Re: Group by Column values (Count)

Hello @redsilk ,

 

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

 

Capture2.PNG

let me know if it helps.

 

Thank You,

Washivale

jtownsend21 Member
Member

Re: Group by Column values (Count)

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) 

Capture.PNG

 

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. 

3 REPLIES 3
Washivale Regular Visitor
Regular Visitor

Re: Group by Column values (Count)

Hello @redsilk ,

 

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

 

Capture2.PNG

let me know if it helps.

 

Thank You,

Washivale

jtownsend21 Member
Member

Re: Group by Column values (Count)

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) 

Capture.PNG

 

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. 

redsilk Frequent Visitor
Frequent Visitor

Re: Group by Column values (Count)

Thanks