With this one can pre-program not only possible fields to display but also some functi

Allow "(" in unescape macros about clickhouse-grafana HOT 3 CLOSED

altinity commented on June 11, 2024

Allow "(" in unescape macros

from clickhouse-grafana.

Comments (3)

hagen1778 commented on June 11, 2024

Hi @podshumok
Sorry for late response. I have just tried to use some func in unescape macros and it works well:

SELECT
    $unescape(intDiv($col, $col2)) d,
    count()
FROM $table
WHERE $timeFilter and $unescape($col) = 1
GROUP BY d

Converted to:

SELECT intDiv(Aid, Ms) d, count() 
FROM default.events 
WHERE EventDate BETWEEN toDate(1519404902) 
AND toDate(1519405682) 
AND EventTime BETWEEN toDateTime(1519404902) 
AND toDateTime(1519405682) 
AND Aid = 1 
GROUP BY d

Can u provide me with full example of query?

from clickhouse-grafana.

hagen1778 commented on June 11, 2024

Closed due to inactivity

from clickhouse-grafana.

code-of-kpp commented on June 11, 2024

Hello!

So I finally figured out an example that is simple enough to demonstrate

Here is a minimal dashboard with problem I am dealing with:

{
  "panels": [
    {
      "datasource": "clickhouse",
      "id": 2,
      "targets": [
        {
          "format": "table",
          "query": "SELECT\n  $unescape($f) AS b\nFROM (\n  SELECT * FROM system.numbers LIMIT 1\n)"
        }
      ],
      "type": "singlestat"
    }
  ],
  "templating": {
    "list": [
      {
        "current": {
          "text": "count",
          "value": "count()"
        },
        "multi": true,
        "name": "f",
        "options": [
          {
            "selected": true,
            "text": "count",
            "value": "count()"
          },
          {
            "selected": false,
            "text": "sum",
            "value": "sum(number)"
          },
          {
            "selected": false,
            "text": "other",
            "value": "concat('a', toString(number))"
          }
        ],
        "type": "custom"
      }
    ]
  },
  "title": "New dashboard"
}

Looks like a problem
In this case macros will add additional ) after function call and it also will replace '' symbols in the variable (see other option)

from clickhouse-grafana.

Recommend Projects