Like 0

Table Calculation Enhancements

Table Calculation improvements include productivity enhancements to quickly create and edit calculations, first and last comparison options, new table calculation functions, and viewing the calculation formula in a tooltip for a table chart.

Productivity Enhancements

Table Calculation Templates

Visual Analytics streamlines your workflow by giving you the flexibility to change the calculation type using the new Table Calculation Templates option.

Summarize Values From

Change the Summarize Values From / Calculate Difference Along View setting directly from the drop-down list of the selected measure field.

Difference From

Change the Difference From setting directly from the drop-down list of the selected measure field.

First and Last Comparison

Visual Analytics adds First and Last comparison options to the Difference From related table calculations. The following example compares profits of each month with January.

Formula Debugging

You can now view the calculation formula in a tooltip for a table chart.

Table Calculations Functions

Running Functions

RUNNING_AVG(expression)

RUNNING_COUNT(expression)

RUNNING_MAX(expression)

RUNNING_MIN(expression)

RUNNING_SUM(expression)

Window Functions

WINDOW_AVG(expression, [pointsBefore, pointsAfter])

WINDOW_COUNT(expression, [pointsBefore, pointsAfter])

WINDOW_MAX(expression, [pointsBefore, pointsAfter])

WINDOW_MEDIAN(expression, [pointsBefore, pointsAfter])

WINDOW_MIN(expression, [pointsBefore, pointsAfter])

WINDOW_PERCENTILE(expression, [pointsBefore, pointsAfter], percentileValue)

WINDOW_STDDEV(expression, [pointsBefore, pointsAfter])

WINDOW_STDDEVP(expression, [pointsBefore, pointsAfter])

WINDOW_SUM(expression, [pointsBefore, pointsAfter])

WINDOW_VAR(expression, [pointsBefore, pointsAfter])

WINDOW_VARP(expression, [pointsBefore, pointsAfter])

Comments (0) Attachments (14)

This list is empty.

Search Tips

Aqua Data Studio / nhilam

Table Calculation Enhancements

Productivity Enhancements

Table Calculation Templates

Summarize Values From

Difference From

First and Last Comparison

Formula Debugging

Table Calculations Functions

Search Tips

Aqua Data Studio / nhilam

Title

Table Calculation Enhancements

Productivity Enhancements

Table Calculation Templates

Summarize Values From

Difference From

First and Last Comparison

Formula Debugging

Table Calculations Functions