Line chart dimension

[harika181]

Hello,

I need something like this on my X-axis in line chart 

Jan Feb Mar(Q1) Apr May Jun(Q2) Jul Aug Sep(Q3) Oct Nov Dec(Q4)

Can anyone let me know how can it be done

[abhijitnalekar]

Hi @harika181 ,

Is the attached format fine for you?

[Digvijay_Singh]

What if you create a new field in the script with expression something like as below and use that field in the chart - 

pick(Match(Month(Month),'Jan','Feb', 'Mar'.......),

'Jan','Feb','Mar(Q1)..........)

[harika181]

I just need for months that are end months of each quarter: e.g. Mar-21 (Q1), Jun-21 (Q2), Sep-21 (Q3), Dec-21 (Q4) 

Its like

Jan

Feb 

Mar(Q1)

Apr

May

Jun(Q2)

Jul

Aug

Sep(Q3)

Oct 

Nov 

Dec(Q4)

[harika181]

In line graph we have different years it should reflect with years Too

Jan-21

Feb-21

Mar-21(Q1) something like this

[abhijitnalekar]

Hi @harika181 ,

Please check the below line chart.

=dual(
if(month(QuarterEnd(Date))=month(Date),month(Date)&'-'&date(Year(Date),'YY')&'(Q1)',month(Date)&'-'& date(Year(Date),'YY')),month(Date))

Note : I have use the Dual function to sorting the month.