I am working on a use case where I need to represent data at different granularities (daily, weekly, monthly), controlled dynamically by a parameter. I am using a line chart to visualize this, with the lines differentiated by another parameter.
However, I’ve encountered two challenges:
The chart is only displaying the top 12 and bottom 25 values, instead of all available values (approximately 200+).
There doesn’t seem to be an option to sort the data based on a specific metric.
Is there a workaround for this issue, or is it achievable? Any guidance would be greatly appreciated.
Hi @kewalrn and welcome to the QuickSight community!
This is interesting that it’s setting different limits on the top and bottom, do you have any filters attached to the visual?
In regards to switching between day/week/month granularity, you can achieve this by setting up a calculated field.
Check out the attached Arena view that I put together to show how this can be utilized: Assistance Needed with Granularity and Sorting in Large Line Chart
I started by creating the Date Day, Date Week, & Date Month fields; then created a parameter for the same 3 time intervals.
Next, I created an ifelse statement (selected date type), which recognizes which parameter time interval I’ve chosen.
Last, one more calculated field to perform the operation (for this example, I just did sales by the given time interval).
No filters for now. just the parameter driving the change in color by lines setting.
I am able to achieve the granularity via parameter and calculated field.
I need to represent 200+ lines in the visual, but the default option allows only 200.
Our line charts support 10K data points. The default limit set for x axis data points is 200 and lines/group/color is 25. You can increase the line/group/color count to max of 100 by explicitly reducing x axis data points down to 100 and then setting group/color number of lines displayed to 100 (see screen shot below).
Likewise, if you want to plot more than 200 data points along X axis, you can do it by reducing the group/color value. For eg, if you set group/color to 1, you can set X axis data points to 10,000.
I think what you are trying to do is plot more than 200 data points on X axis (as it will be rather messy if you have that may number of lines) and if so, the above should help you.
If you truly need 200+ lines, you can try using our Highcharts visual. Therein, we still have the 10K overall data point limit but we don’t enforce line/group/color max limit of 100.
Read more at Using Highcharts - Amazon QuickSight
