Hi team,
I am facing some issues when I try to create calculated fields in topics of Quick.
Even a simple sum({col_name})
throws an error. How to account for all this?
Hi @revsp , is this error preventing you from creating the calculated field completely, or does it create the calculated field and then show the error when trying to access/preview the field?
Can you elaborate on where you see this error and steps that produce it?
Hi team,
Can I get an answer to this question?
Hi @revsp ,
Just checking back in to see you your question is still unresolved or if you found a solution in the meantime.
Typically, this error is more commonly throw when there’s an issue with the field reference itself, the aggregation context, or when you’re trying to use a calculated field in an unsupported way.
If you’re trying to do some type of aggregation on a specific measure, then you can avoid the calculated field approach and simply click on the field within the data fields tab. In there, you can further break down how the topic will treat the field and even tell the topic what type of aggregation it should do for that field. Refer to the screenshot below on how to assign the aggregation:
If you still have any additional questions related to your initial post, feel free to share them. Otherwise, any update you’re able to provide within the next 3 business days would be helpful for the community.
Thank you
Hi @revsp ,
Since I haven’t received any further updates from you, I’ll treat this inquiry as complete for now. If you have any additional questions, feel free to create a new post in the community and link this discussion for context.
Thank you