---
title: "ACE Analytics CDML Examples"
slug: "ace-analytics-cdml-examples"
updated: 2023-04-19T22:20:56Z
published: 2023-04-19T22:20:56Z
canonical: "docs.interprose.com/ace-analytics-cdml-examples"
stale: true
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.interprose.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ACE Analytics CDML Examples

Here are some examples of CDML in action in applications:

### Creating a 2-Line Axis Title

![](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/RB_62.png?sv=2026-02-06&spr=https&st=2026-10-31T18%3A40%3A16Z&se=2026-10-31T19%3A40%3A16Z&sr=c&sp=r&sig=NmVpXM%2FS5u5fsVALZaPQDc8Zvp6vVta1Pa6u2WNSMRo%3D)

As shown above, a simple <*br*> tag is used in the **Label Title** attribute to produce a 2-line title.

### Using Subscripts in an Axis Title

![](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/RB_63.png?sv=2026-02-06&spr=https&st=2026-10-31T18%3A40%3A16Z&se=2026-10-31T19%3A40%3A16Z&sr=c&sp=r&sig=NmVpXM%2FS5u5fsVALZaPQDc8Zvp6vVta1Pa6u2WNSMRo%3D)

1. As shown above, the <*block*> and <*/block*> tags are used in the **Data Title** attribute to delimit the new font style.
2. The <*sub*> tag specifies the new style, i.e. subscript.
3. The <*/font*> tag ends the new style and returns to the original style.

### Setting Font Size and Adding Superscript in an Axis Title

![](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/RB_64.png?sv=2026-02-06&spr=https&st=2026-10-31T18%3A40%3A16Z&se=2026-10-31T19%3A40%3A16Z&sr=c&sp=r&sig=NmVpXM%2FS5u5fsVALZaPQDc8Zvp6vVta1Pa6u2WNSMRo%3D)

1. As shown above, the <*block*> and <*/block*> tags are used in the **Label Title** attribute to delimit the new font style.
2. The <*size*> and <*super*> tags are used to define the new font styles.
3. The <*/font*> tag ends the new style and returns to the original style.

### Creating a 2-Line Data Label

To format data using CDML, it's necessary to first add a column to the datalayer to contain the formatted data.

![](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/RB_65.png?sv=2026-02-06&spr=https&st=2026-10-31T18%3A40%3A16Z&se=2026-10-31T19%3A40%3A16Z&sr=c&sp=r&sig=NmVpXM%2FS5u5fsVALZaPQDc8Zvp6vVta1Pa6u2WNSMRo%3D)

1. As shown above, a **Calculated Column** is used to combine the data from two columns and add a <*br*> tag in between them to put the data on two lines.

![](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/RB_66.png?sv=2026-02-06&spr=https&st=2026-10-31T18%3A40%3A16Z&se=2026-10-31T19%3A40%3A16Z&sr=c&sp=r&sig=NmVpXM%2FS5u5fsVALZaPQDc8Zvp6vVta1Pa6u2WNSMRo%3D)

1. The chart's **Label Column X-axis** attribute value is then set to the name of the calculated column, as shown above.

Alternately, instead of using a Calculated Column element, the results shown in the example above could also be achieved by **including CDML** right in the **SQL query**. For example:

SELECT FQuarter + '<*br*>' + RIGHT(FYear,2) AS calcQuarterYear FROM SomeSQLTable

would return a column that concatenated the values from two others with the CDML tag needed to insert the new line.