Skip to Content
0
Sep 09, 2019 at 06:17 PM

Calculating average on Breaks excluding zero and getting min value webi

95 Views

average.jpg

Hi All,

I have already posted a similar question, but no one was able to help me.
I 've been stuck on the following problem and was wondering if someone could help, please.

I want to calculate average based on the foll0woing scenario:

I want to get the lowest number of days (the far right numbers) that listed for each ticket(the numbers that you see on the far left) + add them up and divide them per distinct number of tickets. As you can see on the attached pic, I just want to be able to get average on the numbers that highlighted in blue. Now, if there is value of zero or null for a ticket, I don't want to include those.

I also have a threshold, which, is a constant (7). Now if the output of the average function is less than the threshold, then a red bar will be shown on the chart that I have in my report. Otherwise the color of the bar would be green.

Attachments

average.jpg (44.8 kB)