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
Thank you for the prompt response. Here the current dimension is the visit_date ie. the date on which the customer purchased a product. But I want to change it according to the filters applied ie start and end date which themselves don't have a variable assigned to them. That's why I failed to execute what you suggested. Could you throw some more light on how to approach it?
You could try transform start date and end date into num and compare those differences, I don't know for sure how 15 day and 30 days differences are represented in num form, but you can check those differences in a text box, then put those in the 'if' statements that I suggested.
Or you can try, use the day function and create a logic to compare the differences between days, but I think this way is a bit more difficult because not all the months have 30 days exactly.