current and previous qtr count

[Anonymous]

Hi All,

I want to show the count of previous quarter along with the current quarter, like the screen shot in the attachment.

I have tried, but its not working. Please help.

Temp:
Load *,
QuarterName(date(Date1, 'DD/MM/YYYY'))  As Quarter_Name
;
LOAD * INLINE [
    Task_ID, Date1, Task_Status
    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
];

Thanks.

[Gysbert_Wassenaar]

Use an AsOf table like explained here: The As-Of Table.

[sunny_talwar · Accepted solution]

Or using Above() function for previous quarter

Expression for previous quarter:

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

[Anil_Babu_Samineni]

Check this too, Interesting

Period Presets: Compare Periods on the fly

[Anonymous]

Thanks everyone for the suggestions.