Forum Discussion

Benedikt42's avatar
Benedikt42
Frequent Visitor
3 years ago

Creating a stacked column in a chart and applying multiple filters

Hello everyone,

 

I have a bar chart with the number of doctors in our database.

I can apply the following filters to it: Classification, Country, Indication, Journals, Societies, Specialisation. I can always apply these filters.

 

In addition, I have the following filters, let's call them Filter2: Publication Score, Expertscape Score, H-Index, Connected on LinkedIn, Player Score. When I want to apply these filters, I want to mark in the same bar chart what proportion of the total number of doctors are filtered by Filter2.

 

Example: I filter in Country for "Germany" and in Indication for "Lung Cancer". Now I want the bar chart to show me the number of German doctors who treat lung cancer. We call this number Result1.

I now filter in Player Score for "3". This filter is to be applied to Result1, i.e. I have the number of all German doctors who treat lung cancer and have a Player Score of 3. Let's call this result2.
Now I want the bar chart to show Result1 and Result2 in a different colour at the same time.

 

Is that possible?

 

Thank you for your support and kind regards

 

Benedikt

1 Reply