Customized tooltip in Looker

[SimonaHuware]

Hi All, I created a histogram on Looker with Stacked Percentage values. I need to create a tooltip that allows me to see all the values ​​represented in it according to the following format:

Tooltip Title:

Series 1: value %
Series 2: value %

I added this code in the Edit Chart Config, but I can't get the desired result:

{
  tooltip: {
    format: '<span style="font-size: 1.2em">Title</span><br/>{#each points}<span style="color:{color}; font-weight: bold;">{series.name}: {y:,.2f}</span><br/>{/each}',
    shared: true,
    useHTML: true
  },
}

The problems with this code are that:

• it returns the values ​​in absolute value and not in percentage (I also tried to use the format {:.2%} but it doesn't work);
• the indentation comes out with "series name" and line break ": value".

I also tried adding some functions(), but they are not supported by Looker.

Could you help me modify the code to make it work as I would like?

Thank you very much

[dsimeonova]

Hey @SimonaHuware !
Hope i'm still on time with the reply.
Did you check the options for adding tooltips from the documentation?:
https://cloud.google.com/looker/docs/best-practices/cookbook-visualizations-tooltip-customization
This is the native option using Liquid that I highly recommend to try if you didn't.
As well, here in this article it explains the different 2 options - using the Advanced Chart Editor and the native option:
https://medium.com/@sibineejokela/editing-and-customizing-tooltips-in-looker-912d2e72cdf5

Hope it helps you! Please share if that's the case or if you have any further questions.
Happy to help!
Desi, 😊

[SimonaHuware]

Hi,
thanks a lot for your answer. Unfortunately I had already looked at both links you sent me and none of the suggestions seem to work for a histogram. (The code I wrote inside the question for example works well for a trend line, but not for the histogram.)
I don't even know how to write it using HTML directly in the measure, because I would have to tell it that, regardless of the section I'm on with the mouse, it must show me in the tooltip all the values ​​of that series like this:

Series 1: value %
Series 2: value %

The rendered_value is not enough for this.

Thanks again anyway for your answer and have a good day!