Straight Table with Counts

[evansabres]

I am looking to create a straight table for my field JobStatus.

I want the dimension to be JobStatus and the expressions to be counts of the occurrences of different values in this field such as 'Awaiting Approval'

I am struggling with the expression.

[hector_munoz · Accepted solution]

Hi Evan,

With JobStatus as a dimension, just Count(JobStatus) as expression.

Regards,

H

[evansabres]

I just realized that I had a typo in my expression. I was surprised it wasn't working. Thank you for your reply.

[krishnacbe]

Your Dimension will be JobStatus and expression should be count(JobID), ID/Key filed available in the table.

Share some sample data to check.