Hi,
I have a =COUNT(DISTINCT(COLLECT formula that is working in my sheet summary area. However when I try to recreate it in a metric sheet that pulls data from my sheet it only counts 1.
Here is the formula that is working in my sheet summary.
=COUNT(DISTINCT(COLLECT(Customer:Customer, [Who is your audience]:[Who is your audience], ="customer facing")))
Here is the formula that is NOT working in my metric sheet. It gives me a count of 1 when it should be 209.
=COUNT(DISTINCT(COLLECT({CX Global Presales Design Services Project Range 8}, {CX Global Presales Design Services Project Range 9} = "customer facing")))
Any idea what i am doing wrong on my metric sheet? Also how can i add a date range to the one being used on my metric sheet?
Thank you in advance for your time,