Set Analysis Equation

[evansabres]

I am looking to create a stacked bar chart that shows the following:

Number of projects worked on by an artist. An artist can work on four types of projects (JobType); Print, Digital, Motion or Video

I think I would need to have four separate equations, each referencing the different types of JobTypes.

My initial attempt didn't seem to work.

=NUM(SUM({$JobType={"Print"},}>}JobType)

How do I need to alter this?

[sunny_talwar · Accepted solution]

I think you just need to add JobType as your second dimension and then select stacked style on the style tab

Dimension

Artist

JobType

Expression

Count(JobType)

[evansabres]

I also tried this and it worked.

=NUM(Count({$<jobsJobTypeID={"1"},}>}jobsJobTypeID),'#,###.')