Infinity datasource -Dashboard Designing -online CSV

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…

using UQL

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

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

Type =CSV and parser=UQL source=URL

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

change uql to csv and see if you get any data

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