Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
harsha
Creator
Creator

set analysis with Sum

Hello Experts,

this is my data and i'm trying to have multiple accuracy gauge charts based on diff fields.

 

I have taken this expression  "(Sum(Sample)-sum(Errors))/Sum(Sample)" to get total accuracy. 

however, I want to show where "Domain" is K360. 

What is the set analysis expression to achieve this? pls help

Guage.png

Labels (3)
1 Solution

Accepted Solutions
sunny_talwar

Try this

(Sum({<[IQM Domain] = {'K360'}>} Sample) - Sum({<[IQM Domain] = {'K360'}>} Errors))/Sum({<[IQM Domain] = {'K360'}>} Sample)

View solution in original post

2 Replies
sunny_talwar

Try this

(Sum({<[IQM Domain] = {'K360'}>} Sample) - Sum({<[IQM Domain] = {'K360'}>} Errors))/Sum({<[IQM Domain] = {'K360'}>} Sample)
harsha
Creator
Creator
Author

Hi Sunny...

thanks... it worked... appreciate your quick response