Creating a cluster bar diagram to visualize comparison of "id" frequencies comparing for two month

[PB10]

Hi All, you all have been very helpfull, thank you!

Whats the best way to do the following:
I am trying to compare and visualize data of sep and oct, to showcase frequency of "id" 
for two months sep and oct
so i can have  sum of all different id in a bar diagram for both months

Table s1

id	month	priority
a	sep	p1
a	sep	p1
b	sep	p2
b	sep	p2
cc	oct	p3
cc	oct	p3
cc	sep	p3
cc	oct	p3
a	oct	p1
b	sep	p2
cc	sep	p3
cc	sep	p3
d	oct	p4

"Screen reader user"

[v-stephen-msft · Accepted solution]

Hi @PB10 ,

In the cluster bar chart, you can put the counting of id under x-axis, the month under legend.

This way you can see the ID frequency grouped by month.

If you put the priority into the y-axis, you can also see the grouping by priority.

Best Regards,

Stephen Tao

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

[PB10]

Thanks @Omid_Motamedise  puting id under legend helped, thanks for sugesting that.
then i sellected a stacked bar diagram to keep it in one

[v-stephen-msft · Accepted solution]

Hi @PB10 ,

In the cluster bar chart, you can put the counting of id under x-axis, the month under legend.

This way you can see the ID frequency grouped by month.

If you put the priority into the y-axis, you can also see the grouping by priority.

Best Regards,

Stephen Tao

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

[PB10]

Hi Stephen
Thanks for the sollution , but what i am trying to get a frequency of each id and compairing it for two months, Rather total count of ids for months

[v-stephen-msft · Accepted solution]

Hi @PB10 ,

How do you calculate the frequency? Could you give an example based on the sample data above?

At the moment I guess the following results and don't know if it's what you want.

I put the month as y-axis, count of id as y-axis, id as legend.

Best Regards,

Stephen Tao

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

[PB10]

@v-stephen-msft 
Thanks for the sollution , but what i am trying to get a frequency of each id and compairing it for two months, Rather total count of ids for months

[Omid_Motamedise]

is it your question table or the result table?