Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I need to get only the 2022 data from jan to till date in a Date filed which is a dimension in my straight table.
i have written the logic in Date dimension as
=aggr(only({<Date = {">=$(=Yearstart(Max(Date),-3))<=$(=max(Today()))"}>}>}Date),Date)
and showing the result as
but in the chart it is displaying as hyphen as shown below:
Please assist me on this. Thank you in advance
Ideally you should be restricting the measures
Calculated Dimension for Jan to Date
=aggr(
only({<
Date = {">=$(=Date(Yearstart(Max(Date))))<=$(=date(max(Today()))) " }
>} Date) // You have extra closing brackets here >} >}
,Date)
Best to restrict in measures
Count({<Date = {">=$(=Date(Yearstart(Max(Date))))<=$(=date(max(Today()))) " } ,City={'Tokyo'} >}Distinct Customer)
hi , As i dont have a measure field , we just pulled all the fields as a dimension in a straight table. and i need to put in date dimension only. i have removed the extra brackets but didnt work