Infinity datasource -Dashboard Designing -online CSV

Grafana
,
1

Hi,

This is regarding the infinity datasource CSV online feasibility for the combination of columns with different conditions on single panel have CSV online with following example of data , where I would like to count the value based on the result condition,
When I am trying with Same column and different condition under results set, no results displaying .

Input

region Env
==== =====
Switzerland Prod
EMEA Prod
Americas Prod
Switzerland Prod
Switzerland Prod
Asia Pacific Prod
Americas Prod
Switzerland Prod
EMEA Prod
Switzerland Non-Prod
Switzerland Non-Prod
Americas Non-Prod
Switzerland Non-Prod
EMEA Non-Prod
Switzerland Non-Prod
Asia Pacific Non-Prod
Switzerland Non-Prod
Switzerland Non-Prod

Output should be something like below

Region Prod(count) Non-Prod(count)
====== ========= ===========
Americas 10 10
Asia Pacific 10 20
EMEA 10 20
Switzerland 10 30

Grand Total 40 80

is there a way to get the count of values based on condition for multiple columns or single column in the single panel either with pie chartm,Bar Gauge,Bar chart and so…

2

using UQL

parse-csv
| pivot count(), "region", "Env"

image
image1608×703 79 KB

3

Hi,
Thank you for the suggestion . I have tried to use the same but unfortunately ,it gives me the error.

My input is a CSV which is on different server and accessing via URL.

in Linux servers, it stored as comma separated as
image

and when Opening CSV

image

Type =UQL and source=URL

image
image1495×696 44 KB

Type =CSV and parser=UQL source=URL

image
image834×588 16.6 KB

both types are giving Error message is “error applying uql query !”

4

change uql to csv and see if you get any data

5

UQL docs available in UQL

What I see is that you have incorrect syntax. count method in query require parameter. Like count("id")

1 Like