Quicksight generation of CDF plots

[robdhondt]

Hi fmacias,

After reading both your posts I’m going to make some assumptions. See if this helps.

Quicksight generation of CDF plots

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 that the data series entries are represented in the X-axis while their corresponding cumulative probability is recorded in the Y-axis. Any advice will be greatly appreciated.

Connecting dots in Scatter Plot

Hello, is there a way of connecting the dots of a scatter plot with a line? This seems like a basic chart property but I haven’t found any way of doing so. Thanks!

Understanding Your Issue

You’re trying to generate a CDF plot for a given data series. Here’s a summary of your approach:

1. CDF Plot Generation: You provided an example data series and a CDF plot generated which illustrates how you want the data series entries represented on the X-axis with their corresponding cumulative probability on the Y-axis.
2. Line Chart Limitation: You tried using a line chart in QuickSight, but you encountered a limitation. The X-axis in a line chart doesn’t support the granularity you need, as it aggregates data points, preventing you from accurately plotting each data point.
3. Scatter Plot Limitation: You then attempted to use a scatter plot, which can plot each data point individually. However, you found that there’s no option to connect the dots with a line in a scatter plot in QuickSight.

Why QuickSight Doesn’t Support This

Currently, QuickSight has limitations in both line and scatter plots that prevent the exact representation you’re aiming for:

• Line Charts: QuickSight’s line charts aggregate data points, making it impossible to plot each individual point without aggregation.
• Scatter Plots: While scatter plots allow individual points to be plotted, QuickSight does not support connecting these points with a line, which is crucial for representing a CDF.

No Workarounds Available

As of now, there are no direct workarounds in QuickSight to achieve the precise CDF plot you’ve demonstrated. QuickSight doesn’t support the combination of granularity and connectivity of data points required for such a visualization.

Feature Request

I recommend submitting a feature request to the QuickSight team. Adding support for connecting dots in scatter plots or allowing non-aggregated line plots would be valuable features for many users.

Alternative Visualization

While QuickSight might not support the exact visualization you need, you can consider the following alternative to represent cumulative probability:

• Step Plot with Aggregation: Create a step plot where you round your data to the nearest 100 and aggregate, then use a line chart to plot these points. While this aggregates some data, it can still provide a visual representation of cumulative probability.

c_round:
round({data_series} / 100) * 100

step line style:

Line and marker styling on line charts in QuickSight - Amazon QuickSight