Stimulsoft Business Intelligence System | Forum

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?

Is it too much I'm asking for?

Hello,

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

Thank you.

Great, it does work flawlessly, thanks!

You are welcome!