Dynamic Top N Tooltip Beast Mode

david_cunningham

Is there any way to create a tooltip that would allow me to display the the top 3 customers on hover for a given category? For the sake of this discussion, let's just pretend that I have a map of the USA, and I want to be able to hover over a state, and have the tooltip show the unique names of the top 3 customers for that state by Revenue.

I know that I can do this in an ETL, but I want to do it in a beast mode so that any page filters applied will impact the top 3 shown. For example, if a particular product class is shown, the outcome should update to show the top 3 for a given state for the selected product class.

JedP

Hi @david_cunningham ,

This is likely possible with some type of tool tip use and a windows function, let me test out a few examples and if i can get one working ill post the results here.

ColemenWilson

Would love to collaborate on this with you @david_cunningham . I can get the rank of each customer by state in the beastmode, but I am having trouble with displaying them as a hover text. You'd need to use something like a group_concat() which I can't get working in a beastmode.

david_cunningham

@ColemenWilson yeah, that's about as far as I got as well. Would love to connect and figure this out together. Curious to hear from Domo peeps what they think is possible on this front

DavidChurchman

I don't think you can concatenate strings across rows using BeastModes, which seems to be the fundamental challenge here. I'm mostly commenting in case I'm wrong and someone posts a way to do that.

Depending how many different types of filters you have and how many different product categories, you might be able to create every possible iteration of top three customers for each potential filter in an ETL and do it that way. You'd end up with a lot of redundant data, so you'd have to use FIXED functions on the card. I don't recommend this, but I think it would be theoretically possible.

I'm assuming you know this, and it's not what you're asking for, but it would be a lot easier to have a separate table card that you could cross filter with the map: click on a state and see the top three customers from that state (plus any other filters you've added).

david_cunningham

@DavidChurchman - yes, the table card approach is usually what I have done in the past. I was mostly just curious and posting due to yesterday's Frenzy day. I was hoping that someone at Domo would know of a way to achieve this. I think that tooltips are somewhat of an under-developed / under-utilized feature, and thus have been looking for ways to use them more effectively.