OpenTSDB query tags to rows and columns

Grafana Configuration
1

  • What Grafana version and what operating system are you using?
    v8.1.8

  • What are you trying to achieve?
    I’ve an OpenTSDB query that has 2 tags of my interest podName and stepNumber. What i’m trying to do is extract these fields and use podName as row and stepNumber as column and the metrics values in the table cells.

Query:
ALIASBYTAG(-1h:synthetics..AGG.all:kaiju_CUJ__-CRM-All-__Edit__case_availability{location=,podName=,testCaseId=32062,ownerId=1957,level=testStep,stepNumber=}:avg, #podName#, #stepNumber#)

  • How are you trying to achieve it?
    I’ve tried using series to rows transform but that gives me a metric field with “podName,stepNumber” as values and the Value field has the metrics value.

  • What happened?
    I’m unable to transform these fields to rows and columns.
    It displays the table like this

time               podName,step      Values
12:12:12.             xy01,1                -1
12:12:15.             gh03,3                1
  • What did you expect to happen?
                   step1   step2
podName1       1.         1
podName2       1        -1
podName3       1          0

  • Can you copy/paste the configuration(s) that you are having problems with?
    ALIASBYTAG(-1h:synthetics..AGG.all:kaiju_CUJ__-CRM-All-__Edit__case_availability{location=,podName=,testCaseId=32062,ownerId=1957,level=testStep,stepNumber=}:avg, #podName#, #stepNumber#)

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    No

  • Did you follow any online instructions? If so, what is the URL?