topic Re: adding multiple filter in Connectivity & Data Prep

adding multiple filter

Anonymous — Thu, 11 Jan 2018 10:55:07 GMT

Hello,

Can you please help me in adding multiple filter in #kpi

At present i have used this formula

Count({$<Position={"changed"}>}distinct [Customer Name])

now i need to add another filter (year = 2016) to this.

Thank you in advance,

Sachin

luismadriz — Thu, 11 Jan 2018 11:07:12 GMT

Hi,

please try this if year is numeric:

Count({$<Position={"changed"},year={2016}>}distinct [Customer Name])

I hope this helps,

Cheers,

Luis

Anonymous — Thu, 11 Jan 2018 11:12:49 GMT

Hello Luis,

This works, Thanks a lot.

Cheers,

Sachin

luismadriz — Thu, 11 Jan 2018 11:38:24 GMT

Good,

When you get a chance please close the thread by marking helpful/correct replies,

Cheers,

Luis