Smart eVision Analysis provides a variety of fast calculations, including Member Calculation, Aggregate Calculation, Periodic Calculation, and Periodic Aggregation.
Add Script: Navigate to a measure column → Right click and select Member Calculation → Add Script. Do calculations such as addition, subtraction, multiplication, and division.
Achievement Rate: Navigate to a measure column → Right click and select Achievement Rate. Select "Amount" as the Actual Value, "Target" as the Target Value.
※Formula: (Actual Value/Target Value)%100%.
Parent Aggregate: Navigate to a measure column (e.g. Amount). Right click and select Aggregate Calculation → Parent Aggregate.
Aggregate: Navigate to "Amount". Right click and select Aggregate Calculation → Aggregate. This calculates the cumulation of the amount of all insurance types.
Percentage: Right click on Aggregate Calculation → Select Percentage.
Rank: Right click on Aggregate Calculation → Select Rank.
Value: This calculation displays the value of a certain period in time. Right click on Periodic Calculation → Select a period in time (e.g. Same Period Last Year).
Growth Rate: Select Periodic Calculation → Select a period in time (e.g. Same Period Last Year).
Growth Value of Same Period Last Year: This column is calculated according to the date hierarchy. The selected column needs to be the parent layer of the date hierarchy. Periodic Calculation → Growth Value (Year) → Previous Year.
Summary: This calculates the value of a particular period of time. Periodic Aggregation → Summary → Yearly Sum.
Average: This calculates the value of a particular period of time. Periodic Aggregation → Average → Yearly Average.
Total: This calculates the value of a particular period of time. Periodic Aggregation → Total → Yearly Total.
Moving Aggregate of 6 Quarters: This column will be calculated according to the date hierarchy and needs to be parent layer. Right click on "Amount" → Periodic Aggregation → Custom.
★Type: Grand Total. Check Use Moving Aggregate.
★Range: Prev. N (Previous N period)
★Count: 6