Forum Discussion
Two dates from the same date column
Hi BhaveshPatel the page level filter is going to be constant throughout. But Jan to June and July to December is just a sample I gave. It need not always be the same. Sometimes they might want to compare between Jan to March with July to Sept or Jan to March with Oct to December or between any two period for that matter like July to Sept 2015 with July to Sept 2016 . So I don't think Page level filter will be a good idea. Your thoughts ?
Hi thanish,
From my perspective of view, as you want to compare sales between any periods, it is better to have another two calendar tables and create relationships among the three tables( calendar tables and sales table) as OwenAuger's post. That way, it is more convenient to select different months in the two slicers and compare sales.
Thanks,
Lydia Zhang
Hi Anonymous yes I was convinced with OwenAuger approach and it seems to be good. But the apporach was produced on a monthly basis if it could be produced on a day format it would be great. We want the select and comparison between dates for other calculations also. Suppose we want to check the sales made by a employee from Jan to March and compare his sales for June to August(need not always be same and also need not always be in months, the comparison can also be in days like 15 or 20 days) we want to have something like what is in the attached photo in addition to what I have asked before like seperate charts.
So what you see X in the chart is the sales for the selected date and Y is the sales for the comparison date. In the table below you can see the Date/Date column which explains about the sales difference for the given selected and comparison period for an employee(this would not be required to be displayed though) which would be used to calculate the percentage in the next column.
If anybody could help me replicate the exact chart and table below it would be great
Hi Anonymous yes I was convinced with OwenAuger approach and it seems to be good. But the apporach was produced on a monthly basis if it could be produced on a day format it would be great. We want the select and comparison between dates for other calculations also. Suppose we want to check the sales made by a employee from Jan to March and compare his sales for June to August(need not always be same and also need not always be in months, the comparison can also be in days like 15 or 20 days) we want to have something like what is in the attached photo in addition to what I have asked before like seperate charts.
So what you see X in the chart is the sales for the selected date and Y is the sales for the comparison date. In the table below you can see the Date/Date column which explains about the sales difference for the given selected and comparison period for an employee(this would not be required to be displayed though) which would be used to calculate the percentage in the next column.