jQWidgets Forums

Hello,
I have a line chart which displays 3 sets of data. For some reason if I set my search criteria say to 7/1/2015 to 9/2/2015 my database returns me the proper data set however no data shows in my chart, if I change the date to : 7/1/2015 to 8/31/2015 the data displays. it s the same json response but minus the Septembers dates however, this time data is there… here my data stream the includes september ( note shortname and site is not used )

this includes
{"GetTotalMediaResult":[{"Date":"09\/02\/2015","ShortName":null,"Site":null,"TotalFeet":234599,"TotalJobs":237,"TotalPages":510105},{"Date":"09\/01\/2015","ShortName":null,"Site":null,"TotalFeet":329148,"TotalJobs":275,"TotalPages":715881},{"Date":"08\/31\/2015","ShortName":null,"Site":null,"TotalFeet":355228,"TotalJobs":306,"TotalPages":756366},{"Date":"08\/28\/2015","ShortName":null,"Site":null,"TotalFeet":179743,"TotalJobs":225,"TotalPages":390558},{"Date":"08\/27\/2015","ShortName":null,"Site":null,"TotalFeet":149120,"TotalJobs":232,"TotalPages":320660},{"Date":"08\/26\/2015","ShortName":null,"Site":null,"TotalFeet":168800,"TotalJobs":258,"TotalPages":382712},{"Date":"08\/25\/2015","ShortName":null,"Site":null,"TotalFeet":320041,"TotalJobs":253,"TotalPages":697398},{"Date":"08\/24\/2015","ShortName":null,"Site":null,"TotalFeet":302639,"TotalJobs":264,"TotalPages":643456},{"Date":"08\/21\/2015","ShortName":null,"Site":null,"TotalFeet":210689,"TotalJobs":224,"TotalPages":453641},{"Date":"08\/20\/2015","ShortName":null,"Site":null,"TotalFeet":248967,"TotalJobs":318,"TotalPages":479182},{"Date":"08\/19\/2015","ShortName":null,"Site":null,"TotalFeet":344536,"TotalJobs":243,"TotalPages":591859},{"Date":"08\/18\/2015","ShortName":null,"Site":null,"TotalFeet":292485,"TotalJobs":287,"TotalPages":616923},{"Date":"08\/17\/2015","ShortName":null,"Site":null,"TotalFeet":452445,"TotalJobs":306,"TotalPages":1003974},{"Date":"08\/14\/2015","ShortName":null,"Site":null,"TotalFeet":197684,"TotalJobs":325,"TotalPages":447253},{"Date":"08\/13\/2015","ShortName":null,"Site":null,"TotalFeet":203417,"TotalJobs":267,"TotalPages":449762},{"Date":"08\/12\/2015","ShortName":null,"Site":null,"TotalFeet":254550,"TotalJobs":262,"TotalPages":547218},{"Date":"08\/11\/2015","ShortName":null,"Site":null,"TotalFeet":419742,"TotalJobs":339,"TotalPages":905504},{"Date":"08\/10\/2015","ShortName":null,"Site":null,"TotalFeet":457525,"TotalJobs":446,"TotalPages":1126313},{"Date":"08\/07\/2015","ShortName":null,"Site":null,"TotalFeet":178937,"TotalJobs":312,"TotalPages":419526},{"Date":"08\/06\/2015","ShortName":null,"Site":null,"TotalFeet":233783,"TotalJobs":250,"TotalPages":485131},{"Date":"08\/05\/2015","ShortName":null,"Site":null,"TotalFeet":367848,"TotalJobs":273,"TotalPages":775471},{"Date":"08\/04\/2015","ShortName":null,"Site":null,"TotalFeet":555601,"TotalJobs":304,"TotalPages":1210761},{"Date":"08\/03\/2015","ShortName":null,"Site":null,"TotalFeet":371603,"TotalJobs":310,"TotalPages":763460},{"Date":"07\/31\/2015","ShortName":null,"Site":null,"TotalFeet":231380,"TotalJobs":210,"TotalPages":450855},{"Date":"07\/30\/2015","ShortName":null,"Site":null,"TotalFeet":216016,"TotalJobs":265,"TotalPages":449036},{"Date":"07\/29\/2015","ShortName":null,"Site":null,"TotalFeet":296250,"TotalJobs":273,"TotalPages":601283},{"Date":"07\/28\/2015","ShortName":null,"Site":null,"TotalFeet":246976,"TotalJobs":279,"TotalPages":526119},{"Date":"07\/27\/2015","ShortName":null,"Site":null,"TotalFeet":346820,"TotalJobs":334,"TotalPages":706028},{"Date":"07\/24\/2015","ShortName":null,"Site":null,"TotalFeet":260980,"TotalJobs":264,"TotalPages":578769},{"Date":"07\/23\/2015","ShortName":null,"Site":null,"TotalFeet":193790,"TotalJobs":246,"TotalPages":423095},{"Date":"07\/22\/2015","ShortName":null,"Site":null,"TotalFeet":702548,"TotalJobs":317,"TotalPages":1512865},{"Date":"07\/21\/2015","ShortName":null,"Site":null,"TotalFeet":1023025,"TotalJobs":339,"TotalPages":2200628},{"Date":"07\/20\/2015","ShortName":null,"Site":null,"TotalFeet":714050,"TotalJobs":358,"TotalPages":1650735},{"Date":"07\/17\/2015","ShortName":null,"Site":null,"TotalFeet":485011,"TotalJobs":239,"TotalPages":1046870},{"Date":"07\/16\/2015","ShortName":null,"Site":null,"TotalFeet":645382,"TotalJobs":289,"TotalPages":1376303},{"Date":"07\/15\/2015","ShortName":null,"Site":null,"TotalFeet":416529,"TotalJobs":260,"TotalPages":908176},{"Date":"07\/14\/2015","ShortName":null,"Site":null,"TotalFeet":512000,"TotalJobs":289,"TotalPages":1096331},{"Date":"07\/13\/2015","ShortName":null,"Site":null,"TotalFeet":438450,"TotalJobs":292,"TotalPages":955374},{"Date":"07\/11\/2015","ShortName":null,"Site":null,"TotalFeet":226990,"TotalJobs":54,"TotalPages":494150},{"Date":"07\/10\/2015","ShortName":null,"Site":null,"TotalFeet":278375,"TotalJobs":312,"TotalPages":676020},{"Date":"07\/09\/2015","ShortName":null,"Site":null,"TotalFeet":699297,"TotalJobs":308,"TotalPages":1520807},{"Date":"07\/08\/2015","ShortName":null,"Site":null,"TotalFeet":1025313,"TotalJobs":339,"TotalPages":2229870},{"Date":"07\/07\/2015","ShortName":null,"Site":null,"TotalFeet":576413,"TotalJobs":302,"TotalPages":1440165},{"Date":"07\/06\/2015","ShortName":null,"Site":null,"TotalFeet":572275,"TotalJobs":532,"TotalPages":1266785},{"Date":"07\/02\/2015","ShortName":null,"Site":null,"TotalFeet":317072,"TotalJobs":237,"TotalPages":683102}]}

