Like what you see? Have a play with our trial version.

Versions Compared

Old Version 1

changes.mady.by.user Yellowfin

Saved on

compared with

New Version Current

changes.mady.by.user Yellowfin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

LocationScreenshotDescription
Function List

You can drag a function from the function list on the left side of the chart builder screen.

These fields will become available once required field components have been added to the chart.

For example, some functions require a metric to be based on.

Field List

You can add a function directly from the field you wish to base it on

, by hovering

:

    1. Hover the mouse over the field in the chart area,
selecting
    2. Select Add Function from the drop down list, and
choosing
    2. Choose the function group to be used.

 

Selecting a Function

Once you have added a function to your chart, you can change the specific function being applied by clicking on the drop down menu on the field (hover the mouse over the field name).

...

OptionDescription
PeriodsThis specifies the number of periods the moving average will cover. A higher number of periods will result in a smoother, but less responsive trend line.
Periods ForwardThis specifies the number of periods into the future this function should forecast. The granularity of these periods is controlled by the overall granularity of the chart.
Missing ValuesThis specifies how missing data should be treated.
Prediction IntervalsThese are used to indicate a range where the actual value is likely to fall.
Interval Range (if prediction intervals used)

This specifies the certainty range of values to be displayed.

  • 80% certainty
  • 90% certainty
  • 95% certainty
  • 99% certainty
Hide Non-Forecast ResultsThis specifies if forecast should be dispalyed either for the whole dataset range OR only after the end of the dataset range.

 

 

Accumulation

Styleclass
ClasstopLink

top

This displays an accumulative % of total line on the chart, using a secondary axis.

 

Set Analysis

Styleclass
ClasstopLink

top

This allows you to display a subset of the data contained within a specified field.

In order to define a Set Analysis field you will:

  1. Select a report metric field to base the results on, 
  2. Specify a range of filters that will be applied solely to this field within the chart

Image Added

OptionDescription
Set NameThis specifies the display name of the resulting set analysis field, used in the chart labels and/or legend.
Set MetricThis allows you to select the field to filter down to your specified set. Only metric fields included in your report will be available in this list.
Filter

This allows you to specify the filters to be applied to your set field. Only category fields included in your report will be available in this list.

See Filter Settings for more information on how to define filter logic.

Note: Set Analysis filtering happens after the report results are returned from the database. This means that set analysis filters do not appear within the report SQL, and as such will be applied after user prompt filters.

 

Variance

Styleclass
ClasstopLink

top

This displays the difference between two fields from either the table or chart. The variance can be displayed as either the calculated value, or a % difference.

Image Added

OptionDescription
Variance NameThis specifies the display name of the resulting variance field, used in the chart labels and/or legend.
Variance Between

This allows you to select two fields to apply the variance calculation to. The values in the second field will be subtracted from the values in the first field, as part of the calculation, so order is important.

There are two types of field available to be used as part of a variance:

  1. Chart Fields - all standard fields used in a chart will be available, as well as:
    1. Chart Aggregated fields - this means you could calculate the variance between the chart aggregated field and it's original report field.
    2. Set Analysis fields - this means that you can calculate the variance between two sets.
  2. Report Fields - all metrics included in your table. This means that you don't necessarily have to use a metric in your chart to include it in the variance calculation.
Display Variance as

This allows you to select how the resulting variance values are displayed. There are two options:

  1. # Value - this will display the result of subtracting field one from field two, as a number.
  2. % Percentage - this will display the result of subtracting field one from field two, divided by value one (a percentage result).

 

 

horizontalrule
Styleclass
ClasstopLink

top