tom_rotchadl

Discussions

Sum a column and divide by the count of unique entries in another column
I have a dataset around training. Each row represents a training course taken by an employee, so each employee will have many rows (1 for each training course taken). One of the columns is training hours. I would like to make a single-value card that shows average training hours per employee. In excel, I would sum the…
How to count strings in a column containing a comma delimited list of strings in each row
Hello, I have a field in which each row contains a comma delimited list of strings. I'm trying to find a way to display how often each string appears in the dataset. For example, the column might be "City": Row 1 | New York,Boston,San Francisco Row 2 | Boston Row 3 | New York,San Diego Row 4 | New York,Topeka I like to…