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

deona720 · 2023-05-22T20:53:39+00:00

There was an error rendering this rich post.

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

For example:

Screen Shot 2023-05-22 at 4.47.03 PM.png

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?

Find more posts tagged with

Accepted answers

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

All comments

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?