OTBI computed field and graph

Summary

creating computed field and graph

Content

Hi all, 

I am very new to Oracle Fusion business intelligence. 

Background:

• Fusion 19C 
• try to analyze the company's employee expense reports by taking the "Expense - Expense Transactions Real Time" subject area
• Analyses report include these fields: "Report Number", "Report Status", and "Expense Report Total"
• Computed fields: 
  • "Report Threshold", formula: CASE WHEN "Expense Report Amounts"."Expense Report Total" >= 500  THEN '>=500'   ELSE '<500' END
  • "Report Count", formula: ABS(1)*1
  • as you can see in the attached picture #1 - "Report Threshold" has the "measure" type icon, and the "Report Count" has the dimension type icon.