Hello, I have 2 queries and each are giving me a timestamp and a value, what i want to do is have the 2 values on the same panel and have it like “5 / 6”, i managed to put them together on the same panel by transforming it “add field from calculation”, the issue here is it shows “5, 6” and i can’t change the comma, i’ve tried almost everything that i could and i did not manage to do it…
To explain a bit better what i’m doing is check a table which has 6 components (my total) and then i query it to check which ones have value = 1, right now there are 5 out of 6 and that is what i want to show.
welcome to the forum, @miguelcosta1993
can you please follow these steps to share your raw unformatted data? That way, the community can try and mock up your problem
Could you please share your data, not as a screenshot, but as inline csv like the folllwing. Help us help you so that we dont have to retype everything from a screenshot and it helps us emulate your data in our environment . For example
Value,date,metric
3,'2022-05-02 23:23:00', 'celcius"
yes, of course, hope this works for what you requested
"Time","All values"
1651484550000,"3,4"
1651484565000,"3,4"
1651484580000,"5,6"
1651484595000,"5,6"
1651484610000,"5,6"
1651484625000,"5,6"
1651484640000,"5,6"
1651484655000,"5,6"
1651484670000,"5,6"
1651484685000,"5,6"
1651484700000,"5,6"
1651484715000,"5,6"
1651484730000,"5,6"
1651484745000,"5,6"
1651484760000,"5,6"
1651484775000,"5,6"
1651484790000,"5,6"
1651484805000,"5,6"
1651484820000,"5,6"
1651484835000,"5,6"
1651484850000,"5,6"
Is this what the data looks like from source? Or is this after you have some done something to it?
So i got 2 sources of data.
"Time","count(probe_success{athonet_component=""athonet_component""})"
1651503765000,6
1651503780000,6
1651503795000,6
1651503810000,6
1651503825000,6
1651503840000,6
1651503855000,6
1651503870000,6
1651503885000,6
1651503900000,6
And this
"Time","sum(probe_success{athonet_component=""athonet_component""}==1)"
1651503765000,5
1651503780000,5
1651503795000,5
1651503810000,5
1651503825000,5
1651503840000,5
1651503855000,5
1651503870000,5
1651503885000,5
1651503900000,5
1651503915000,5
To get the first set of data i showed on my previous message i do this transformation with the data from this message.
Did you manage to have a look at it? I’ve exhausted all the options i thought would make this work… thanks