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

Error rendering macro 'rw-search'

null

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

These allow users to create charts directly on the presentation without going through Yellowfin Data Discovery’s report builder. Quick Charts are created using Blueprint widgets, which include some of the most widely used chart types, and choosing the Simple Report creation option. 

Note: For more advanced reporting, use Yellowfin’s Data Discovery.

...

  1. Click on the Blueprint button on the left side to expand its panel.



  2. Drag a chart type of your choice onto the slide. You can position and resize it to fit your design.
  3. You can add a title and description for it in its properties panel (make sure the Blueprint Widget is selected on the slide to make its properties panel appear).

    Tip

    Use the Activity Stream button (bottom right of the screen) to discuss and collaborate with other team members on your Blueprint further.




  4. To create a Quick Chart (created directly in the presentation) or even an advanced chart (created in the report builder, but added here upon publish), proceed with the following steps.

    Click on Create Report. You’ll be faced with two options:





    1. Create Simple Report: This option allows you to create a Quick Chart within the presentation slide. 

    2. Create Advanced Report: This allows you to create an advanced report. On doing so, you will exit the presentation and navigate to the report builder in Yellowfin Data Discovery. Create a report as per normal, and publish it. Then close the Report page to jump back into the same presentation where your newly created advanced report will be displayed.

  5. In this tutorial, we’ll be creating a Quick Chart, using the Create Simple Report button. Click on it to bring up the following form.

  6. Select a view from the list. Then select a dimension and series (metric) field for the chart.

  7. Click on the Create button.



  8. This will create a simple chart directly on the presentation, as shown in the example below.



  9. To further configure this chart, open the chart’s property panel, which will display additional fields, which vary for each chart type. Each chart will also differ based on the minimum set of fields to be defined for it. 



    1. You can create filters in your Quick Charts. Click on the +Filters button to define a filter condition.



      • In the new popup create a filter condition. Upon saving it, the final filter logic will be displayed in the properties panel.



      • Note, however, that to display a user prompt filter in the presentation, you will need to use a Filter Widget (see here for how to).

    2. Expand the Field Selection section and choose the data fields.
    3. Then in the Chart Settings section, define additional settings. 

      Note

      Refer to the chart type section below for further details on their specific configurations.


  10. You will notice your chart autogenerating with each field and configuration you define. You do not require additional steps to save the chart.
  11. You may update other properties of this widget, such as its size and location on the slide, and background details. See the properties panel for details on all widget properties.

...

Define the following chart fields to generate a meter chart (also called a gauge chart). These are used to measure the rate of change of a measure against pre-defined targets.

Field

Description/Instruction

Field Selection

Series

Measure

Select a series fields, which serves as your metric or measure field.

The series or metric field that serves as the measure for the meter chart.

Aggregation

Select the type of aggregation to apply to the measure value. ‘Default’ applies the default aggregation applied at the view level to the selected measure field (if any is applied). Other options include:

  • Sum
  • Average
  • Count
  • Count distinct
  • Min
  • Max

Chart Settings

Target type

Allows you to select how to add a target value to the chart, to highlight it through needles or other indicators. Options include:

  • Manual: allows you to manually enter the target value.
  • Field: allows you to select a metric field as the target value.

Target value

If Manual target type was selected, then provide the value of the target.

Target

(field)

If 'Field' target type was selected as the target type, then choose a data field as the target (must be a numeric field).

(Target) Aggregation

Apply an aggregation value on the target field. You can aggregate the values with the following options:

  • Default (the aggregation applied to the selected target field by default.)
  • Sum
  • Average
  • Count
  • Count distinct
  • Min
  • Max



Bar chart

Define the following chart fields to generate a horizontal bar chart.

Field

Description/Instruction

Field Selection

Dimension

Choose a dimension field for the chart.

Series

Select a series fields, which serves as your metric or measurement field.

Optional Fields
Aggregation

This is an additional field you may select for a slightly more advanced chart. Note that you may only select one of the following options:

Apply an aggregation value on the primary series. You can aggregate the values with the following options:

  • Sum
  • Average
  • Count
  • Count distinct
  • Min
  • Max
ColorSelect a color for the chart. This will be applied to the primary series.

Optional Fields

