Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
danieldors
Contributor III
Contributor III
‎2020-12-21 10:17 AM

Target by Cohort

Hello,

 

Im trying to color coordinate the employee production based on the employee cohort. I have a measure called Work Type, which Im not sure how to incorporate to the formula below, so that the employees production is measured against the average of their assigned cohort.

 

=if(sum([PPE History.Total Transactions])/sum([Hours Worked])>(sum([PPE History.Total Transactions])/sum([Hours Worked])),Green(),rgb(178,36,36))

369 Views
0 Likes
0 Replies