Pivot over pivot

Question & Answer
,
1

Is there any way to create a pivot over pivot?

I have read that it can be done by saving the pivot, and applying another pivoting over that pivot. But, I have not yet found any way to save the pivot as a table in Quicksight.
Please note that I am not interested in downloading and uploading the pivots because I have 144 of those pivots.

2

hello @Dscientist.lr can you show us an example of the data you have in the pivot that you would like to pivot? this way we can have a better understanding of what you are trying to achieve. Thanks

3

@Franc3sc0
I have such a pivot

image001 (2)
image001 (2)889×159 15.2 KB

4

@Franc3sc0

And I want to be able to illustrate it like

image002 (1)
image002 (1)915×370 31.5 KB

)

Therefore, I need the pivot to be stored as a table so that I can do plotting using its data.

Also, I want x axis to be like what this graphs is showing

5

Hi @Dscientist.lr, sorry, currently this is not possible but it’s on feature request. At AWS, our roadmap is primarily driven by our customers. Your feedback helps us build a better service. I have tagged this as a feature request. More features are being added on a regular basis, so please keep an eye on the What’s New / Blog . You can set up a Watching Alert by clicking on the bell icon.

In the meantime, you can use SQL to create complex aggregations before loading data into QuickSight:

  1. Use an SQL query to create the desired aggregation levels.
SELECT 
  Region, 
  Product, 
  SUM(Sales) AS total_sales, 
  AVG(Sales) AS avg_sales_per_product
FROM your_table
GROUP BY Region, Product
  1. Import Aggregated Data into QuickSight: Load the pre-aggregated data into QuickSight and create your visuals directly on this dataset.

By using calculated fields and strategic visual arrangements, you can effectively create the illusion of a pivot over a pivot within QuickSight.