Creating Formulas for Metrics
Hi Everyone! I am looking to get some metrics for a dashboard. I am trying to make a formula that will give me the amount of entries I have on my grid. based on the Line of Business and the Quarter.
Both the Quarter and LOB columns are drop downs. Quarter has Q1, Q2, Q3 and Q4 while the LOB has Food & Beverage/Dining, Attractions, Merchandise, and Entertainment (currently Food and Beverage/Dining is the only entry type I have in my grid.)
I am trying to get the amount of entries under the Food & Beverage that are also Q1.
I have tried count and sum formulas but am getting the unparesable errors every time.
Thank you for any and all help 😁
Help Article Resources
Check out the Formula Handbook template!