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

deona720
deona720 Member
in Charting

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?

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • deona720
    deona720 Member

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

Categories