How to compare 4 previous fiscal year cost with current Fiscal year cost in line chart
How to compare previous Fiscal years cost with current fiscal year in a line chart? Fiscal year starts from Feb 01 and ends in jan 31. I have added 4 colums for this but it is taking long time to load as its direct query from bigquery and table is 600GB. I wanted to know optimized solution. also i chart without scroll bar. all years without days but with day level datapoints. like shown in 2nd chart. but with separate line for each Fiscal year and month starting from feb and ending in jan chart 2
