Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have 2 columns - one with dates and another one with people names. I want to prepare a KPI where i show the unique count of people who appeared on the latest date (which is 10th Jan in the given example). How can i achieve this ?
|
Hi, you can try with: Count(Distinct {<Date={"$(=Date(Max(Date)))"}>} Person)
Hi, you can try with: Count(Distinct {<Date={"$(=Date(Max(Date)))"}>} Person)
Thank you so much @rubenmarin . It worked 🙂