Date List with Set Analysis

[alemberg]

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

[sunny_talwar]

May be this:

Aggr(Only({1<status = {'scheduled, 'completed'}>} DateField), DateField)

[Kushal_Chawda]

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

[alemberg]

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]

[sunny_talwar · Accepted solution]

How about this:

Date as dimension

Only({<Status = {'scheduled, 'completed'}>} [Start Time]) as expression