Dynamic Top N Tooltip Beast Mode

Options

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.

David Cunningham

** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**

Tagged:

Answers

  • JedP
    JedP Domo Employee
    Options

    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
    edited June 26
    Options

    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.

    If I solved your problem, please select "yes" above

  • david_cunningham
    Options

    @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

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

  • DavidChurchman
    Options

    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).

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

  • david_cunningham
    Options

    @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.

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**