I’m looking to generate the CDF (cumulative distribution function) plot for a given data series. Taking the following example data series: data_series = [584,441,114,237,774,332,361,214,478,366,121,398,246,646,117,447] The CDF of this distribution should look like this: [image] The idea is tha…

Hello @fmacias , welcome to the Quick Sight community! I think the most straight forward way to do this would actually be in SQL. Below is an example of how the function for Redshift: CUME_DIST window function - Amazon Redshift An inverse distribution function that assumes a continuous…

Hi fmacias, After reading both your posts I’m going to make some assumptions. See if this helps. [image] Quicksight generation of CDF plots Q&A I’m looking to generate the CDF (cumulative distribution function) plot for a given data series. Taking the follow…

Hi duncan, Thanks for the reply. Tried that calculated field and I’m getting a mismatched aggregation error: “Mismatched aggregation. Custom aggregations can’t contain both aggregated and nonaggregated fields, in any combination.”

Hi robdhondt, Thanks for the reply. Yes, both questions were related to this same topic. Scatter plot seems to be doing the trick, however having no connecting line between the dots makes the plot very difficult to interpret. Alternatively, having a line plot allowing independent X and Y inputs wo…

Quicksight generation of CDF plots

Q&A

WLS-D July 11, 2024, 2:34pm 6

Hello @fmacias !

I can tag this topic as a feature request for the Quick Sight team for you.

Connecting dots in Scatter Plot

Topic		Replies	Views
Connecting dots in Scatter Plot Q&A charts , analysis , parameters , formatting , quick-sight , visuals , dataset , calculations , Business-Intelligence-Engineer	3	74	July 17, 2024
How to create cumulative line chart? Q&A analysis , quick-sight , Business-Intelligence-Engineer	3	383	February 28, 2024
Connect lines for missing data Q&A analysis , formatting , feature-request , quick-sight , calculations	2	289	July 20, 2023
Distribution Band Q&A analysis , feature-request , quick-sight , Business-Intelligence-Engineer	4	233	October 22, 2024
Running total in a line graph Q&A developer , quick-sight , dashboard-embed	1	56	November 22, 2024

Quicksight generation of CDF plots

Related topics