<< Click to Display Table of Contents >> Current:  Create Dashboard > Configuration Fileld > Create Calculated Field > LOD  Fixed

❖Fixed dimension expression - Fixed:

This expression calculates values using the specified dimension, without reference to any other dimension in the component.

 

Syntax: Fixed ([dim1 [, dim2]...]:: aggregate-expression])

 

For example, Fixed (col ['procuct']:: Sum (col ['sales'])

 

➢For Example: How much does Florida contribute to sales profits across the East Market?

•thinking：

1. Our question concerns the profits of East Market and Florida. When there are only two columns in a table: region and profit, the profit figure represents the total profit of the whole region, as shown in the following figure (sales profit of the region)

 

2. When there are MARKET, STATE and PROFFIT in a table, the PROFFIT data represent the profits of a STATE, as shown in the following figure (total profits of each province):

 

3. By dividing Florida's profits by the profits of the whole East region, we can get the contribution of the profits of Florida market to the profits of the whole  East Market region.

 

4. According to the above analysis, can we clearly draw the contribution of Florida to the profits of the whole East Market region in the same table? The multi-granularity expression can easily put the profits of Florida, the profits of East Market and the proportion of Florida to the whole East Market into a table.

 

•The implementation steps in Yonghong BI are as follows:

1. By creating a new expression and writing a multi-granularity expression, the profit of each region can be calculated. everyMarketProfit = Fixed (col ['region']:: sum (col ['profit'])

 

2. Through the new aggregation expression, divide the total profits of each province by the profits of each region. PERCENT = sum (col ['profit']) / sum (col ['everyMarketProfit'])

 

3. By binding the established expressions "percent" and "profit of each province as a percentage of the region" into the table, we can easily calculate the profits of Florida, the profits of East Market and the proportion of Florida to the whole East Market region. The results are as follows: