Calculated field works in Analysis but not in Quicksight Q

I created a Quicksight Q topic from an analysis. It brought the calculated fields along with dimensions and measures, but almost all calculated fields are erroring out in the Quicksight Q.

e.g. here is the definition of one of the calculated fields in the Analysis

lead(EOT,[EOT DESC], 1, [customerid, {Equipment ID Full}])

EOT is a Date field.

I understand from the documentation that the lead only works with measure.
My question is why it is working in Analysis but not in Q?

What can I do to make it work in Quicksight Q?

Quicksight Q gives the following error

Hello @pankaj_kushwaha !

The error messages you received make me think that there was some kind of error with the underlying data. When you created the topic, is there any chance that something about the underlying datasets or data sources changed?

1 Like

Nothing changed with the dataset. I simply created the Topic from an Analysis, but the calculated fields are not working in quicksight Q. Only one calculated field with a concat function works. Both the Analysis and Quicksight Q topic use the same dataset.

Does the lead function work for a DATE field? As per documentation, " The lead function calculates the lead (following) value for a measure based on specified partitions and sorts."

Hello @pankaj_kushwaha !

It could be that the lead function does not allow for date fields, but you said that it was working on your original dashboard?

If all of your calculations were working prior to adding them to a Q topic, I would recommend creating an AWS support ticket for this error. Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf.