Forum Discussion

PaulBoden's avatar
PaulBoden
Helper I
4 years ago

Hide bar from Stacked Bar Chart without excluding data/ Percentage of total population while filter

Hi all, 

 

I have a stacked bar chart showing  individuals with outstanding training by area and job title. I want to see these as a percentage of all individuals however, if I exclude those individuals who have completed all mandatory training to date, I only get percentage values for the sub-set, rather than the whole population.

 

If I include the full data-set in the chart, filtering out those who have completed the training achieves the same result, and including the values as a separate column diminishes the value of the chart as the smaller values become difficult to differentiate (see below).

 

 

Can anyone advise how I can hide a column from the chart without excluding the data? Or alternatively, any other suggestions as to how I might show a percentage of the total population, while only included a sub-set of the population in a chart, would be greatly appreciated.

 

 

TL;DR: How do I show in a stacked bar chart the percentage of the total population meeting specific criteria, without including a column for every possible set of criteria?

Need Help

1 Reply

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi PaulBoden 

    Thanks for reaching out to us.

    According to the description, I think this may be related to the table in the filter() function. Have you tried using the all() function? If you need to more help, please provide information below, 

    (1) a sample file, you can replace raw data with bogus data to protect your privacy.

    (2) or provide some sample data that fully covers your issue/question

    (3) give your expected result based on the sample you provide

    Thanks.

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.