Create Chart from Dropdown (Multiple Select)

Brandon Bear
Brandon Bear ✭✭
edited 06/14/22 in Add Ons and Integrations

Hi and Thanks In Advance,

Essentially I would like to create a chart based on one column of Dropdown (Single Select) data (Status) and one column of Drop Down (Multiple Select) data (Goal). I'm aware I will probably need a helper column somewhere in there, but I cant get ym head around what it might be.

Each row of data is linked to anywhere between 1-5 goals - I would like the chart to show for each goal how many projects are marked with each status - where a project is assigned to more than one goal it should be counted / presented against each goal. For example, a project aligned to goal 2 and 4 with a status of in progress should show in the chart under goal 2 and goal 4 with an inprogress status.

Not sure if this makes sense, hopefully someone can help