How create a piechart out of a column?

[lapwat]

I successfully imported my datasource, headers are recognized.

h1,h2
v1,v3
v1,v3
v2,v3

I would like to make a piechart out of one column. It should count all different values in this column.

For the data above, if I select column h1, it should return a piechart with v1:66% and v2:33%.

I am stuck at the point where it successfully count all values but does not make a difference between v1 and v2.

Can you help me achieve that ?

[marcusolsson]

Hi are you using the new or the old Pie chart panel? I believe the old Pie chart only supports time series data. In the new Pie chart, you should be able to select All values, to support the format you describe.

[lapwat]

Thanks for the quick response.

Selecting "All values" displays an empty Panel.

[marcusolsson]

The Pie chart needs a String field and a Number field when using All values, but looks like you're missing a Number field in your schema?

[lapwat]

I don't have any Number column, I would just like to count all rows with value "v1" in column "h1".

[lapwat]

In my case it could be, count all rows with value "Xiaomi" in column "manufacturer".

[marcusolsson]

Oh, I see! I think your best bet would be to a combination of Transformations to create the Number field first.

Something like this maybe:

[lapwat]

Thanks for enlightening me, I succeeded with the same technique.

I didn't need to add a new field.

[marcusolsson]

Thanks, I learned something new as well!