Visualize single value format using DQL

[soportetr]

Hi Everyone, 

I am currently extracting data from logs to bring them into a dashboard I am working on. Initially, I was going to visualize it in tables as I show in the following image:

But then, an idea came to my mind and I want to visualize this data separately, but I have not been successful at all. In what way could this data be visualized individually?

I hope you can help me

Thanks in advance

[PierreGutierrez]

Hello @soportetr 

Exist a "Visualization Type " named "Single Value" that you can use.

However, this is typically used when the result is a single value. In your example, you have two values, so it may default to the last one in that option.

I suggest you create two titles in the dashboard.

Title 1:

1. After line 7, add a filter: Channel = "dataA"
2. Change the Visualization to "Single Value"

Title 2:

1. After line 7, add a filter: Channel = "dataB"
2. Change the Visualization to "Single Value"

Since according to your query, there are only two types of channels, my suggestion is to separate them and display them in a single, large "Value"

I hope it's helpful 💪