Bar chart with dimensions

[Navars]

Hi All,

I am using count (ID) as an expression and i need to use Month and year as dim. I need the chart to look above.

How can I achieve this?

Thanks in advance. 

Regards,

Sra1..

[nisha_rai]

Hi,

Can you share the sample data.

[anushree1]

I do not think you will be able to achieve this as is in the image, two alternatives that I can think of are

1. Create a Composite field like Year&'-'&Month as YearMonth in the Script and use the same on the Xais of the chart by selecting it as a Dimension

2. Use Drill Groups on Year and Month

[Brett_Bleess]

Did the last posters suggestion work for your use case?  If so, do not forget to return to your thread to close things out by using the Accept as Solution button on that post to mark it giving the poster credit for the help and letting other Members know that did work for you.  If you are still working upon things, as the other poster noted, some sample data or what you have in QVW already would be very helpful for folks to offer further suggestions.

Regards,
Brett