I was using this sales vs date chart with Daily Sales on the Y-axis and Dates on X-axis.
At the top, I have filters to choose the start and end dates. But if I set the filters in a way that the date difference between the start and end date in 30+ days, then it becomes cumbersome to read it properly. Is it possible to calculate the difference of selected date & store it in variable and if variable < 15 days then, show graph_1, if variable >15 & < 30, then show graph_2, else graph_3 where
graph1 - will always shows date wise sales
graph3- monthwise
Please help.
