Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi, posted earlier but had no reply.
I have a dimension Period. I only want to add field called "Customers" where the period = min (Period). Sounds so simple..
after determining Min Period, I need to add the rest to the expression, ...(I think I might be able to determine this with Firstsortedvalue as well, not sure how)?
=
(if(RangeSUM(COOKIE_1,COOKIE_2) > 0,
COUNT( distinct Customers))
can anyone assist urgently?
Thanks.
You could try like:
COUNT( distinct {<Period={'$(=Min(Period))'}>} Customers)
If your period field value and output of min() expression formats match, this expression should work.
You could try like:
COUNT( distinct {<Period={'$(=Min(Period))'}>} Customers)
If your period field value and output of min() expression formats match, this expression should work.
Thank you!