Tool Tip - Percent of the whole

15 views
Skip to first unread message

Bucky Bush

unread,
Mar 29, 2023, 9:39:31 AM3/29/23
to googleschoo...@googlegroups.com
The graph below is showing the median test percentile in previous grade levels for current 4th-grade and current 5th-grade students.

The tooltip in the screenshot shows that the median test percentile for current 5th graders on their 2nd-grade test was 62. However, it then shows a percentage in parentheses for that number based on the sum of all of the numbers in the grouping. This number is not meaningful (and in this case, misleading). Does anyone know of a way to display the information below without Looker Studio calculating the percentage of the total?

image.png

  Bucky Bush

Technology Director

📞 706-295-6189 x 139

Equip, Empower, and Serve Educators

Tell us how we can help you!

Laura Tilton

unread,
Mar 29, 2023, 1:35:48 PM3/29/23
to googleschoo...@googlegroups.com
Hey Bucky, this may sound weird, but try changing the chart type to 100% stacked bar, then uncheck the 100% Stacking, then uncheck Stacked Bar to bring it back to this format, and see if the % label goes away.

Laura

--
You received this message because you are subscribed to the Google Groups "Data Studio in Education" group.
To unsubscribe from this group and stop receiving emails from it, send an email to googleschool-data...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/googleschool-datastudio/CAP64YmqhLWR8_PkJBwQ_%3DUFp3OqYTgN1J5gJFJ7ac1i0jUWKmw%40mail.gmail.com.

Bucky Bush

unread,
Mar 29, 2023, 2:26:49 PM3/29/23
to googleschoo...@googlegroups.com
Laura,

That worked. Thank you for sharing your knowledge with us!

Screenshot 2023-03-29 at 2.25.47 PM.png

  Bucky Bush

Technology Director

📞 706-295-6189 x 139

Equip, Empower, and Serve Educators

Tell us how we can help you!

Reply all
Reply to author
Forward
0 new messages