Does anyone know of a good way to compare many entities in one visualization?
Example: I need to provide users with a way to compare different organizations’ profits over a few years. The idea is to allow them to quickly scan trends across all the organizations and spot which orgs look interesting and should be drilled into.
So I’m using an Org dimension, a Year dimension, and a Profits measure. The issue is that there are 20+ Orgs with a wide variance in Profits. When I display as a stacked line chart, the Orgs with extremely high profits force all of the other lines to flatten out, and its impossible to view trends with this many lines.
I also thought about doing a pivot table with conditional formatting to show trends over the years for each Org, but conditional formatting doesn’t work on a row by row basis. So that doesn’t actually help with viewing trends within a single Org.
My ideal solution would be something like this, I think. But I don’t think that’s possible in Looker (screenshot example is from Tableau)
Anyone have any ideas?