4 Replies Latest reply: Jan 9, 2017 12:47 PM by Novice 77 RSS

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

      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;