Hello,
I have a data set that I have build a dashboard for showing customer feedback for a helpdesk service.
The questions the customer is asked request a number rating between 1 - 10. I am only really concerned, or action needs to be taken if a score of 6 or less is received.
Within my report I have a card that is just purely looking for the lowest rating, and I have an alert of that card to flag up to me if the lowest rating is less than 6.
The problem I have is that my data is refreshed regularly with the newest feedback scores and if the new lowest score is the same as the previous lowest score then my alert doesn't work (which does make sense to me because the figure in my card doesn't change), but the problem is I still need to know about it because action needs to be taken.
Can anyone recommend a solution to this?
Tia, Emily.
