Filtering KPI

[One_day_I_will_know]

Hi all,

I have a  real rookie question: I want to build a KPI for which I need to filter dimensions. Everything works fine until I add two possibilities to one dimension.

This works:

Count(
{< Personnel.area = {'West'},
[Customers.Account_Class] = {'Under 100 keur'} ,
[Leads.Started.autoCalendar.YearsAgo]={[0]}>}
Leads.GUID)

This doesn't (I tried sets of commas and ors and ands without success):

Count
({< Personnel.area = {'West'} and
([Customers.Account_Class] = {'Under 100 keur'} or [Customers.Account_Class] = {'Unknown'}),
[Leads.Started.autoCalendar.YearsAgo]={[0]}>} Leads.GUID)

What is the right way to do this?

Leads.GUID)

[sunny_talwar · Accepted solution]

Try this

Count({<Personnel.area = {'West'}, [Customers.Account_Class] = {'Under 100 keur','Unknown'}, [Leads.Started.autoCalendar.YearsAgo] = {[0]}>} Leads.GUID)

[One_day_I_will_know]

Thank you so much! It's so clear when you know it 🙂

[hdombrowski]

Apologize if this is a simple question, but I have the whole of 1 day of experience at this point. I have an expression for a KPI to identify items that are greater than 90 days that is fixed when a filter is applied. Can you please help me on how to update this expression so it is dynamic for filters?

Count({1<[Days Oustanding]={">90"}>}[Amount in loc.curr.2])

[sunny_talwar]

May be not use the 1

Count({1<[Days Oustanding]={">90"}>}[Amount in loc.curr.2])

Count({<[Days Oustanding]={">90"}>}[Amount in loc.curr.2])

[hdombrowski]

Worked! Thank you

[sunny_talwar]

Awesome