below is the javascript I’m using for the chart:

function LoadMediaLineChart(site, container, fromdate, todate, rgsel) {

    var Url = 'http://l4dwipap2210/prismadashboard/IPrismadashboard.svc/GetTotalMedia/' + site + '/' + fromdate + '/' + todate;
    //Url += 'GetTotalMedia/Bond'
   

    $.getJSON(Url, function (data) {

        var source =
          {
              datatype: "json",

              datafields: [
                 { name: 'Date' },
                 { name: 'Site' },
                 { name: 'TotalPages' },
                 { name: 'TotalFeet' },
                 { name: 'TotalJobs' }
              ],

              url: Url
          };

        var dataAdapter = new $.jqx.dataAdapter(source, { async: false, autoBind: true, loadError: function (xhr, status, error) { alert('Error loading "' + source.url + '" : ' + error); } });
        var months = ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'];

        var parts = fromdate.split('-');
        var mindate = new Date(parts[2], parts[0] -1, parts[1]); // current date
        mindate.setDate(1); // going to 1st of the month
        mindate.setHours(-1); // going to last hour before this date even started.
       // console.log(d.getMonth() + '-' + d.getDate() + '-' + d.getFullYear())

        var settings = {
            title: site + " : Print Media",
            description: '(' + fromdate + " - "+  todate +")",
            enableAnimations: true,
            showLegend: true,
            padding: { left: 10, top: 5, right: 10, bottom: 5 },
            titlePadding: { left: 50, top: 0, right: 0, bottom: 10 },
            source: dataAdapter,
            xAxis:
            {
                dataField: 'Date',
                formatFunction: function (value) {
                     return months[value.getMonth()] + '-' + value.getDate() + '-' + value.getFullYear();
                   // return months[value.getMonth()]
                },
                type: 'date',
                baseUnit: 'month',
                valuesOnTicks: true,
                minValue: mindate,
                maxValue: todate,
                tickMarks: {
                    visible: true,
                    interval: 1,
                    color: '#BCBCBC'
                },
                unitInterval: 1,
                gridLines: {
                    visible: true,
                    interval: 3,
                    color: '#BCBCBC'
                },
                labels: {
                    angle: -45,
                    rotationPoint: 'topright',
                    offset: { x: 0, y: -25 }
                }
            },
            valueAxis:
            {
                visible: true,
                title: { text: 'Daily Totals<br>' },
                tickMarks: { color: '#BCBCBC' }
            },
            colorScheme: 'scheme04',
            seriesGroups:
                [
                    {
                        type: 'line',
                        series: [
                        { dataField: 'TotalPages', displayText: 'Total Pages', lineWidth: 1, lineWidthSelected: 1 },
                        { dataField: 'TotalFeet', displayText: 'Total Feet', lineWidth: 1, lineWidthSelected: 1 },
                        { dataField: 'TotalJobs', displayText: 'Total Jobs', lineWidth: 1, lineWidthSelected: 1 },

                        ]
                    }
                ]
        };
       
        $(container).jqxChart(settings)
    });

  }

any help would be great.