Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am pulling out a list of dates on to my dashboard, but I would like to display only the dates related to a status of scheduled or completed. I cant seem to figure out the correct syntax.
Thank you in advance
How about this:
Date as dimension
Only({<Status = {'scheduled, 'completed'}>} [Start Time]) as expression
May be this:
Aggr(Only({1<status = {'scheduled, 'completed'}>} DateField), DateField)
or create the Flag in script like below
LOAD *,
if(match(status,'scheduled','completed'),Date,null()) as DateNew
......
Now you can directly use DateNew as Dimension
if Status & Date fields are from different table then go for what sunny has suggested
Allow me to clarify as I am still doing something wrong. When I drag the attribute "Start Time" I am getting a list of dates. I would like only the dates which are associated with the "Status" of Scheduled. I will do another list for Completed.
I am starting with the following in the expression [Start Date]
How about this:
Date as dimension
Only({<Status = {'scheduled, 'completed'}>} [Start Time]) as expression