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

Filter KPI with one filter but not the other

Hello!

I have a KPI that updated depending on the filter selected. I have two filters, Building and Week. I need for my KPI NOT to change when a week is selected. I tried a few things like this:

Count({$<Week=>} {<xtype={'Eyewash Station'}>} xtype)

But that doesn't work, any ideas?

 

Thanks!

1 Solution

Accepted Solutions
agigliotti
Partner - Champion
Partner - Champion

maybe this:
Count( {< Week=, xtype = {'Eyewash Station'} >} xtype )
I hope it helps.

View solution in original post

4 Replies
agigliotti
Partner - Champion
Partner - Champion

maybe this:
Count( {< Week=, xtype = {'Eyewash Station'} >} xtype )
I hope it helps.
hammermill21
Creator III
Creator III
Author

Oh, I see what I did wrong!

 

THANK YOU!!!

nbuscemi
Contributor III
Contributor III

What if I do NOT want the total residents in a KPI to change when multiple filters are applied? Because the residents are always the same no matter what filter is applied.

Filters are EXPENSE CATEGORY, TRIAL PHASE,  YEAR, drill-down dimension THERAPEUTIC AREA, PRODUCT?

 

Thanks

agigliotti
Partner - Champion
Partner - Champion

try this:
Count( {1< xtype = {'Eyewash Station'} >} xtype )