Forum Discussion

marshala's avatar
marshala
New Member
7 years ago
Solved

Plot columns with multiple values

Hi I have a load of survey data, some of the questions were multi-select responses which I need to visualise. The data looks like this Response ID Natural Hazard Fire ClimateChange Economic ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi

     

    How are you looking to present the data?

     

    If you are simply looking to represent each one selected with a count you can create seperate measures for each type as follows:

     

    Natural Hazard Count = 
CALCULATE(
DISTINCTCOUNT([Response ID]),
FILTER(Table, [Natural Hazard] = "Natural Hazard")
)

    However, if you are looking to combine these, you are best transposing the data in the query editor.

     

    Hope that helps.

     

    Thanks

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi

 

How are you looking to present the data?

 

If you are simply looking to represent each one selected with a count you can create seperate measures for each type as follows:

 

Natural Hazard Count = 
CALCULATE(
DISTINCTCOUNT([Response ID]),
FILTER(Table, [Natural Hazard] = "Natural Hazard")
)

However, if you are looking to combine these, you are best transposing the data in the query editor.

 

Hope that helps.

 

Thanks