Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Row percentages with in a breakdown

andrewz_webmd
Level 2
Level 2

Ok bear with me here...

Row percentages with in a breakdown seem require the full metric field to be included in order to be calculated across the row. Otherwise it calculates across the entire report.

 

Why does the system generated percentages not match the calculated percentages?

 

Within a breakdown, the system generated ROW percentages are actually percentages of the higher level dimension for that specific day.

 

See screenshots below...

 

i.e. Reference and Tools breakdown for Sept 1... Aud Non Registered User Page Views shows a ROW percentage of 25.6%. That is NOT 25% of page views on 9/1 within the reference pillar. Its actually shows that the 811K page views are 25.6% of the entire page views for the entire day. (see 2nd screenshot to compare)

 

811,220 / 0.2561058 = 3,168,828 (This is the total page views across the site for 9/1 NOT for just the parent row)

 

Non Reg + Reg PV = 811,220 + 841,128 = 1,652,348 - This matches the total page views for the reference pillar for 9/1/20.

 

I really hope this makes sense...

 

andrewz_webmd_2-1610636007147.png

 

Below is only 9/1 to show the total PV for the day referenced above.

andrewz_webmd_0-1610636940055.png

 

 

 

 

3 Replies
ishans52004352
Employee
Employee

I think there is a setting that controls this, though not exactly sure. You may want to reach out to Client Care for a detailed discussion.

andrewz_webmd
Level 2
Level 2
Correct.. there is an option to change from "calculate percentage by row" vs "by column" and i have both the high level dimension and the breakdown dimension set to "row".... but its calculating across all high level dimensions and not only within the breakdown.