Hover Over Columns that aren't listed

Reply
Highlighted
Yellow Belt

Hover Over Columns that aren't listed

Hi,

 

Example: My data set contains the following columns:

 

date              weekend    count of events

18-03-2109      Yes            200

 

For my chart purposes, I use the dates as X axis and the counts as Y axis. What I need is that the Hover Text displays whether it's a weekend or not?

 

Is this possible?

 

 


Accepted Solutions
Highlighted
Black Belt

Re: Hover Over Columns that aren't listed

Tooltip fields!  Coming soon to a Domo instance near you.  (or you can contact your friendly domo success manager to be added to the beta)

1.png

 

2.png

 

 


______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________

View solution in original post


All Replies
Highlighted
Black Belt

Re: Hover Over Columns that aren't listed

Tooltip fields!  Coming soon to a Domo instance near you.  (or you can contact your friendly domo success manager to be added to the beta)

1.png

 

2.png

 

 


______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________

View solution in original post

Highlighted
White Belt

Re: Hover Over Columns that aren't listed

My tooltip field always displays as a count, and will not change to be the value of the chosen dimension(no aggregate). Any idea how to fix this? 

Highlighted
Black Belt

Re: Hover Over Columns that aren't listed

What kind of chart are you creating?


______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________
Highlighted
White Belt

Re: Hover Over Columns that aren't listed

Thanks for responding quickly, here is an image of what im currently working on.

 

Annotation 2019-05-06 153509.png

Highlighted
Black Belt

Re: Hover Over Columns that aren't listed

It looks like the tool tip field needs to be an aggregate calculation.

 

I can't tell what field you are dragging into it, but it looks like you are trying to drag Item to the tooltip.

 

If that is the case, then you don't need to use tooltip, you can use %_CATEGORY_NAME

 

However, if you want to use the tooltip, you will need to create a beastmode like

max(`Item`) 

or substitute `Item` with the field you are wanting to use.


______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________
Highlighted
White Belt

Re: Hover Over Columns that aren't listed

Im using item_description in the tooltip field, it's not used anywhere else on the card so I had read I needed to use tooltip. It's also a text field so I don't want to use an aggregates on it - I just want the value. Does that still apply? 

Highlighted
Black Belt

Re: Hover Over Columns that aren't listed

yes, you will need to aggregate it.  There should only be one Item Description for each Item though, correct?

 

In which case MAX(`Item Description`) will provide the same result.  However, if there are multiple descriptions for the same item, then you may not be able to make this work.


______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________
Highlighted
White Belt

Re: Hover Over Columns that aren't listed

Correct! I'll go ahead and give that a try. Thanks for you help! 

Highlighted
White Belt

Re: Hover Over Columns that aren't listed

@ST_-Superman-_ Is there a way to get a date into the tooltip? When I add the date field to the tooltip, it asks for an aggregation. 

 

Announcements
Coming Soon: Weekly Virtual User Meet-ups to answer all your questions! Stay tuned for more details to come this week.