Character limit exceeded error while removing a field

[nimbus]

Hello hello! facing an issue in one of the QS analyses - deleted a few test fields and removed comments/commented code from the calculated fields to free up space so that it gets below the hard limit for the number of characters.

To test changes I wanted to make, I created a test field with just ‘1’ as the value and no actual calculations. The field was created just fine, but now when I want to make changes to this field or even delete it, running into the character limit error again. No clue why that is happening, especially even when I am just trying to remove the field. Any insights here will be helpful. TIA!

[Xclipse]

Hi @nimbus

Welcome to the QuickSight community!

Review your analysis for any visuals, parameters, or other calculated fields that might reference the test field. Remove or update these references before attempting to delete the field.

Temporarily remove other calculated fields or visuals that are not essential. This can help reduce the overall character count and allow you to delete or modify the test field.

Try refreshing the analysis or clearing the cache and cookies, as they could be causing the issue.

[Giridhar.Prabhu]

Hi @nimbus

It appears that a similar question was addressed sometime back.

QuickSight Calculated Field Size Limit

Hello @nadeamer In this case you are exceeding the following quota from Quicksight that you can check from the Service Quotas console: L-AECE65ED - Calculated field expression length The max limit for this quota is 250,000 characters and unfortunately you cannot increase it further. You should be able to create new calculated fields by shortening the expression used on them to contain 250K or less, also remember that you can reference calculated fields from calculated fields so this could al…

One of the suggestions that was provided was to possibly move some of your calculated fields to the dataset layer. See if there is a possibility to move some of your calculated fields to dataset.

I am not sure why you are getting the error when trying to remove a calculated field. You could try @Xclipse 's suggestion to removing the cache and see if that resolves, otherwise you may have to approach AWS resources for help.

Regards,
Giri

[nimbus]

No, the test fields did not have any references. Removing or editing any of the calculated fields was giving me this error. Will try the cache thing. Thanks!

Update: Clearing cache didn’t work either

[Xclipse]

Hi @nimbus

Could you please check the following community post shared by @Giridhar.Prabhu. This refers to cases where you are exceeding the service quotas in the console, and the maximum limit for this quota is 250,000 characters.

QuickSight Calculated Field Size Limit

Hi! While trying to add more calculated fields to my analysis, I received the attached pop up that ‘Calculated fields size limit exceeded’. As such, I am unable to add more calculated fields to this datasource. Was wondering what the limit on calculated fields for each datasource is? And is there any way to increase this limit? If anyone has other workarounds on this issue, would be really helpful too! [image] Thank you so much

[Xclipse]

Hi @nimbus

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

[Xclipse]

Hi @nimbus

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

Thank you!