Issue while creating a calculated column Via API

[Aditjain20]

I have created a calculated column with formula "1 / ( SUM( Revenue * -1 ) + SUM( Revenue ) ) * SUM( Revenue ) ", now I have use this column with line chart and It is showing me like columnName (custom) , which means it doesn’t applied any aggregation on it.
Further on I created the same calculation Json at dataset level and tried to upload my analysis using this column in a Line chart using API but I am getting an error that Aggregation should be applied on this column, but when I tried to create the same column with Quicksight UI, it is giving me json with no aggregation applied . Is there any field which I need to update on JSON and again try to upload via API ?

[Brett]

Hi @Aditjain20,
So you are looking to apply aggregation to your formula? I would suggest looking further into the sumOver function.
Additionally, here is a useful article that assists with building out calculated fields in QuickSigh:

Level-Aware Calculations: Tips and Best Practices

[Level-Aware Calculations in Amazon QuickSight] Level-Aware Calculations (LAC) are powerful functions that allow us to perform calculations at a granularity level which is different from the granularity of our datasets and/or visuals. The sample dataset referenced by this article is a dataset of product orders placed by customers. Each order can contain multiple products and each product in an order has a unique Line Item ID. Each row of our dataset represents one line item but we want to per…

Let me know if this is not what you’re looking for help with or please provide some additional context on your issue so that we can better assist.

Thank you

[Brett]

Hi @Aditjain20,
Following up here as it’s been awhile since we last heard from you; did you have any additional questions regarding your initial post?

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

Thank you

[Brett]

Hi @Aditjain20,
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.

Thank you