Altair® Panopticon

 

Ratio

The comparison between the sum of a selected measure divided by the sum of the selected weight measure.

The formula:

Ratio = sum(selected measure) / sum(selected weight measure)


 

Sample

Given the sample data:

Region

Store

Actual

Target

North

A

$1,300

$2,000

North

B

$750

$1,000

North

C

$2,100

$3,000

South

D

$4,700

$4,000

South

E

$2,000

$2,000

Sample fields

Creating a Table visualization with Breakdowns Region and Store with subtotals and grand totals produces:

 

 

Actual

Target

North

 

A

$1,300

$2,000

B

$750

$1,000

C

$2,100

$3,000

North Total

 

$4,150

South

 

D

$4,700

$4,000

E

$2,000

$2,000

South Total

 

$6,700

$6,000

Grand Total

 

$10,850

$12,000

 

Setting the Column to Actual and the Weight Column to Target with the format set to 0.0% results to the following Ratio values:

 

 

Actual

Target

Ratio

North

 

A

$1,300

$2,000

65.0%

B

$750

$1,000

75.0%

C

$2,100

$3,000

70.0%

North Total

 

$4,150

 

South

 

D

$4,700

$4,000

117.5%

E

$2,000

$2,000

100.00%

South Total

 

$6,700

$6,000

111.7%

Grand Total

 

$10,850

$12,000

90.4%

 

The results per row

 

 

Computation details:

North A: $1,300 / $2,000 = 65.0%

South D: $4,700 / $4,000 = 117.5%

North B: $750 / $1,000 = 75.0%

South E: $2,000 / $2,000 = 100.00%

North C: $2,100 / $3,000 = 70.0%

South Total: $6,700 / $6,000 = 111.7%

North Total: $4,150 / $6,000 = 69.2%

Grand Total: $10,850 / $12,000 = 90.4%

 

Collapsing the North region results to the following Ratio values:

 

 

Actual

Target

Ratio

North Total

$4,150

$6,000

69.2%

South

 

D

$4,700

$4,000

117.5%

E

$2,000

$2,000

100.00%

South Total

$6,700

$6,000

111.7%

Grand Total

$10,850

$12,000

90.4%

 

The results per row

The rest of the computation details are the same except for the collapsed North region:

North = ($1,300 + $750 + $2,100) / ($2,000 + $1,000 + $3,000) = 69.2%

Or

North = $4,150 / $6,000 = 69.2%

Collapsing the South region results to the following Ratio values:

 

Actual

Target

Ratio

North

$4,150

$6,000

69.2%

South

$6,700

$6,000

117.5%

Grand Total

$10,850

$12,000

90.4%

 

The results per row

The computation details for the collapsed South region:

South = ($4,700 + $2,000) / ($4,000 + $2,000) = 117.5%

Or

South = $6,700 / $6,000 = 117.5%