Visualization from pivot table

Question & Answer
,
1

Hi everyone,

Is it possible to create a visualization from a Pivot tbale created in QuickSight?
Our dataset does not enable a good viz but the data is sorted well in a pivot and we thought then to create a viz from it. Is it possible?

Since we need the data to be automated downloading the pivot and uploading it as a new dataset is not an option.

Thanks,

Etai

@maya_k

2

Hi @Etai, there is not any functionality to manage automating a dataset to be built from a pivot table visual in QuickSight. How is the pivot table making your data better for visualizations?

I would recommend either utilizing your database to create custom views that you can then import into QuickSight or using custom SQL to query the data so you can format it for visualizations.

Here is some documentation about building a dataset with custom SQL.

Those are the best options to prep your data for visualizations. Thank you!

1 Like
3

Hi @Brett,
Thanks very much, I’ll look into it.
Etai

1 Like