Chart by Quarter

[rcorcoran]

Hi

I have a date made for YearMonth as below but I need on to show YearQuarter any help appreciated

MonthName(Date(makedate(ReferredYYYY,ReferredMM))) as YearMonth,

Thanks

[Digvijay_Singh]

Do you mean you need to create quarter field and use it as dimension? This is the way we create quarter from date field.

'Q' & Ceil(Month(TempDate)/3) as Quarter,

[nagarjuna_kotha]

Hi

Try this:

'Q' & Ceil(Month(DateField)/3) as Quarter,

Year(DateField) as Year

Use this two expressions in backend and In chat Take two dimemtions Year and Quarter.

Regards,

Nag