Is there a limit on number of calculated metrics per Analysis?

Question & Answer
, ,
1

Hi, is there any limitation on calculated fields per QS Analysis? There was a warn message in my QS account and I can’t create new calculated fields in my analysis. The warn message has disappeared, but I want to confirm that you will not apply any limitation in number of calculated metrics per Analysis.

The message was:

To keep within limit, review the following and remove unused items from analysis.

Over 200 calculations in some datasets (max limit of 200)
1477 calculations added (max limit 500)

Following restrictions apply starting May 31st 2025

New items can’t be added. To add more, delete unwanted or disabled items.
Duplicate actions for visuals and sheets that exceed limit won’t be permitted.
Duplicating this analysis won’t be permitted.
2

Hi @MarinaDoria

QuickSight has specific limits on calculated fields to ensure optimal performance.

Please refer to the below documentation this might be helpful for you.

3

Hi, thanks! Could you clarify the

500 per analysis and 200 per dataset*

  • The per dataset limit applies to calculations that were created in the analysis. Dataset level calculations are not included in this limit.

It is not clear if the limitation is 200 or 500 per analysis.

Thanks!

4

Hi @MarinaDoria

I believe that, 200 per dataset limit applies only to calculated fields created within the analysis (i.e., not part of the dataset itself). However, dataset-level calculated fields do not count toward this limit.

The 500 per analysis limit is the total number of calculated fields that can exist within an analysis, including all datasets used in that analysis.

  • If you create calculated fields inside an analysis (not in the dataset), you can have up to 200 per dataset.
  • The overall limit for an analysis (sum of all calculated fields from different datasets + analysis level calculations) is 500.

If your analysis uses multiple datasets, each can have up to 200 analysis-level calculations, but the total across all datasets within that analysis cannot exceed 500 calculated fields.

2 Likes
5

Thank you! how can I know how many calculated metrics do I have per analysis and dataset? Is there any report in QS?

6

Hi @MarinaDoria

To determine the number of calculated fields in your QuickSight analysis and datasets, you can manually review them within the QuickSight interface.

Currently, QuickSight does not provide a direct report for counting calculated fields. You can manually check them:

  • Analysis-Level: Open your analysis, look for fields with the calculator icon in the Data pane.
  • Dataset-Level: Navigate to Datasets, select a dataset, and review calculated fields in the dataset editor.

You can also use the boto3 API to programmatically retrieve the number of calculated fields in your QuickSight analyses and datasets.

Please refer to the below boto3 API documentation this might be helpful for you.

https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/quicksight/client/describe_analysis_definition.html

https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/quicksight/client/describe_data_set.html

7

Hi @MarinaDoria,
It’s been awhile since we last heard from you, did you have any additional questions regarding your post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

8

Hi @MarinaDoria,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!