Questions (2) and (3) posed earlier in this blog can be answered in a similar way by defining a measure that is calculated from information that already exists within the cube.
How will this capability be included in the latest release of FastStats Discoverer
For the Q3 2015 release of Discoverer we have added functionality to expand the analytical capabilities of cubes with a number of new ‘Calculated Measures’.
Running – cumulative function across a particular dimension on a measure.
Rolling – smoothing fluctuations in cyprus phone number the data by calculating a function across the last few values.
Period To Date – work out the value of a function across a date dimension from the start of a date period.
Comparison – compare the current value to a previous value on a dimension. For a date dimension this can compare to a relative date period.
Rank – compare the relative position of a category amongst other categories across a dimension and return as a number.
Percentile – compare the relative position of a category amongst other categories across a dimension and return as a percentage showing the number of values lower than or the same as the current one.
Furthermore, these useful calculations can be chained together to create more advanced results - for instance we could work out the difference between the Sum of the Year to Date against the Sum of the Previous Year To Date.