tom_rotchadl Member

SUM(`Training Hours`)/COUNT(DISTINCT Employee Email) This works, but leads to a further question. This Beast Mode is powering a single value card. The card is on a dashboard that also contains a date filter card, which is filtering on another field Completion Date. I would like the single value card to display the average…

Thanks for that solution @ArborRose. It works well for this example. What if there are more than five possible strings, for example, what if any city in the U.S. could appear and the data set has tens of thousands of rows? It wouldn't be reasonable to make a INSTR for every potential. Any ideas on how to make this scalable?