Open and Close Tickets

[Sameer9585]

Hi,

I need a help to get the ID till the selected date and the there should be an another field of flag which indicates close or open it is been decided by the End_Date if the selected date is less than or equals to End_Date the it should display all the ID till that date and the status Open/Close.

Below I provide the dataset in it sheet 11 is the dataset.

thanks in advance,

With Regard,

[asinha1991]

can you share your data model (ctrl+T) and exact description of object you have created(measure, expression) etc and also tell me the field(from data model) you are using in filter 

[Sameer9585]

In it the date feild in the Date_Currency table is used in the filter which I created from the master calendar.

[asinha1991]

is this your dimension in chart?

if(START_DATE<=getfieldselctions(Date) ,ID)

[Sameer9585]

Yes,I got it.

[Sameer9585]

I got it..
Thank You -;