Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone. I need help finding out new accounts created each year from 2014 to date. The set expression below is what I have but it brings up nothing. I need to get the number of new accounts created each year. Thanks
Count({<[Contact Created Date]={$(Year(Today()))}>}[Contact ID])
Hi
Can u please elaborate if in which visualization like a table , KPI, etc
If you want in the table take dimension as Year([Contact Created Date])
and for Measure Count([Contact ID])
Hope this helps
Thanks
Thanks for your reply but its not giving me what I want. I need values in each year to be unique. That is, a contact name should appear only once and that is on the year the contact was first created.
Hello everyone thanks for the suggestions but this is what worked for me. For dimension I used
Contact Name
and measure
MinString([Contact Year]) as measure
This gives me the account name and first year it was contacted which is the year it was created