This is a migrated thread and some comments may be shown as answers.

Is there a way to have a calculated series?

7 Answers 41 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Jonathan Travis
Top achievements
Rank 1
Jonathan Travis asked on 17 Mar 2014, 02:48 PM
I have a stock chart where I'm showing values from two years for comparison.  In my json, I have a field that shows the delta between the two values, ((thisyear - lastyear) / lastyear)

The problem I have is when the user zooms out of the chart, the delta gets aggregated incorrectly.

I want to know if I can create a series and add the formula that I showed, and have the chart calculate the delta instead of adding it to the json object.

7 Answers, 1 is accepted

Sort by
0
T. Tsonev
Telerik team
answered on 19 Mar 2014, 04:45 PM
Hi,

You can have series that build the data points on the fly. This is achieved by means of custom aggregate:
      series: [{
        aggregate: function(values, series, dataItems, category) {
          ...
        }
      }]

-- Live demo --

This is a viable solution if you can calculate the delta from the dataItems alone.

Regards,
T. Tsonev
Telerik
 

DevCraft Q1'14 is here! Watch the online conference to see how this release solves your top-5 .NET challenges. Watch on demand now.

 
0
Jonathan Travis
Top achievements
Rank 1
answered on 21 Mar 2014, 06:30 PM
That's good news.  Is there a way to do this with the MVC wrapper?

0
T. Tsonev
Telerik team
answered on 24 Mar 2014, 09:29 AM
Hello,

That's a good question because this doesn't seem to be possible with the MVC wrappers. We'll add the necessary overloads to allow setting custom aggregates.
I hope the fix will make it into the next internal build.

Thanks for spotting this omission. As a token of gratitude for your involvement your Telerik points have been updated.

Regards,
T. Tsonev
Telerik
 

Build cross-platform mobile apps using Visual Studio and .NET. Register for the online webinar on 03/27/2014, 11:00AM US ET.. Seats are limited.

 
0
Jonathan Travis
Top achievements
Rank 1
answered on 24 Mar 2014, 11:55 AM
Thanks for the update.  I'll be looking forward to the next release.
0
Jonathan Travis
Top achievements
Rank 1
answered on 25 Mar 2014, 03:43 PM
I've decided to convert my chart to an html chart specifically for this functionality, but the dataItems object is empty.

What am I doing wrong?

function createChart() {
    $("#htmlChart").kendoStockChart({
        dateField: "PostingDate",
        theme: "blueopal",
        chartArea: {
            height: 450
        },
        legend: {
            position: "top",
            visible: true
        },
        seriesDefaults: {
            type: "line",
            style: "smooth",
            tooltip:
           {
               visible: true,
               template: "#=TemplateFormat(value, category)#"
           }
        },
        series: [
        {
            field: "ThisYear",
            noteTextField: "ThisYearNote",
            name: "This Year",
            color: "orange",
            notes: {
                position: "top",
                label: {
                    position: "outside",
                    background: "rgba(255,255,255,.8)",
                    border: {
                        color: "orange",
                        width: 2
                    }
                }
            },

        }, {
            field: "LastYear",
            noteTextField: "LastYearNote",
            name: "Last Year",
            color: "#00CC00",
            notes: {
                position: "bottom",
                label: {
                    position: "outside",
                    background: "rgba(255,255,255,.8)",
                    border: {
                        color: "#00CC00",
                        width: 2
                    }
                }
            }

        },
            {
                field: "Planned",
                name: "Planned",
                color: "purple"

            },
            {
                name: "Delta",
                type: "area",
                aggregate: function(values, series, dataItems, category) {
                    return "1";
                }
            }
        ],
        categoryAxis: {
            axisCrossingValue: [0, 1000]
        },
        valueAxis: [
        {
            axisCrossingValue: -9999999999,
            plotBands: [
                { from: -999999999, to: 0, color: "#c00", opacity: 0.2 }
            ]
        }, { visible: false }, { visible: false }],

        navigator: {
            series: {
                type: "area",
                line: {
                    style: "smooth"
                },
                field: "ThisYear"
            },
            select: {
                from: window.startDate,
                to: window.endDate
            }
        },
        tooltip: {
            format: "C0",
            color: "white"

        },
        selectEnd: SelectionChanged,
        dragEnd: SelectionChanged,
        zoomEnd: SelectionChanged

    });
}
0
T. Tsonev
Telerik team
answered on 26 Mar 2014, 09:46 AM
Hi,

The dateItems list will be supplied if the aggregate is defined on a data-bound series. This will normally be all data points that fall within a specific category (date range).
For "unbound" series you only get the category parameter.

The result from the aggregate will determine what will be plotted. This can be a simple value or an object with the same structure as the data item.

Regards,
T. Tsonev
Telerik
 

Build cross-platform mobile apps using Visual Studio and .NET. Register for the online webinar on 03/27/2014, 11:00AM US ET.. Seats are limited.

 
0
Jonathan Travis
Top achievements
Rank 1
answered on 26 Mar 2014, 05:49 PM
Got it, thanks
Tags
General Discussions
Asked by
Jonathan Travis
Top achievements
Rank 1
Answers by
T. Tsonev
Telerik team
Jonathan Travis
Top achievements
Rank 1
Share this question
or