Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try below
Period Presets: Compare Periods on the fly
Have a look at this ShowHide Container extension.