% of Total by dimension

benjamin_southern123

HI,

I have a measure (Configurations) which is split between three dimensions (a, b, c)

I'm looking to create a calculated measure where I can display the % of A versus the total

So something like SUM(Configurations, Dimension=A) / SUM[Configurations]

I can't get it to work, anyone know how to do this?

benjamin_southern123

answer is of course obvious, use a filtered measure.
Nevermind...

Vani

Can you share your solution @benjamin_southern123

benjamin_southern123

Sure,  you just create a Filtered dimension (Under Connect and Mix), then you can filter the value by a given dimension, then you can create a calculated dimension using the Original and filtered dimension with simple division formula

anita

Hi there, if you are eventually showing the category and metric within a table widget, you can also get the % of total for each dimension by activating this option under Widget Setting > Measurement options > % share of Total (show with):

 

This feature is rarely noticed, and very specific to the table widget.

luigiraw

@benjamin_southern123 the process of creating several filtered measurements is time consuming, but there is another way to do it, other than the one explained above for tables.

You can create a calculated measurement that will do the calculation across a whole dimension.

First you need to set some advanced settings (see below). The 'Month' granularity is key as this will set the data aggregation correctly.


You will then need to set the Aggregation Function to 'Sum' and then enter the formula as seen below.

NOTE: You can change both the measurement and dimension to one you need. The one below will split Visits by Device Type.


Some Examples
Visits by Device
SUM([Visits],[[Device_Category],[Month]])/SUM([Visits],[[Month]])

Impressions by Campaign Name
SUM([Impressions],[[Campaign_Name],[Month]])/SUM([Impressions],[[Month]])


I believe you can set the data aggregation to something such as day, week, or year but I have not tested these directly myself. If you do make the change, you would need to change all references throughout the Calculated Measurement (Advanced and Formula).

Vani

Hi @anita, Thank you this was what i needed, could you share more detailed screenshot where this exists. 

anita

Hi @Vani, great that you are exploring various widgets!
  
That option is specific to the table widget. You can look at the widget setting and check the options link marked below:



Here you can see the "Share of Total" option. Double click on the column/metric , you will see a dropdown - "show instead" will give you the % share of total instead of actual value.



I hope this helps!