Intervalmatch- two event in one interval

[#1]

Hi,

I have table with from_date1,to_date1 and from_status. I have created one calendar for all dates.

Now I used IntervalMatch for creating table which will give status and calendar date.

from_status, to_status, from_date,to_date

Open,            Closed,    01/01/2016,01/01/2016

After Interval Match

calendar date, from_status,from_date,to_date

01/01/2016,    Open,           01/01/2016,01/01/2016

01/01/2016,    Closed,         01/01/2016,01/01/2016

Required:

calendar date, from_status,from_date,to_date

01/01/2016,    Closed,         01/01/2016,01/01/2016

for one date, Status got changed from Open to Closed so for this event, It is showing two entries in table which is correct but I want to show only second status (Closed) for that date

[#2]

hi,

I want this in my chart with date and status as dimension. see first tab line chart?

[Anonymous]

Is this closer to what you want ?

If uses the aggr() function in the expression:

     =count(aggr( max(From_Date) , IssueID, CalendarDate))

I changed it from a Line Chart to Bar Chart, as the sparse sample did not visualize well as lines.  It could well visualize better with your real data.