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?
Simple calculation question
Re: Simple calculation question
Is it too much I'm asking for?
-
- Posts: 6458
- Joined: Tue Mar 20, 2018 5:34 am
Re: Simple calculation question
Hello,
You can use the following expression:
CountIf(x.DelayMinutes, x.DelayMinutes > 15) / Count(x.DelayMinutes) * 100
Thank you.
You can use the following expression:
CountIf(x.DelayMinutes, x.DelayMinutes > 15) / Count(x.DelayMinutes) * 100
Thank you.
-
- Posts: 2
- Joined: Sat Nov 30, 2019 6:28 pm
Re: Simple calculation question
Great, it does work flawlessly, thanks!
Re: Simple calculation question
You are welcome!