topic Re: Date Dimension in App Development

Date Dimension

Anonymous — Thu, 16 Aug 2018 17:32:49 GMT

Trying to create a Date Dimension using 'completed_date' field. Basically I want to use this Dimension for x-axis of chart, where I want it to include days that fall within the last 60 days. Currently I have tried these expressions:

Date(Floor([completed_date]-60)), but all the days loaded when I used this one

Date(Floor(Max([completed_date]-60))), but apparently "invalid."

Any help will be appreciated

Re: Date Dimension

pradosh_thakur — Thu, 16 Aug 2018 18:34:38 GMT

something similar to

if completed_date is a date

if(floor(completed_date)>= num(today())-60 and floor(completed_date) < = num(today() ),completed_date,null())

suppress null.

you may not need the num or floor function as well. Make sure you have dates as date and not as string.

Re: Date Dimension

Anonymous — Thu, 16 Aug 2018 19:14:31 GMT

Thank you! So far I think it is working.