Sql query - group/tags

Grafana Configuration
1

Hi,
I’m doing a SQL query which is

select distinct AccountCode FROM customers

Which works fine, but I would like to group some of the customers such as

External
Internal

I do not have such information on the database, I seen that grafana does the Value groups/tags (Experimental feature)

Does any know how can I run my sql query above to group some of the customers as tags/groups?

I cannot find anything related to sql queries.

Thank you in advance for your help.

2

Hi, @thesvan!

To group the data the way you described, you need to adjust your query to do it based on some values. You can either use currently existing data or add new columns.

Best regards,
Lukas