Hi Martin,

Thank you for your reply and helping out, I tried to implement this and test it out and it works when the array is static. Currently, I'm working on this with an API call and using ajax to get the data, and the data would not update on the DataChart with the ajax call with this layout. Is there a way to use this layout calling the usage of a dynamically rather than static?

Thank you,

Hello Tu,

As we have already mentioned, in order to be able to assist you further we will need a working sample which we can debug on our sides in order to find the root cause of described behavior.

What I would suggest you is to modify the sample that I have provided and send it back to us for further investigation. Alternatively, if the behavior cannot be replicated, please feel free to provide your own isolated sample, where the issue is reproducible. Please keep in mind to remove any dependencies and code that is not directly related to the issue.

Looking forward to hearing from you!

Regards,
Viktor Kombov
Entry Level Software Developer
Infragistics, Inc.

Hi Martin,

Below will be couple snippet of code on how I setup the entire thing, and I will divide it up and give you each what each function does:

IgDataChart Setup: This is the code using the same example Viktor gave me and I modify it around a bit to fit what my project require.

// Setup a function for calling data chart
    function CreateChart(chartID, seriesType, chartTitle, chartData) {
        // Create a variable to map each unique dateTime & States
        var uniqueDates = chartData.map(rec => rec.dateTime)
            .filter((value, index, self) => self.indexOf(value) === index)
            .map((item) => {
                return {
                    dateTime: new Date(item)
            }
        });

        var uniqueStates = chartData.map(rec => rec.state)
            .filter((value, index, self) => self.indexOf(value) === index);

        // Setup an empty array to store the series of each states
        var seriesStates = [];

        // Go through each states and push the data for that state by creating a series for it
        uniqueStates.forEach(stateName => seriesStates.push(CreateSeries('line', stateName, chartData)))

        // Setup the igDataChart
        $(chartID).igDataChart({
            width: "1300px",
            height: "600px",
            title: chartTitle,
            dataSource: data,
            gridMode: "beforeSeries",
            legend: { 
                element: 'legend', 
                type: 'legend'
            },
            axes: [{
                name: "xAxis",
                type: "categoryDateTimeX",
                title: "Date & Time of Fuel",
                dataSource: uniqueDates,
                dateTimeMemberPath: "dateTime",
                label: "dateTime",
                labelAngle: 0,
                formatLabel: function(item) {
                    var res = '';
                    res += item.getMonth() + 1;
                    res += "/";
                    res += item.getDate();
                    res += "/";
                    res += item.getFullYear();
                    res += '  '
                    return res;
                },
                labelTextStyle: "9pt Verdana",
                }, 
                {
                    name: "yAxis",
                    type: "numericY",
                    title: "Diesel Fuel Price(s)",
                    labelTextStyle: "9pt Verdana",
            }],
            series: seriesStates
        });
    }
            
    // Setup a function to create per series to match with states' data
    function CreateSeries(seriesType, stateName, chartData) {
        // Create a series variable to filter through date and states
        var seriesData = chartData.filter(rec => {
            if (rec.state === stateName) {
                return true;
            }
        }).map((item) => {
            return {
                ...item,
                dateTime: new Date(item.dateTime),
            };
        });

        // Setup some variables to create series line
        var thickness = 2;
        var markerType = "none";

        // Check for some seriesType and set it correctly
        if (seriesType == "column" || seriesType == "waterfall") {
            thickness = 1;
        }

        if (seriesType == "point") {
            markerType = "circle";
        }

        if (seriesType == "line") {
            markerType = "circle";
        }

        // Create the series to show on graph/data chart
        var series = {
            type: seriesType,
            dataSource: seriesData,
            markerType: markerType,
            xAxis: "xAxis",
            yAxis: "yAxis",
            name: stateName + "series",
            title: stateName,
            valueMemberPath: "diesel",
            isTransitionInEnabled: true,
            isHighlightingEnabled: true,
            showTooltip: true,
            thickness: thickness
        }
                
        // Return the series to the chart       
        return series;
    }

GetGridData: This function called the igcombo to get the selected states from the box and get the date to be pass into another function (in the code below too) where it uses AJAX call to get the data to that specific states to bind it onto the chart and grid:

