Hi guys, I`m quit new in the topic so I hope I can find help here.
I have some “Applications”. Each “Application” has Value rows. I would like to have a new column “Status” to compare the Values. The Status response with “PASS” if the Values are equal otherwise “FAIL”. Also I struggle to connect it with dynemic field (filter). So if i only selcet specific “Applications” by filter then show me the Status only between these application.
Please for HELP! Thank you very much!
I want you have 2 requirements
-
If I refer to the above table, you want to calculated 2 aggregated measure value of Application breakdown by Region, Market and k…. If the value are the same, it shows PASS, otherwise show FAIL
-
Have a filter by Application
about first requirement, you need to create a calculated field and use function sumOver to calculate the 2 aggregated value by the above dimensions. And compare between them. you may refer to below screenshot. For better elaboration, I have split into 3 calculated fields
Create aggregated value for profit and sales
Compare the above aggregated value and show FAIL or PASS
about 2nd requirement, you may refer to this document Adding filters - Amazon QuickSight