Documentation

Advanced Chart Options

The Chart Options let you customize and fine-tune your charts and graphs. They may differ depending on the chart type you have selected for your visualization and may offer different options. You can access the Chart Options in the Chart Creator with a click on the gear wheel in the right upper corner of the chart preview.

 

General Chart Options

 

The general Chart Options will allow you to edit the chart area and chart axes. You can access them with a click on the gear wheel icon in the right upper corner of the chart preview. Please click here to learn more about the general chart options.

 

Table Options

 

datapine offers a variety of options to customize and design your tables for a clearer structure and overview of your results. You can customize the table appearance, such as background color, text format and row setting as well as apply conditional rules to quickly identify variances in a range of values.

 

table options analyzer datapine

 

Table Style Options

 

The Table Style Options allow you to change the global background of the table, customize the borders and row colors or apply different font and text formats.

 

Access table style options

 

  1. Open the Chart Creator and create a table by dragging fields from your data source structure into the Y- and X-Axis or pasting your SQL query into the SQL Box.
  2. Click on Table Options in the upper, right corner of your chart preview.
  3. Select Table Style from the dropdown menu. The table style options will now appear on the right side of the Chart Creator.

datapine's adavanced table style options

 

You will have the following Table Style Options to customize the table colors and text formats:

 

– General Options: Define the cell background, the color for all even rows of your table and its borders.

 

– Text Format: Choose a custom font style and family as well as the alignment of the displayed text in the table rows.

 

– Row/Column Settings: Edit you columns by defining the exact amount of pixels for the row height from the drop down menu or allow text wrapping.

 

– Number Format: Set the number of decimal places, separator symbols for your decimals or add any additional symbols such as currencies to be displayed with your numbers.

 

Headers and Totals

 

This option lets you decide whether you want to show or hide your headers and display total rows at the bottom of the table offering different aggregation types.

 

header and total options in tables

 

Access the Headers and Totals settings via Table Options.

 

a) Column Headers: In this section, you can choose to display column headers and define the headers background color, font and alignment.

 

b) Total Row: In this section, you can choose to display totals at the bottom of the table choosing from various aggregation types and define their appearance.

 

Conditional Formatting

 

conditional formatting in datapine

 

Conditional column formatting

 

Follow the Instructions below to learn how to define formatting conditions for the columns of your table.

 

  1. Start with the column that should meet a specific condition.
  2. Then, select the condition, such as greater than (>) or equal to (=) etc.
  3. Add the value or switch to R to compare your defined column to another column.
  4. Choose the column that you would like to apply the formatting on, if the condition you have defined above is true.
  5. Select a format. You can choose to insert an icon, replace the displayed cell content with a text or choose a background or font color.

You can add as many conditions to your table as you wish. Simply click on Add new condition in the upper right corner of the menu. 

 

conditional-formatting-rules

 

Advanced column options

 

Access advanced column options

 

  1. Open the Chart Creator and build a table by dragging fields from your data source structure into the measures and dimensions.
  2. In the chart preview, click on the column you wish to edit. All options for this particular column will now be displayed on the right hand side of the Chart Creator.
  3. There, you can set a custom Header name for your column, change the column background, set a defined background color for all even rows in this column, as well as, choose a style for the borders.Additionally, you may change the text and number format for this particular column.

advanced column options for tables in datapine

 

Define table column width

 

If you would like to define a specific Column Width, you can simply select a unit such as Percentage or Pixels from the drop down list and enter your preferred width into the textbox to its left.

 

define column with for table in datapine

 

Add a total row to your table

 

At the bottom of the advanced column setting you may define a custom result row for this specific column. Simply select the preferred aggregation type for the result row, e.g. sum or average etc.

 

Custom table columns

 

You can insert custom columns using the columns of your table and enhance them with formulas.

 

add custom column to table in datapine

 

  1. To add a custom column to your table, right click on the column header where you wish to add the custom column to the right and from the column options popup select Add Column.
  2. In the new Add New Column pop up you can now drag and drop any of the available fields into the formula field and use common mathematical expressions to calculate or aggregate your custom column. 

Hide a table column / Unhide a table column

 

You can easily hide or unhide columns in your tables with just two clicks. Right click on to the header of the column you wish to hide and then select Hide Column. To unhide all hidden columns click on the Table Options icon in the right upper corner of the chart preview and then select Show all columns.

 

Define a default table sortation

 

You may add a default sortation to your table. Right click on the header of the column for which you wish to add the default sortation. In the chart options popup mouse over Sort and then define either an ascending (sorting from smallest to largest) or descending (sorting from largest to smallest) order.