2 Replies Latest reply: Mar 15, 2017 9:23 AM by Bill Markham RSS

    toggle between charts or drill down??

    Maria Harmening

      EmpDateSt    EmpDateEnd    FYStart       FYEnd         FYFlag      QuartSt         QuartEnd       QFlag        MonYear       MYFlag

      1/1/2016       10/15/2017       10/1/2016   9/30/2017     1               1/1/2017       3/31/2017         1              Jan 2017        1

      1/1/2016       10/15/2017       10/1/2016   9/30/2017     1               1/1/2017       3/31/2017         1              Feb 2017        1

      1/1/2016      10/15/2017        10/1/2016   9/30/2017     1               1/1/2017       3/31/2017         1              Mar 2017        1

      1/1/2016       10/15/2017       10/1/2016   9/30/2017     1               4/1/2017       6/30/2017         1              Apr 2017        1

      1/1/2016       10/15/2017       10/1/2016   9/30/2017     1               4/1/2017       6/30/2017         1              May 2017        1

      1/1/2016       10/15/2017       10/1/2016   9/30/2017     1               4/1/2017       6/30/2017         1              Jun 2017        1

      1/1/2016       10/15/2017       10/1/2016   9/30/2017     1               7/1/2017       9/30/2017         1              Jul 2017        1

      1/1/2016      10/15/2017        10/1/2016   9/30/2017     1               7/1/2017       9/30/2017         1              Aug 2017        1

      1/1/2016       10/15/2017       10/1/2016   9/30/2017     1               7/1/2017       9/30/2017         1              Sep 2017        1

      1/1/2016       10/15/2017       10/1/2017   9/30/2018     1               10/1/2017     12/31/2017        1              Oct 2017        1

      1/1/2016       10/15/2017       10/1/2017   9/30/2018     1               10/1/2017     12/31/2017        0              Nov 2017        0

      1/1/2016       10/15/2017       10/1/2017   9/30/2018     1               10/1/2017      12/31/2017       0              Dec 2017        0

       

       

      in this very small sample of my data, an employee starts employment 1/1/2016 and ends employment 10/15/2017.  I create the FYStart and FYEnd, QuartSt and QuartEnd, and MonYear on the load and determine the flag status based on the date ranges.  I want to create a chart where I can toggle between the FYview, the QuarterView and the monthly view, but it seems like it's disjointed?  how can I create one chart and toggle between?  currently I have 3 separate charts.