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.
Answer by Paul H. ·
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.
Answer by Paul H. ·
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
Answer by Andreas G. ·
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.
JANUARY 15, 3:00 PM GMT / 10:00 AM ET