topic Re: Line chart dimension in App Development

Line chart dimension

harika181 — Fri, 01 Oct 2021 11:58:17 GMT

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 — Fri, 01 Oct 2021 12:09:24 GMT

Is the attached format fine for you?

Digvijay_Singh — Fri, 01 Oct 2021 12:19:57 GMT

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 — Mon, 04 Oct 2021 10:26:40 GMT

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 — Mon, 04 Oct 2021 10:31:36 GMT

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

Jan-21

Feb-21

Mar-21(Q1) something like this

abhijitnalekar — Mon, 04 Oct 2021 10:47:00 GMT

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.