Chart Settings Tips

Explains tips for chart settings

Common settings

Value Formatting

By default, the format of values and labels displayed in charts is optimized according to your account's language settings. You can also change the formatter via the chart's "Advanced Settings." If a formatter is manually changed, the specific formatter settings will take precedence over the language settings.

Configuration Examples

For example, in the case of an XY Chart, you can specify formatters as follows:

• X-axis/Y-axis Label Format

  • Specify via "Advanced" > "X Axis / Y Axis" > "Value formatter"

• Tooltip Format

  • Specify via "Advanced" > "Series" > "(Series Name)" > "Value formatter"

• Value Label Format (if "Value label" are enabled)

  • Specify via "Advanced" > "Series" > "(Series Name)" > "Value label" > "Value label formatter"

Number Formatter

The number formatter uses d3-format syntax for formatting.

For example, you can specify settings as shown below:

Setting Value	Value	Format Result
.0f	12345.6789	12346
,.1r	12345.6789	10,000
-.1%	0.5	50%

Additionally, you can enclose the d3-format syntax in { and } to add prefixes or suffixes before or after the value. (Note: This is a custom extension, not standard d3-format syntax. Please refer to the examples below.)

Setting Value	Value	Format Result
{,d} USD	12345.6	12,346 USD
Approx. {,d}%	50	Approx. 50%

Date Formatter

The date formatter uses Day.js syntax for formatting. (In some cases, you can toggle between the Number Formatter and Date Formatter using the button on the left edge of the input field.)

For example, you can specify settings as shown below:

Setting Value	Date	Format Result
YYYY-MM-DD	2025-01-01	2025-01-01
YY/M/D	2025-01-01	25/1/1
MMMM YYYY	2025-01-01	January 2025

Adjusting Axis Label Display Width

You can limit the display width of labels for each axis by setting the maximum width (px) of axis labels.

Enter a numeric value (e.g., 100, 200) in the chart settings screen "Advanced" > "Axis label max size(px)". This can be useful when you want to display long label text with ellipsis.

Table Chart

Image Display

In "Advanced" settings of table chart, you can display images within table charts.

• By selecting the target column from "Column Settings" and enabling "Preview image URL", image URLs will be displayed as images within the table chart.

• When "Enable link URL" is activated, they will be displayed as links that open the URL in a new tab.

Creating Parameterized Links from Table Charts to Reports

By dynamically generating URLs in SQL queries, you can pass data from each row of the table as parameters to another report page.

1. Creating a report and obtaining the URL

   • Set parameters in the destination report and obtain the URL from the browser's address bar.

     • Example URL: https://app.codatum.com/workspace/{workspace_id}/report/{report_id}/{page_id}

   • How to check parameter ID: Note the ID of the parameter widget in the report (e.g., 68f369edf5e6f69036b8872d)

2. Creating a URL column in SQL

   • Use the CONCAT function to generate a URL containing parameters from each row's data and insert it into the chart.

   • Example with a single parameter (country name):

     CONCAT(
       'https://app.codatum.com/workspace/{workspace_id}/report/{report_id}/{page_id}?cdm.params.{parameter_id}=',
       country  --- Column name to pass as parameter
     ) AS link

3. Enabling links in table chart

   • Table chart settings → Column settings → Target column → Turn on "Enable link URL".

Notes

• Replace the country part with the database column name you want to pass as a parameter

• You cannot reference the current value of parameter widgets in SQL (only fixed values or column values)

• When a user clicks a cell, the report opens in a new tab

• For detailed information on parameter settings, see here

Pivot Table

Drill Down

Pivot tables can display rows hierarchically and allow collapsing them.

How to Configure

1. Set multiple row fields

   • In chart settings "Rows", set two or more fields such as major category and minor category.

   • Example: Prefecture (major category) → City/Town/Village (minor category)

2. Switch to tree display

   • "Detailed Settings" → "Layout" → "Default Hierarchy Type" → Select "Tree".

     • Grid: Traditional table format

     • Tree: Display in hierarchical structure, expandable/collapsible with expand/collapse icons

3. Set initial state to collapsed (optional)

   • Check "Display Collapsed" to show all hierarchies collapsed in the initial display.

Notes

• This setting is only available when there are two or more row fields

• Report viewers can freely expand and collapse