I created a chart, which shows me a KPI from yesterday, the day before yesterday and it´s variance (The data is broken at the moment, so results are completely wrong).
Afterwards I created two alerts, which for test purposes only alerts when there is no change (which is not possible), One on "Most recent" and one on "All items".
Unfortunatley, I get the following notifications:
As you can see Alert 1 has no value, I guess the alert takes today as most recent day vs. I don´t know which day.
Alert 2 shows me a wrong variance, so that is also not possible.
Could some one explain to me how the alerts specifically work? All documents on alerts are rather unhelpful and very superficial.
I have to believe this is possible, but it may depend on how you have implemented the functionality to show only yesterday and the day prior. Did you apply a filter to the card? Or did you use a Beast Mode calculation to build that logic? Other?
Here's how I accomplished what I think you're trying to do:
Does that get you what you need?
thanks for your reply!
At the beginning I used the date range option within the card, because this didn´t work out. I adapted my source, so I matched every day with its previous day via SQL. Now it is working!
I think we did the same thing, but you fixed it in beastmode, which is maybe a more efficient way!