Percentage of Total - in a Tree Map and on a Bar Chart?

[rkoldanov]

Hi all!

A quick question here that I can’t find the solution of…
I have the number of orders per country. I want to visualise the % of the total number of orders, for every country. Whatever I do, I only get the number, not % of total.

I hope it would be possible without additional calcs, as this is quite a simple thing to do?

The perfect case would be showing it both in a tree map visualisation, as well as on a bar chart visualisation. Anyways, even only one of these would help.

Thank you in advance!

[Maddie]

Hi Rangel,

To my knowledge, it is not possible to do this based on a standard measure (sum, count etc).

However, adding a measure of type: percent_of_total on top of your standard measure might work well for some of your use cases.

The details for this, together with an example, are available on the docs page below:

Looker Documentation

Measure Types

LookML parameter: Specify the type of measure.

Hope it helps!

Best,
Maddie | Redkite

[Dawid]

If you want to do that in Table Calculations, enable Totals in your result data table and then create table calculation <measure> / <measure:total> and select percent_2 as Default Formatting