Sharing calculated fields across analysis using the same dataset

Question & Answer
, , ,
1

Hi,

I’m dealing with a large analysis that involves big datasets and requires the creation of numerous sheets. Currently, QuickSight has a limit of 20 sheets per analysis, so I have to create additional analyses to accommodate more sheets, which is manageable.

However, the challenge arises when it comes to maintaining and updating the many calculated fields in the analyses. Whenever I need to modify a calculation or its formula, I have to clone the calculated fields to the other analyses each time, which is quite time-consuming.

I’m exploring if there’s a way to designate one analysis as the master analysis, so that any changes made to a calculated field in the master analysis will automatically reflect in the child analyses. Alternatively, I’m curious if there’s a way to increase the number of sheets within a single analysis.

It’s worth noting that adding the calculated fields directly to the dataset won’t work for me, as my calculations are based on specific columns and rows in the analysis.

2

Hi @haythoo
one option would be to do it on a API level.
You could build a pipeline where you download a analysis, change your defintion and update it. With some work and coding it could save some time if you have to do it a lot and for many analysis.
BR

1 Like
3

Thanks @ErikG

I will give it a shot. I hope they add this as a feature in the near future.

4

Hi @haythoo. I tagged this as a feature request. Thanks for your feedback!