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.

    Novice 77

      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;