nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Heat Chart - show percentages instead of count

JessicaSmucker

It would be nice if the heat chart had an option to show by percentage instead of count, similar to the stacked bar chart.

Vind meer berichten getagd met

Status: Openen

Reacties

ChrisWesson

Thanks for the idea Jessica. Customer feedback is invaluable to helping us improve the product.

First we need to clarify "percentage of what"?

If you mean of the category, just like stacked bar chart, then this might present some problems as heat chart is multivariate. Cells are colored by the numeric value associated with the two variables in both the connecting row and column. So choosing just one of the categories would be misleading.

If you mean as a percentage of the overall sum of values for the table, then this could be possible as a user option but only for the statistic SUM. It wouldn't work for other summary statistics such as averages.

Presuming you meant the latter, which is almost like a new classification type, we will take a look into it as possible future enhancement. Really good idea, thank you!

Anyone reading this thread can find out more about heat charts here.

JessicaSmucker

Hi Chris,

Thanks for considering my idea! I actually meant the former, but I see why it wouldn't work in the setup from your explanation. For my particular dashboard, it would be nice to be able to show a percent based on a ratio within both categories kind of like this, but you could select to show by "yes" or "no" percentage:

	Cat	Dog
Do you like to go on a walk?	(10% yes, 90% no)	(90% yes,10% no)
Do you like to watch the fish tank?	(80% yes, 20% no)	(10% yes, 90% no)

JessicaSmucker

Hi all! I figured out a way around this if anyone's curious...Using the example above, only for one question.

Create two columns:

- First column: IF(Cat_Yes_No="Yes",1,0)

-Second column: IF(OR(Cat_Yes_No="Yes",Cat_Yes_No="No"),1,0)

Create a summary table (make sure summary table is dynamic)

-column for category across

-column for category down

-sum of First Column created above

-sum of Second Column created above

-create new column called YesPercent - ((First Column/Second Column)*100)

Create heat chart from summary table based on:

-column for category across

-column for category down

-YesPercent

Doe mee aan het gesprek

Meld je aan om te posten, content te volgen en meer. Nieuw hier? Registreer gratis.