I’ve created a Sumo Logic dashboard with a SingleValue chart to display some key metrics. It works fine for displaying aggregated data (e.g., percentage values). However, I want to add more details in the form of a tooltip to provide context, such as supporting metadata fields like support_page_action_count, granular_action_count, and tool_name.
Here’s my query:
deployment=xyz container=abc zone=123 <SearchString>
| json "log" as _raw nodrop
| json auto
| where tool_name = "ABC"
| fields percentage_granularized, tool_name, granular_action_count, support_page_action_count
| format(
"Support Actions: {0}, Granular Actions: {1}, Tool Name: {2}",
support_page_action_count, granular_action_count, tool_name
) as hover_text
| pct(percentage_granularized) // Working fine with SingleValue chart
// | fields avg(percentage_granularized), hover_text // Throws error
When I include the hover_text field in the query to enable tooltips, the chart throws an error:
Field hover_text not found, please check the spelling and try again.
Questions:
- How can I enable tooltips in a SingleValue chart to display metadata like support_page_action_count, granular_action_count, and tool_name?
- Is it possible to include a hover_text field alongside an aggregate value for a SingleValue chart?
- Are there any workarounds to achieve this?
Any help or suggestions would be greatly appreciated! Thanks in advance!