how to show 3 dimensions on x-axis ? As shown below -

[#1]

[maxgro]

is it an option to concatenate two of them (quarter and month or year and quarter)?

[#3]

You could concatenate dimensions using Calculated Dimension Option in charts. Like Year & Quarter, Quarter & month, etc.,

Eg. statement : =aggr(date(YearMonth,if(Month=min(total <Year> Month),'YYYY MMM','          MMM')),Year,YearMonth)

[#4]

No, Need to show all 3 dimensions.

I have used Dummy variable to show 2 dimensions but it doesn't work for 3.

[#5]

Sorry, but Aggr(Year(Date),Quarter)  or  Aggr(Quarter, Month(Date) ) didn't work. I want to display Month, Quarter and Year values on X-axis.

[#6]

Is there any way I can display Month, Quarter and year on same axis ?

[#7]

You first have to create YearQuarterMonth field in script. Then using this aggr function need to pull out x-axis dimension similar to how my expression takes Year & Month.

There could be other solutions too. Let me check and get back to you.

Thanks,

Madhu

[#8]

Thanks Madhu, I will check this. Please let me know if you find other solution.