How to show last quater counts in Current quarter of chart.

[#1]

HI,

Could you help me to figure out the brown bar in below chart.

If I am using the ABOVE function it is working fine but if I filter the data by 2016 then  brown bar is missing in first quarter (Jan-Mar 2016) .

Temp:
LOAD * INLINE [
Task_ID, Date1, Task_Status
998, 7/11/2015, Close
999, 1/12/2015, Open
1000, 12/12/2015, Open
1001, 2/1/2016, Open
1002, 5/1/2016, Open
1003, 7/1/2016, Close
1004, 13/1/2016, Open
1005, 13/1/2016, Close
1006, 2/2/2016, Open
1007, 6/2/2016, Close
1008, 7/2/2016, Close
1009, 23/2/2016, Open
1010, 24/2/2016, Close
1011, 1/3/2016, Open
1012, 5/3/2016, Open
1013, 17/3/2016, Close
1014, 23/3/2016, Open
1015, 25/3/2016, Open
1016, 27/3/2016, Open
1017, 6/4/2016, Close
1018, 7/4/2016, Open
1019, 20/4/2016, Open
1020, 21/4/2016, Open
1021, 1/5/2016, Open,
1022, 5/5/2016, Open,
1023, 17/5/2016, Close,
1024, 2/6/2016, Open,
1025, 10/6/2016, Open,
1026, 4/7/2016, Open,
1027, 14/7/2016, Close,
1028, 17/8/2016, Open,
1029, 20/8/2016, Open,
1030, 21/8/2016, Open
1031, 1/9/2016, Open
1032, 9/9/2016, Open
1033, 17/9/2016, Close
1034, 2/10/2016, Open
1035, 11/10/2016, Open
1036, 14/10/2016, Open
1037, 24/11/2016, Close
1038, 26/11/2016, Open
1039, 27/11/2016, Open
1040, 1/12/2016, Open
];

Temp1:
Load *,
QuarterName(date(Date1, 'DD/MM/YYYY'))  As Quarter_Name
Resident Temp;

Drop table Temp; 

[sunny_talwar]

What are your expressions?

[#3]

Expression I used :

Open  in last quarter : Above(Count(distinct {<Task_Status={'Open'}>}Task_ID)) * Avg(1)

Open in Current Quarter : count( distinct {<Task_Status={'Open'}>}Task_ID)

But If I select 2016 in the  filter then Open in last quarter is not coming for first quater. May be Above is only picking up previous counts from the chart's expression.

[sunny_talwar · Accepted solution]

Try this:

Above(Count(distinct {<Task_Status={'Open'}, Year, Quarter_Name, Date1>}Task_ID)) * Avg(1)

[#5]

Thanks a lot.. Really