4 Replies Latest reply: Aug 10, 2018 10:22 AM by Liam Grover RSS

    How to write expression to Count([Job ID]) by another dimension

    Christopher Jackson

      Hi all,

       

      Here's what i'm trying to achieve.

       

      I have a list of jobs. I can count the number of jobs by using Count([Job ID]) as the expression. I'm creating a table that shows those counts as the expression with a dimension of Zone Name. But of those jobs, some were completed, some were cancelled and some were lost. I want to create a table with columns for each of those, so like a column with Count([Job ID]) for completed, another column with Count([Job ID]) for cancelled and another column with Count([Job ID]) for closed.

       

      I know this is probably incredibly simple, but i'm just not sure about the syntax for how to write the expression. Can someone help me?

       

      Thank you!

       

      Chris