I’m trying to create a second chart in QuickSight that is based on the aggregated values from a first chart. Specifically, I have a line chart showing the average values over time (automatically calculated by QuickSight based on filters and dimensions). Now, I want to use these final aggregated values from the first chart to apply a scale transformation for display in the second chart.
Is there a way in QuickSight to reference or transform the aggregated values from one chart directly in another visualization? If not, are there workarounds within QuickSight to achieve this?
You won’t be able to pull the values directly from a visual, but in the past I have done similar things by duplicating the visual and then changing the visual type. Or, I use the same fields and filters in a new visual type.
What type of visual are you trying to pull the values from and what type of visual would you like to end up with for your use case?
I am going to mark my first comment as a the solution for this post. If you still need help with this issue please feel free to create a new topic at the top of the community.