topic Re: Date Dimension in App Development

Date Dimension

Anonymous — Fri, 31 Aug 2018 20:47:10 GMT

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.

Re: Date Dimension

nsetty — Fri, 31 Aug 2018 21:10:22 GMT

try

if(floor([completed_date.autoCalendar.Date])>=DATE((today())-60), completed_date )

Re: Date Dimension

Anonymous — Fri, 31 Aug 2018 21:38:00 GMT

Expression works, but same error as previous, no ability to zoom in to graph to narrow view. Thanks though