This is an additional field you may select for a slightly more advanced chart. Note that you may only select one of the following options:

  • Second series: Add
Second series: Add
  • another metric to your chart to show two time series lines.
  • Color
set
  • field: Apply the color range of any of the dimension field.
  • Function: Apply a chart function to your chart.
  • None: Does not apply an optional field to the chart.

Second series

If ‘Second series’ is selected as the optional field, then select a second metric field to be added to the chart.
You can configure formatting sections for this value via the Second Series Formatting section.

(Second

Series

series) Aggregation

Apply an aggregation value on the second series. You can aggregate the values with the following options:

  • Sum
  • Average
  • Count

Color set

  • Count distinct
  • Min
  • Max
(Second series) colorIf a second series is specified, then select a color to display this series in.

Color field

If ‘Color field’

If ‘Color set’

is selected as the optional field, then choose a dimension field as the color

set

field.

Function

If ‘Function’ is selected as the optional field, then select a chart function to be applied. Options include:

  • Average: Displays an average line on the chart.
  • Accumulation: Displays an accumulative % of total line or running total on the chart, using a secondary axis. You can further configure this value via the Function Settings section.
Ref
  • Reference line: Displays a reference line at a specified location. You can specify location details in the Function Settings section.

Chart Settings

Enable drill downAllows you to enable drill down functionality on the chart.

Axis type

If the chart has a second series, then you can further configure the axis type. Options include:

  • Shared axis: Allows both series to have the same axis.
  • Dual axis: Displays 2 axes, with an extra one on top of the chart. The first series will be shown on the bottom axis, and the second series, the top axis.
Secondary
  • Second series: Displays both charts with separate axes, next to each other. The first series chart will display on the left, and the second series chart on the right. Both charts will have separate vertical axes.
  • Stacked: Displays both the series data horizontally stacked in the same chart.

Date unit

If you have selected a date dimension field, this setting allows you to change the date unit. Note: you cannot select a date unit lower than the unit defined in the view. 

Axis summary

Enable this setting to apply automatic abbreviation to axis labels. This is useful for charts with large numeric values. For example, 10,000,000 will be changed to 10m, making it easier to read.

Sort

dimension

by

Change the sort order of how dimension values are displayed. Sort these values by:

Primary series: sorts the chart by the values of the first/primary series.
  • Auto: Determines best sort depending on the chart type. 
  • Grouped data: This means that the chart will be sorted according to the order of the grouped data.
  • Primary series: sorts the chart by the values of the first/primary series.
  • Alphanumeric: Sorts the chart in alphabetical order of dimension field values. 
Ref
  • Reference code: Sorts the value according to their reference codes if applied on the dimension field.

Sort order

Allows you to choose the sorting direction between ascending and descending.

  • Ascending: Values are sorted from lowest to highest.
  • Descending: values are sorted from highest to lowest.
