Update docs to reflect: Multi-Timeseries only works when the group by value is a string

[austin-barrington]

What happened:
Multi-Timeseries only works when the group by value is a string when it is an int it is treated as a value. Please see the screenshots below.

The ask: Can you update documentation to reflect this behavior please.

Incorrect

Query: SELECT $__timeInterval(timestamp) as time, profile_id, avg(cpu) FROM default.serverstats WHERE $__timeFilter(timestamp) GROUP BY time, profile_id ORDER BY time ASC

Correct

Query: SELECT $__timeInterval(timestamp) as time, toString(profile_id), avg(cpu) FROM default.serverstats WHERE $__timeFilter(timestamp) GROUP BY time, profile_id ORDER BY time ASC

Anything else we need to know?:

Environment:

• Grafana version: 8.5.3
• Plugin version: latest
• OS Grafana is installed on: docker
• User OS & Browser: chrome/windows
• Others:

[austin-barrington]

If you agree I'll raise a PR

[asimpson]

Hi @austin-barrington 👋 Thanks for reaching out. Let me look into this one and get back to you.

[bossinc]

@austin-barrington Are you using the Prepare time series transformation and making the results a multi-frame time series? If so, it says string values are represented as labels. 😃

[bossinc]

I am closing this issue. Please reopen if you are still experiencing this problem.