// Create a function to get data for the grid
    function GetDataForGrid() {
        // Create an array that store the states was selected
        var statesSelected = [];
        var selectedStates = $("#SelectedStatesList").igCombo("selectedItems");

        // Check to see if states was selected or is it a default states
        if(selectedStates == null) {
            statesSelected.push({stateName: "Oregon"});
            statesSelected.push({stateName: "Washington"});
        }
         
        else {
            $.each(selectedStates, function(index, value){
                statesSelected.push({stateName: value.data.stateName});
            });
        }

        // Store the start & end dates to be used later
        var start = $("#StartDate").val();
        var end = $("#EndDate").val();

        // Call the function to get data from the states selected
        PostAndGetDataForGridandChart(start, end, statesSelected);
    }

    // Create the POST & GET data for Grid function & the Data Chart
    function PostAndGetDataForGridandChart(start, end, statesSelected) {
        $.ajax({
            type: "POST",
            url: '@Url.Action("GetGridData", "Home")',
            data: { StartDate: start , EndDate: end, SelectedStates: statesSelected },
            dataType: "json"
        })
        .done(function (json) {
            // Bind the data onto the grid
            $("#mainGrid").igGrid("option", "dataSource", json);
            $("#mainGrid").igGrid("dataBind");

            // First destroy the chart with old data
            $("#chart").igDataChart("destroy");

            // Then generate the updated one with the new data
            CreateChart("#chart", "line", "Fuel Price(s) Web Statistic", json);

        })
        .fail(function (jqXhr, textStatus, errorThrown) {
            console.warn(jqXhr.responseText);
            alert(errorThrown + ' getJSON request failed for grid & chart ' + textStatus);
        });
    }

Setup of IgCombo: The setup of combo box in the on-load event

// Setup the stateSelection Box
        $("#SelectedStatesList").igCombo({
            dataSource: states,
            textKey: "stateName",
            valueKey: "stateName",
            width: "250px",
            height: "30px",
            dropDownWidth: "200px",
            format: "auto",
            multiSelection: {
                enabled: true,
                addWithKeyModifier: false,
                showCheckboxes: true,
                itemSeparator: ', '
            },
            selectionChanged: function(evt, ui){
                GetDataForGrid();
            }
        });

This is how setup layout is. The result from the data to be parse onto the chart follow the same format as the data I gave back in a couple comments ago about how the AJAX return the data. And the parsing can be found under the code GetGridData snippet. If there is anything else you guys need. Feel free to reach out to me. And thank you for taking the time looking into this for me.

Sincerely,

Tu Lam

Hello Lu,

Thank you for getting back to us!

Please note that as Viktor have mentioned without having a small working sample which we can debug on our sides it is going to be very hard to find the root cause of the described behavior. There are multiple approaches for appending new data to the chart (expanding the data source, appending new series which data comes from another data source and etc.) and in order to be able to assist you further we need to make sure that we start from the same point.

Having this in mind I could suggest modifying the sample Viktor has provided and send it back to us for further investigation. You can add a combobox with only 3 states, 2 starting with the letter “A” and one different. Please make sure that you’re using the exact same logic for populating the igDataChart as the one in your main project and that the issue when selecting the states starting with the letter “A” is still reproducible.

Looking forward to hearing from you!

Best Regards,
Martin Evtimov
Software Developer
Infragistics, Inc.

Hi Viktor,

Thank you so much for your help, I was able to got it to work and stuff on my end. Everything is working correctly. Thank so much again for your help.

One last thing I wanted to let you guys know, I don't know if it is a bug with igDataChart or not, but I have a dropdown box of states list. But every time I selected states that starts with the letter A (Alaska, Alabama, Arkansas, Arizona) won't populate on graph if they are combine together with other states and only populate if that is the only state selected.

Everything else work fine with other states either alone or combining them to display on chart like from California and onward.

I was just wondering if this is a bug on the igDataChart side or is it something wrong with my code?

[PS: I checked the data was store correctly on the array before it is pass into datachart so I know data is correctly format]

Thank you,

Tu Lam