Forum Discussion
Using a dynamic slicer and measures
Ok, so let's see if I got this.I had to work with my own data but the logic is still the same. My data went only till 31.12.2023 hence the slider on the top.
Some explanations:
- _F_Months_Back is a slider which counts how many months you wanna go back
- SPLY = Same Period Last Year
The 1st screenshot shows the situation today. Up till now, there have been 967 calls created (the Calls created until box which is the same as the top right reference box). The day is 31.12.2023. From the beginning of time (2021) and last year on 31.12.2022 were created 284 calls. (SPLY = 284).
If we go 1 month back (2nd screenshot) we see that:
- from 01.01.2021 till 30.11.2023 were created 950 calls which means the Delta for December is 17 calls
- from 01.01.2021 till 30.11.2022, the SPLY, is 256 calls which means that in December 2022 28 calls were created (the Delta SPLY)
Same logic for screenshot 3.
To check the logic, we go 12 months back (last screenshot). As you can see, the Calls Created Until box is 284 which is exactly the initial SPLY.
Is this what you were looking for? You can go by days if you want but I thought Months make more sense. I can give you the measures if need be.
So do you want the ability to (even) select a period in the past and compare it with the same period the year before or just days from the past till present are enough? For example, do you want the period CW2 - CW4 2024 (and then compared to CW2 - CW4 2023) or just 1/2/3/n weeks from today?
For this example, we won't have that much data loaded. Currently, we are just looking at two years of data to look at these comp periods. As it relates to your example above, I would set my slicer to say Last 4 Weeks, Last 8 Weeks, Last 13 Weeks. The first measure would count the rows and the second measure would look at the data from the comp periods and display the comp data.
Ok, so let's see if I got this.I had to work with my own data but the logic is still the same. My data went only till 31.12.2023 hence the slider on the top.
Some explanations:
- _F_Months_Back is a slider which counts how many months you wanna go back
- SPLY = Same Period Last Year
The 1st screenshot shows the situation today. Up till now, there have been 967 calls created (the Calls created until box which is the same as the top right reference box). The day is 31.12.2023. From the beginning of time (2021) and last year on 31.12.2022 were created 284 calls. (SPLY = 284).
If we go 1 month back (2nd screenshot) we see that:
- from 01.01.2021 till 30.11.2023 were created 950 calls which means the Delta for December is 17 calls
- from 01.01.2021 till 30.11.2022, the SPLY, is 256 calls which means that in December 2022 28 calls were created (the Delta SPLY)
Same logic for screenshot 3.
To check the logic, we go 12 months back (last screenshot). As you can see, the Calls Created Until box is 284 which is exactly the initial SPLY.
Is this what you were looking for? You can go by days if you want but I thought Months make more sense. I can give you the measures if need be.