Trim Values (toggle)If your selected dimension
fields contain
field contains too many values to the point where it’s difficult to read your chart,
you can use
enable this
setting
toggle to trim or cut out values from the chart.
  • None: No values will be trimmed.
  • Trim Display

    If your dimension fields contain too many values to the point where it’s difficult to read your chart, you can use this setting to trim or cut out values from the chart.

    • Top N
    Top N
    • : Trims the top
    ‘N’ amount of
    • 10 values from the chart
    . Specify ‘N’ in the next field
    • .
     
    • Bottom N: Trims the bottom
    ‘N’ amount of
    • 10 values from the chart.
    Specify ‘N’ in the next field. 

    Show Other Dimension

    Enable this to sum all trimmed out values together and display under an ‘Other’ field.

    Color set

    Define the color set of the chart.

    • Standard: uses standard default colors on chart.
    • Monochrome: uses variations of a single color on chart

    Trim value

    If value trim is enabled, specify the amount of values (N) to be cut out from the chart. 

    Trim show other bar

    Enable this to sum all trimmed out values together and display under an ‘Other’ field.

    Color property

    Define the color property of the chart.

    • Standard: uses standard default colors on chart.
    • Monochrome: uses variations of a single color on chart.

    Series Formatting

    This section allows you to set up formatting of the primary series in the chart.

    Color

    Specify a color to display the primary/first series in.

    Second series Formatting

    This section allows you to set up formatting of the secondary series in the chart, if specified.

    Color

    Specify a color to display the second series in
    • .

    Function settings

    This section allows you to manage settings related to some of the chart functions.

    Accumulation

    Function type

    If the accumulation function is enabled on the chart, you can choose whether this value should be displays as the accumulative % of the total line, or the running total.

    Value

    If the

    Ref

    Reference line function is selected, then specify the position of this line by providing the exact value.

    Label

    If

    the Ref

    the Reference line function is selected, then provide its label.

    Color

    If

    the Ref

    the Reference line function is selected, then specify its color.



    ...

    Blueprint Widget properties

    This section covers other properties details of a Blueprint Widget.

    Section


    Column


    Image RemovedImage Added


    Column


    Property name

    Description

    Name

    Allows you to update the name of the selected Blueprint widget. This is ideal for code mode.

    Chart title

    Allows you to provide a title for the chart.

    Description

    Allows you to provide a description of the chart. 

    FiltersThe +Filters button allows you to create a filter on the selected Quick Chart. Once the filter logic has been defined, it will appear in this area.

    Field Selection

    This section shows data fields to be selected for the Quick Chart. Note that the configurations shown here will differ according to the selected chart type.

    For more information on the different settings in this section, refer to the wiki’s section on a selected blueprint chart types.

    Chart Settings

    This section allows you to apply chart settings on the Quick Chart. These will differ depending on the chart type selected.

    Series Formatting

    Allows you to configure settings related to chart series formatting, such as series color.

    Size & location


    X

    Specify the x coordinates of the top left corner of the widget, in order to position it exactly on your presentation slide.

    Y

    Specify the y coordinates of the top left corner of the widget, in order to position it exactly on your presentation slide.

    Width

    Specify the width of the currently selected widget, in pixels, in order to resize it exactly.

    Height

    Specify the height of the currently selected widget, in pixels, in order to resize it exactly.

    Corners

    This option allows you to define the roundness of your widget border corners. Tip: For maximum circular edges, enter half the value of the widget height. For example, if the height is 400 pixels, then set the edge value to 200 pixels. Moreover, any value greater than 200 for the edge, will have no further effect in this example.

    Aspect ratio

    Enable this toggle to maintain the aspect ratio. This means when increasing or decreasing the widget size, it maintains its shape (i.e. the relationship between its width and height).

    If this is disabled, the widget can be stretched out of shape either vertically or horizontally.

    Lock widget

    Enable this toggle to lock the widget in its location. This stops you from moving or resizing it. This holds true even when selecting multiple widgets on the slide. Note that the widget can still be customized. 

    Background formatting 

    Background color

    Allows you to specify a background color for the widget. 

    Opacity

    Allows you to specify the transparency of the widget's background color.

    Customise padding

    This option allows you to define a custom padding or buffer around the widget, in pixels, when enabled. This includes padding for each side to the widget. If disabled, you can still define an overall padding size.

    Padding top

    When custom padding is enabled, this allows you to define padding to be added to the top of the widget.

    Padding bottom

    When custom padding is enabled, this allows you to define padding to be added to the bottom of the widget.

    Padding right

    When custom padding is enabled, this allows you to define padding to be added to the right of the widget.

    Padding left

    When custom padding is enabled, this allows you to define padding to be added to the left of the widget.

    Padding 

    This allows you to define an overall padding size for the widget. This size, defined in pixels will be constant for each widget side. To add different sized padding on any of the sides, enable the Customise Padding option.

    Border width

    This allows you to specify the thickness of the widget border.

    Note: to make the border visible, you must define values for all three border properties.

    Border style

    This allows you to select a style for the widget border. Options include: dashed, solid, dotted, groove, and more.

    Border color

    This allows you to specify the color of the widget border.

    Horizontal shadow

    This option allows you to drop a horizontal shadow on the widget, by defining its size in pixels.

    Vertical shadow

    This option allows you to drop a vertical shadow on the widget, by defining its size in pixels.

    Shadow blur

    This option allows you to define the sharpness of the widget shadow. The smaller the value, the sharper and more defined the shadow will be. For a blurry or softer shadow, provide a bigger value.

    Shadow color

    This option allows you to set a color for the widget shadow.