How to count qualitative data & create bar charts in analysis

[starter888]

Hi everyone

I have a table with lots of qualitative data and am trying to create charts to analyse them. The fields are something like this:

Customer	Main Issue	Second Issue
ACME	Slow processing	Customer Service
Jovan	Online bookings	Customer Service
Regional A	Slow processing	Online bookings

I want to be able to create a visualisation that tells me the % of Main Issue, and then another one with the % of the Second Issue.

Many thanks from a beginner!

[JordyWegman · Accepted solution]

Hi Starter,

You can do the following:

Make a Bar Chart

Dimension: Main Issue
Measure 1: Count([Main Issue]) / Count(TOTAL [Main Issue])

Do this also for the Second Issue etc.Example for Main and Second Issue

 Jordy

Climber

[starter888]

Thanks Jordy for the quick help 🙂 

It worked!