i’m trying to visualise a series of data on a chart, ideally creating something that would show how the distribution lies. The data is in a snowflake db, and I’ve attempted to do this using percentiles. I’ve calculated the value at 10 % increments. My current query is as below, but this doesn’t seem to give me a great output to visualise
select
APPROX_PERCENTILE(field_name, 0.1) “10_percent_value”,
APPROX_PERCENTILE(field_name, 0.1) “20_percent_value”,
APPROX_PERCENTILE(field_name, 0.1) “30_percent_value”,
etc.
from table.name
I’m sure i’m going about this the wrong way, but would like some help on alternative methods that could work please to be able to support a curve type visualisation. Hopefully this is enough information?