Transform Grouping To Matrix issue

Grafana Developers & API
1
  • What Grafana version and what operating system are you using?

9.0.6

  • What are you trying to achieve?
    Data transformation using
    image

  • How are you trying to achieve it?
    using SQL and Transform tab " Grouping To Matrix"

  • What happened?

    image
    image558×514 33.2 KB

  • What did you expect to happen?
    even if there are blank columns, addition shud be numeric rather than string concat