Calculations

[natdudley]

We'd like to:

• Specify that a number range should be calculated as a percentage
• Specify a previous time period for comparison and calculate a percentage increase or decrease compared to previous value (including stating a date for comparison) e.g. {Increase|decrease} of {x}% compared to {2018 Q2 figure}

It would be nice to:

• check each time period and state if this is the highest/second highest/third highest (or lowest) values ever seen
• check against other territorial authorities for the same time period and identify if this is in top 3, bottom 3, upper quartile, or lower quartile.
• possibly state what the average is for all TAs

[Spksh]

Added "convert to a percentage". This just sums up the rows that survive processing, so we'll need to be mindful of exclude values, e.g. if a "Total" row makes it in, we'll include that in the sum and blow out the calculated total.

The Boolean to enable this is set on the include for measure. It respects any group applied; totals will be calculated within the group.

        {
            "uri": "https://figure.nz/table/VL93L0Yr0wPdvbKB/download",
            "parent": "Demographics",
            "measure": { 
                "column": "Measure", 
                "include": [ 
                    { 
                        "value": "Sex for the census usually resident population count", 
                        "label": "Census population by sex",
                        "convert-to-percentage": true
                    }
                ],
                "exclude": [ ] 
            },
            "category": { 
                "column": "Sex", 
                "include": [ 
                    { 
                        "value": "Male"
                    },
                    { 
                        "value": "Female"
                    }
                ],
                "exclude": [ ] 
            },
            "date": "Census Year"
        }