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,
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,
'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.
Retrieving data ...