Count occurrences of each variable of a multi-dropdown list
Hi, I'm building a lease administration tool to help negotiate some leases. Each row (lease) has several stages (preliminary, negotiating, at lease, executed lease, open). I want to create a dashboard metric to show how many rows are at a particular stage:
Preliminary - 5; Negotiating - 3; At Lease - 7, etc...
What would I do to count the occurrences of each variable in the drop down list so I can use them in the metric widget?
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!