Hello,
I'm using a piece of script that counts the number of employee names that have a RANK between 0 and .10 when the Manager Type = 'IP'. The script is counting correctly. However, when the user selects a Manager Type other than 'IP', the chart displays all zeros. The appropriate behavior is to always display data for Manager Type = 'IP' regardless of what manager type is selected from the filter. A few of has have looked at this, but we haven't figured out what's missing.
Any thoughts?
sum({<[Manager Type]={'IP'}>}
Aggr({<[Manager Type]={'IP'}>}
if(
(Rank(Total -
aggr(Count({<[Manager Type]={'IP'}>} [Hospital Account Id]),[In Progress Laborlytics Name])
/
aggr(sum({<[Manager Type]={'IP'}>} [Productive Hours]),[In Progress Laborlytics Name]),1)
/
count({<[Manager Type]={'IP'}>} total [In Progress Laborlytics Name]))
> 0 and
(Rank(Total -
aggr(Count({<[Manager Type]={'IP'}>} [Hospital Account Id]),[In Progress Laborlytics Name])
/
aggr(sum({<[Manager Type]={'IP'}>} [Productive Hours]),[In Progress Laborlytics Name]),1)
/
count({<[Manager Type]={'IP'}>} total [In Progress Laborlytics Name]))
<=.10,
count({<[Manager Type]={'IP'}>} [In Progress Laborlytics Name])
)
,[In Progress Laborlytics Name]
,[Manager Type]
,[In Progress Coder Manager]
))
