Traffic light manipulation
I would like to have a traffic light that does not show red or green based on the last given status, or even the overall average. I would like the measure behind it to calculate the last 30 days of results, and then display a red or green traffic light based on whether or not 95% of the results in the last 30 days are below the given threshold. Is this possible? If it can't be done exactly like that, is there a close approximation I can attempt? This is an attempt at having a live/dynamic monthly report in the form of a dashboard.
I did enable that at the time I was making your other changes. When you say 'wait a bit' does that mean it only calculates percentile data from the time I checked that box? or it just takes a few minutes to calculate going back to when the measure was first subscribed to?
Yes. only from that point on are we calculating the percentiles that we also store in the performance warehouse.
Hi Paul, for Andi's suggestion to work you need to make sure that you enable percentile data for your measure
Edit: Looks like Andi is saying the same thing
- but yours is better with the screenshot.
Hi Andreas, thanks for your suggestions. I made the changes listed above, but the traffic light are always green. The measures are for DB connection time. I changed the threshold to 1ms to try and force it red, but it is always 'ok'. The value when i hover over the traffic light is always 0.0ms. I can see, however, that the data is being captured through other chart types like a line chart.
Hmmm - can you try edit that measure - click on the second tab and check the box "calculate percentiles"? then you need to wait a bit until enough data is there so that percentiles are calculated. but - please give this a try. if this doesnt work either I will double check with our team here and see if there is a different way
Here is what you can try
#1: change the timeframe of that chart to 30 days
#2: toggle to see the table as well in your chart dashlet. On your measure open the context menu and select Aggregation -> Percentiles -> 95th
#3: see if that is working for you
Andi
adding as reply so you are more likely to see it.
Hi Andreas, thanks for your suggestions. I made the changes listed above, but the traffic light are always green. The measures are for DB connection time. I changed the threshold to 1ms to try and force it red, but it is always 'ok'. The value when i hover over the traffic light is always 0.0ms. I can see, however, that the data is being captured through other chart types like a line chart.
