{"size":{"Width":453,"Height":205},"appearance":{"background":null,"padding":14,"font":{"family":"Courier New","size":10.0,"bold":false,"italic":false,"underline":false,"strikeout":false,"color":"rgb(0,72,168)"},"border":{"on":true,"size":0.0,"style":"solid","color":"#666"},"text":{"wrap":false,"hAlign":"left","vAlign":"top","resize":"ResizeShapeToFitText"}},"outputType":"TABLE","widgetStateDict":{},"wikiPageTitle":"Calculation - Average - Table(s)","hasReferences":{"propertyAppearanceFont":false,"propertyAppearanceParagraph":false,"propertyAppearanceWrap":false,"propertyAppearanceBorder":false,"propertyAppearanceBackgroundColor":false},"hasChartData":true,"outputs":{"text":"loading...","warning":"Missing values have been ignored in calculation.\r\nThere was a single unmatched category (\"CAN\") that was removed in the calculation of 'Average'. If you wish this category to be used in the calculation, consider modifying the name matching options to show the unmatched categories or inspecting and possibly modifying the names of the inputs to ensure there is a valid match.","table":"{\"Data\":{\"Dimensions\":[{\"Tiers\":[],\"Count\":4,\"Elements\":[{\"IsNumber\":true,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":false,\"IsText\":false,\"Categories\":[],\"SeriesType\":0,\"Id\":\"StatisticsElement0\",\"Name\":\"2018\",\"WrappedName\":[\"2018\"]},{\"IsNumber\":true,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":false,\"IsText\":false,\"Categories\":[],\"SeriesType\":0,\"Id\":\"StatisticsElement1\",\"Name\":\"2019\",\"WrappedName\":[\"2019\"]},{\"IsNumber\":true,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":false,\"IsText\":false,\"Categories\":[],\"SeriesType\":0,\"Id\":\"StatisticsElement2\",\"Name\":\"2020\",\"WrappedName\":[\"2020\"]},{\"IsNumber\":true,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":false,\"IsText\":false,\"Categories\":[],\"SeriesType\":0,\"Id\":\"StatisticsElement3\",\"Name\":\"2021\",\"WrappedName\":[\"2021\"]}],\"IsStatistic\":true,\"Id\":\"StatisticDimensionID\",\"Name\":null,\"WrappedName\":null},{\"Tiers\":[],\"Count\":4,\"Elements\":[{\"Id\":\"RowDimensionElement0\",\"Name\":\"AUS\",\"WrappedName\":[\"AUS\"]},{\"Id\":\"RowDimensionElement1\",\"Name\":\"EU\",\"WrappedName\":[\"EU\"]},{\"Id\":\"RowDimensionElement2\",\"Name\":\"USA\",\"WrappedName\":[\"USA\"]},{\"Id\":\"RowDimensionElement3\",\"Name\":\"UK\",\"WrappedName\":[\"UK\"]}],\"IsStatistic\":false,\"Id\":\"RowCategoricalDimension\",\"Name\":null,\"WrappedName\":null}],\"Settings\":{\"CellDimensionId\":null,\"RowDimensionsIds\":[\"RowCategoricalDimension\"],\"ColumnDimensionsIds\":[\"StatisticDimensionID\"],\"ColumnHeadersHidden\":false,\"Title\":\"average.calc.2\",\"Footnote\":null,\"IsRowHeadersSortable\":false,\"IsColumnHeadersSortable\":true,\"HeaderSorts\":[],\"IsRowHeadersFilterable\":false,\"IsColumnHeadersFilterable\":true,\"HeaderFilters\":[],\"PaginationParameters\":null,\"TableStyleCssClass\":\"style-97ba0187-37c0-47a1-a4ad-31b0f5281e77-1-_-_\",\"LiveTableFormat\":{\"BaseFont\":\"Open Sans, 10pt\"},\"AvailableWidth\":453,\"AvailableHeight\":205,\"Padding\":14,\"TableWidth\":null}},\"Dimensions\":[{\"Tiers\":[],\"Count\":4,\"Elements\":[{\"IsNumber\":true,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":false,\"IsText\":false,\"Categories\":[],\"SeriesType\":0,\"Id\":\"StatisticsElement0\",\"Name\":\"2018\",\"WrappedName\":[\"2018\"]},{\"IsNumber\":true,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":false,\"IsText\":false,\"Categories\":[],\"SeriesType\":0,\"Id\":\"StatisticsElement1\",\"Name\":\"2019\",\"WrappedName\":[\"2019\"]},{\"IsNumber\":true,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":false,\"IsText\":false,\"Categories\":[],\"SeriesType\":0,\"Id\":\"StatisticsElement2\",\"Name\":\"2020\",\"WrappedName\":[\"2020\"]},{\"IsNumber\":true,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":false,\"IsText\":false,\"Categories\":[],\"SeriesType\":0,\"Id\":\"StatisticsElement3\",\"Name\":\"2021\",\"WrappedName\":[\"2021\"]}],\"IsStatistic\":true,\"Id\":\"StatisticDimensionID\",\"Name\":null,\"WrappedName\":null},{\"Tiers\":[],\"Count\":4,\"Elements\":[{\"Id\":\"RowDimensionElement0\",\"Name\":\"AUS\",\"WrappedName\":[\"AUS\"]},{\"Id\":\"RowDimensionElement1\",\"Name\":\"EU\",\"WrappedName\":[\"EU\"]},{\"Id\":\"RowDimensionElement2\",\"Name\":\"USA\",\"WrappedName\":[\"USA\"]},{\"Id\":\"RowDimensionElement3\",\"Name\":\"UK\",\"WrappedName\":[\"UK\"]}],\"IsStatistic\":false,\"Id\":\"RowCategoricalDimension\",\"Name\":null,\"WrappedName\":null}],\"DataPoints\":[[{\"Value\":940000.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":925000.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":960000.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":865000.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null}],[{\"Value\":1055000.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":1075000.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":915000.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":1060000.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null}],[{\"Value\":990000.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":1030000.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":1095000.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":950000.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null}],[{\"Value\":955000.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":915000.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":970000.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":1130000.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null}]],\"Settings\":{\"CellDimensionId\":null,\"RowDimensionsIds\":[\"RowCategoricalDimension\"],\"ColumnDimensionsIds\":[\"StatisticDimensionID\"],\"ColumnHeadersHidden\":false,\"Title\":\"average.calc.2\",\"Footnote\":null,\"IsRowHeadersSortable\":false,\"IsColumnHeadersSortable\":true,\"HeaderSorts\":[],\"IsRowHeadersFilterable\":false,\"IsColumnHeadersFilterable\":true,\"HeaderFilters\":[],\"PaginationParameters\":null,\"TableStyleCssClass\":\"style-97ba0187-37c0-47a1-a4ad-31b0f5281e77-1-_-_\",\"LiveTableFormat\":{\"BaseFont\":\"Open Sans, 10pt\"},\"AvailableWidth\":453,\"AvailableHeight\":205,\"Padding\":14,\"TableWidth\":null}}"},"secondsTaken":0.219,"updated":"2021-05-18T10:53:03.1605034Z","lastUpdatedMessage":null,"executedCode":null,"lastSavedCode":null,"isStandardRItem":true,"highlightedCodeSpans":null,"tableTransformations":"<TabularTransformer>\r\n <TabularTransform type=\"Truncation\" truncationHeaderType=\"Column\" />\r\n <TabularTransform />\r\n</TabularTransformer>","tabularFilteringOptions":null,"hasGuiControls":true,"calculating":"Idle","showDebug":false,"layout":"OutputOnly","vSplit":0.25,"hSplit":0.45,"updateWarnings":true,"updateMode":"Automatic","warnSlow":true,"Options":{"debugconsole":false,"codeposition":"OutputOnly","splitH":0.45,"splitV":0.25,"update warnings":true,"updating":"Automatic","warn slow":true}}