Simple calculation question

[scoroop]

Hi Stimulsoft Team,
I have a problem doing some simple calculations and showing them in Dashboard.
Imagine my datasource is returning 5 records. They have field "DelayMinutes" which shows how much something was delayed.

I'd like to calculate and show percentage of delayed items where delayed means "DelayMinutes>15". Therefore I need to make a calculation like (LINQ to keep it simple):

Items.Where(x=>x.DelayMinutes>15).Count()/Items.Count()

How do I do that in dashboard indicator?

[scoroop]

Is it too much I'm asking for?

[Lech Kulikowski]

Hello,

You can use the following expression:
CountIf(x.DelayMinutes, x.DelayMinutes > 15) / Count(x.DelayMinutes) * 100

Thank you.

[Strelok_401]

Great, it does work flawlessly, thanks!

[Andrew]

You are welcome!