Edit this page

kpiTrendTemplate String |Function

The template which renders the content of the KPI Trend value. By default renders "increase", "decrease" and "equal" status icons.

The fields which can be used in the template are:

  • columnTuple - the tuple of the corresponding column header cell
  • rowTuple - the tuple of the corresponding row header cell
  • measure - the value of the data cell measure
  • dataItem - the data item itself

For information about the tuple structure check this link. About the data item structure review this help topic.

Example - specify a custom template for the KPI Trend measure

<div id="pivotgrid"></div>

<script id="kpiTrendTemplate" type="text/x-kendo-template">
    # if (dataItem.value !== 0) { #
        <em>Increase/Decrease</em>
    # } else { #
        <strong>Equal</strong>
    # } #
</script>

<script>
$("#pivotgrid").kendoPivotGrid({
    kpiTrendTemplate: $("#kpiTrendTemplate").html(),
    dataSource: {
        type: "xmla",
        columns: [{ name: "[Date].[Calendar]", expand: true } ],
        measures: ["[Measures].[Internet Revenue Trend]"],
        transport: {
            connection: {
                catalog: "Adventure Works DW 2008R2",
                cube: "Adventure Works"
            },
            read: {
                url: "https://demos.telerik.com/olap/msmdpump.dll",
                dataType: "text",
                contentType: "text/xml",
                type: "POST"
            }
        },
        schema: {
            type: "xmla"
        }
    }
});
</script>
Is this article helpful? Yes / No
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article

close
Dummy