Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Or using Above() function for previous quarter
Expression for previous quarter:
Above(Count({<Task_Status = {'Open'}, Quarter_Name>}Task_ID)) * Avg(1)
Use an AsOf table like explained here: The As-Of Table.
Or using Above() function for previous quarter
Expression for previous quarter:
Above(Count({<Task_Status = {'Open'}, Quarter_Name>}Task_ID)) * Avg(1)
Check this too, Interesting
Period Presets: Compare Periods on the fly
Thanks everyone for the suggestions.