Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Date Dimension that pulls dates within last 60 days:
if(floor([completed_date.autoCalendar.Date])>=(today())-60, completed_date )
Only problem I have is that when this dimension is used in a graph, there is no ability to zoom-in unlike other date dimensions that I have used previously.
"Date([completed_date])" leads to same error but not limited to 60 days, while just "completed_date" allows me to zoom in. Any help to solve this small issue is appreciated.
try
if(floor([completed_date.autoCalendar.Date])>=DATE((today())-60), completed_date )
Expression works, but same error as previous, no ability to zoom in to graph to narrow view. Thanks though