Hello, I’m creating a calculated field with a formular Revenue/Cost*100. 2 field Revenue and Cost are also a calculated field and it’s work normally. Can someone explain about this errors
Hi @Drew02 and welcome to the QuickSight community!
What is the error message you’re receiving..mismatched aggregations? If Revenue and cost are also calculated fields, it may depend on how those are setup to aggregate. I would suggest checking out this article that dives in to Level-Aware Calculations and the best practices for them:
2 Likes
Hi @Drew02 - Please share the error screenshot and if possible, give some sample data ( input) and require output. This will help in troubleshooting the issue.
Note - Please do not share any confidential information.
Regards - Sanjeeb
The field Revenue formular was: deposit-withdraw
I’ve change the formular from Revenue/Cost100 to (deposit-withdraw)/Cost100 and it work. I dont know how calculated field in QuickSight actually work
Hi @Drew02,
Glad you were able to get it working; the order of operations with QuickSight functions when building calculated fields can get tricky.
In addition to that article that I posted above, you can also find out more information about each function and how to properly order them when you’re building a calculated field; on the right side there’s a list of possible functions that can be utilized:
When you select one, there will be a ‘learn more’ option down at the bottom. This will jump you to the AWS documentation for that specific function so that you can learn more about how to properly use.
These can help you learn a bit more in depth about how calculated fields operate!
1 Like
Thank you very much for your information
1 Like