Name+Name2+Value graphs

The Depth Bar Graph, Multi Bar Graph and Tower Bar Graph are similar in that they all display bars and that they all three require the parameters name, name2 and value in the underlying data. For this reason these three graphs are similar in their configuration and the attributes used when defining the graph's appearance in the layout.

For all three types you can choose to use only one saved search or using multiple saved searches. One important exception however is that if you use multiple searches, your searches should only include the columns name and value. This will be explained in more depth on this page. Apart from describing how to create the searches, this page will also include some useful tips for the three graph types.

Creating saved searches

When you create your graph searches, make sure of the following:

  • Make sure to set a search title that makes it easy for you and everybody else to know that this search is used in a graph. Make also sure that the name is easy to remember as you will add it to your dataset record in a later step.

  • Assign your search an internal id.

  • The search must be set to Public.


If you add a tower bar graph, depth bar graph or multi bar graph using a single search, the search used must contain at least three columns, one labelled name, one labelled name2 and one labelled value. This is because the graph requires these three columns as parameters when rendering the graph.

If you create one of these graph types using multiple searches however the name2 column can be omitted as the value for this parameter will be fetched from the search's Graph search record and the Title field. See Multi search graph for more details.

As shown in the below example you must use the summary label if you set the Summary Type to either Sum, Count, Maximum, Minimum or Average. If you use Group or not use any summary type you must set the custom label field.

You can include more columns in your search if you want but these will not automatically be printed in the graph. Best practice is to only include the required columns.

If you create a multi search graph you need to make sure that you format the name-, name2- and value columns in the same way in all searches. If you for example have a date as name in one search you cannot have it as date/time in another search etc.

Depth Bar Graph

Below you will find the default attributes set for this graph type as well as an image example image of the rendered graph.

<depthbargraph
width="400"
height="200"
align="center"
yaxis-label="y-axis label"
xaxis-label="x-axis label"
xaxis-rotate="135"
display-barvalues="top"
display-key="boxed-right"
xrotation="30"
yrotation="30"
floor-color="#e8e8e8"
floor-border-color="#a9a9a9"
zwall-grid="horizontal"
zwall-border-color="#e8e8e8"
color-engine="[GRAPHNAME]:hue=random,luminosity=light"
>
<#if [GRAPHNAME]?has_content>
<#list [GRAPHNAME] as curve>
<gdata name="${item.name}" name2="${item.name2}" value="${item.value}" color="${item.color}" ></gdata>
</#list>
</#if>
</depthbargraph>
<depthbargraph
width="400"
height="200"
align="center"
yaxis-label="y-axis label"
xaxis-label="x-axis label"
xaxis-rotate="135"
display-barvalues="top"
display-key="boxed-right"
xrotation="30"
yrotation="30"
floor-color="#e8e8e8"
floor-border-color="#a9a9a9"
zwall-grid="horizontal"
zwall-border-color="#e8e8e8"
display-key="boxed-bottom"
color-engine="[GRAPHNAME]:hue=random,luminosity=light"
>
<#if [SEARCH1]?has_content>
<#list [SEARCH1] as item>
<gdata name="${item.name}" name2="${item.name2}" value="${item.value}" color="${item.color}" ></gdata>
</#list>
</#if>
<#if [SEARCH2]?has_content>
<#list [SEARCH2] as item>
<gdata name="${item.name}" name2="${item.name2}" value="${item.value}" color="${item.color}" ></gdata>
</#list>
</#if>
...
</depthbargraph>

Multi Bar Graph

Below you will find the default attributes set for this graph type as well as an image example image of the rendered graph.

<multibargraph
width="400"
height="200"
align="center"
yaxis-label="y-axis label"
xaxis-label="x-axis label"
xaxis-rotate="45"
display-barvalues="top"
bar-width="80%"
display-key="boxed-right"
zwall-grid="horizontal"
zwall-border-color="#e8e8e8"
color-engine="[GRAPHNAME]:hue=random,luminosity=light"
>
<#if [GRAPHNAME]?has_content>
<#list [GRAPHNAME] as curve>
<gdata name="${item.name}" name2="${item.name2}" value="${item.value}" color="${item.color}" ></gdata>
</#list>
</#if>
</multibargraph>
<multibargraph
width="400"
height="200"
align="center"
yaxis-label="y-axis label"
xaxis-label="x-axis label"
xaxis-rotate="45"
display-barvalues="top"
display-key="boxed-right"
zwall-grid="horizontal"
zwall-border-color="#e8e8e8"
display-key="boxed-bottom"
color-engine="[GRAPHNAME]:hue=random,luminosity=light"
>
<#if [SEARCH1]?has_content>
<#list [SEARCH1] as item>
<gdata name="${item.name}" name2="${item.name2}" value="${item.value}" color="${item.color}" ></gdata>
</#list>
</#if>
<#if [SEARCH2]?has_content>
<#list [SEARCH2] as item>
<gdata name="${item.name}" name2="${item.name2}" value="${item.value}" color="${item.color}" ></gdata>
</#list>
</#if>
...
</multibargraph>

Tower Bar Graph

Below you will find the default attributes set for this graph type as well as an image example image of the rendered graph.

<towerbargraph
width="400"
height="200"
align="center"
yaxis-label="y-axis label"
xaxis-label="x-axis label"
xaxis-rotate="45"
display-barvalues="top"
display-key="boxed-right"
zwall-grid="horizontal"
zwall-border-color="#e8e8e8"
color-engine="[GRAPHNAME]:hue=random,luminosity=light"
>
<#if [GRAPHNAME]?has_content>
<#list [GRAPHNAME] as curve>
<gdata name="${item.name}" name2="${item.name2}" value="${item.value}" color="${item.color}" ></gdata>
</#list>
</#if>
</towerbargraph>
<towerbargraph
width="400"
height="200"
align="center"
yaxis-label="y-axis label"
xaxis-label="x-axis label"
xaxis-rotate="45"
display-barvalues="top"
display-key="boxed-right"
zwall-grid="horizontal"
zwall-border-color="#e8e8e8"
display-key="boxed-bottom"
color-engine="[GRAPHNAME]:hue=random,luminosity=light"
>
<#if [SEARCH1]?has_content>
<#list [SEARCH1] as item>
<gdata name="${item.name}" name2="${item.name2}" value="${item.value}" color="${item.color}" ></gdata>
</#list>
</#if>
<#if [SEARCH2]?has_content>
<#list [SEARCH2] as item>
<gdata name="${item.name}" name2="${item.name2}" value="${item.value}" color="${item.color}" ></gdata>
</#list>
</#if>
...
</towerbargraph>

Useful tips and attributes

  • The attribute included in the <gdata> elements called color="${item.color}" is required for the coloring using color sets. Do not remove this attribute.

  • Bar values: If you want to change how to display the barvalues (on top in the example) you can adjust the display-barvalues attribute to "middle" or "insidetop". "none" removes them.

  • Bar width (Multi Bar Graph only): You can adjust the bar-width attribute to create larger or smaller gaps between the bars on the x-axis. The default width is set to 80%.