Can I combine columns to create one column for a pie chart/bar graph visual?

deona720

In Salesforce, about 9 checkbox fields track whether a member signed up for that specific event.

For example:

But when creating a pie chart or bar graph, this becomes problematic because they are all separate rows. Is there a way to combine the data so I can have a member count for how many members signed up for Event 1 and so on?

GrantSmith

You can use a dataflow / magic Etl to pivot your dataset so that you have the columns member and event and signed up and then filter for signed up = TRUE

You can then use that output dataset in your pie chart with the event as the series and do a count of the members

GrantSmith

You can use a dataflow / magic Etl to pivot your dataset so that you have the columns member and event and signed up and then filter for signed up = TRUE

You can then use that output dataset in your pie chart with the event as the series and do a count of the members

deona720

@GrantSmith Could you elaborate on how I can do that in an ETL?