stapelchip

Forum Replies Created

Viewing 12 replies - 1 through 12 (of 12 total)
  • Author
    Replies
  • July 30, 2014 at 12:26 pm in reply to: Error with 3 or more yDimensions.(pivot) #102115
    stapelchip
    Participant

    Hello Tony,

    do you have any news on this topic?

    Kind Regards

    June 27, 2014 at 9:46 am in reply to: Error with 3 or more yDimensions.(pivot) #92072
    stapelchip
    Participant

    Thank you :)

    June 18, 2014 at 3:36 pm in reply to: Error with 3 or more yDimensions.(pivot) #94242
    stapelchip
    Participant

    Hello Tony,

    thank you for your help!

    Do you mean this file from the demo site? 

    http://trirand.com/blog/jqgrid/js/jquery.jqGrid.js

    Thats strange because i get the same error with this file.

    But it breaks with more data (The data above was only a part of my testdata)

    Can you please test it with my full Response:

    {
    “summary”: {},
    “remainder”: {},
    “cells”: [
    {
    “pageviews_sum”: 233,
    “pageviews_avg”: 10.590909090909092,
    “date_visit.year”: 2012,
    “date_visit.month”: 1,
    “pageviews_max”: 18,
    “date_visit.quarter”: 1,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 208,
    “pageviews_avg”: 9.043478260869565,
    “date_visit.year”: 2012,
    “date_visit.month”: 2,
    “pageviews_max”: 19,
    “date_visit.quarter”: 1,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 206,
    “pageviews_avg”: 9.363636363636363,
    “date_visit.year”: 2012,
    “date_visit.month”: 3,
    “pageviews_max”: 28,
    “date_visit.quarter”: 1,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 178,
    “pageviews_avg”: 9.368421052631579,
    “date_visit.year”: 2012,
    “date_visit.month”: 4,
    “pageviews_max”: 20,
    “date_visit.quarter”: 2,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 118,
    “pageviews_avg”: 6.9411764705882355,
    “date_visit.year”: 2012,
    “date_visit.month”: 5,
    “pageviews_max”: 15,
    “date_visit.quarter”: 2,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 145,
    “pageviews_avg”: 7.25,
    “date_visit.year”: 2012,
    “date_visit.month”: 6,
    “pageviews_max”: 16,
    “date_visit.quarter”: 2,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 170,
    “pageviews_avg”: 8.947368421052632,
    “date_visit.year”: 2012,
    “date_visit.month”: 7,
    “pageviews_max”: 20,
    “date_visit.quarter”: 3,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 145,
    “pageviews_avg”: 8.529411764705882,
    “date_visit.year”: 2012,
    “date_visit.month”: 8,
    “pageviews_max”: 15,
    “date_visit.quarter”: 3,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 144,
    “pageviews_avg”: 6,
    “date_visit.year”: 2012,
    “date_visit.month”: 9,
    “pageviews_max”: 21,
    “date_visit.quarter”: 3,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 128,
    “pageviews_avg”: 7.111111111111111,
    “date_visit.year”: 2012,
    “date_visit.month”: 10,
    “pageviews_max”: 21,
    “date_visit.quarter”: 4,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 114,
    “pageviews_avg”: 6,
    “date_visit.year”: 2012,
    “date_visit.month”: 11,
    “pageviews_max”: 16,
    “date_visit.quarter”: 4,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 243,
    “pageviews_avg”: 9.346153846153847,
    “date_visit.year”: 2012,
    “date_visit.month”: 12,
    “pageviews_max”: 19,
    “date_visit.quarter”: 4,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 217,
    “pageviews_avg”: 7.75,
    “date_visit.year”: 2013,
    “date_visit.month”: 1,
    “pageviews_max”: 19,
    “date_visit.quarter”: 1,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 139,
    “pageviews_avg”: 8.6875,
    “date_visit.year”: 2013,
    “date_visit.month”: 2,
    “pageviews_max”: 20,
    “date_visit.quarter”: 1,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 166,
    “pageviews_avg”: 8.3,
    “date_visit.year”: 2013,
    “date_visit.month”: 3,
    “pageviews_max”: 20,
    “date_visit.quarter”: 1,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 204,
    “pageviews_avg”: 7.0344827586206895,
    “date_visit.year”: 2013,
    “date_visit.month”: 4,
    “pageviews_max”: 20,
    “date_visit.quarter”: 2,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 211,
    “pageviews_avg”: 7.535714285714286,
    “date_visit.year”: 2013,
    “date_visit.month”: 5,
    “pageviews_max”: 22,
    “date_visit.quarter”: 2,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 119,
    “pageviews_avg”: 7,
    “date_visit.year”: 2013,
    “date_visit.month”: 6,
    “pageviews_max”: 17,
    “date_visit.quarter”: 2,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 202,
    “pageviews_avg”: 8.08,
    “date_visit.year”: 2013,
    “date_visit.month”: 7,
    “pageviews_max”: 22,
    “date_visit.quarter”: 3,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 170,
    “pageviews_avg”: 8.5,
    “date_visit.year”: 2013,
    “date_visit.month”: 8,
    “pageviews_max”: 19,
    “date_visit.quarter”: 3,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 209,
    “pageviews_avg”: 8.708333333333334,
    “date_visit.year”: 2013,
    “date_visit.month”: 9,
    “pageviews_max”: 18,
    “date_visit.quarter”: 3,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 171,
    “pageviews_avg”: 7.125,
    “date_visit.year”: 2013,
    “date_visit.month”: 10,
    “pageviews_max”: 20,
    “date_visit.quarter”: 4,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 139,
    “pageviews_avg”: 6.95,
    “date_visit.year”: 2013,
    “date_visit.month”: 11,
    “pageviews_max”: 19,
    “date_visit.quarter”: 4,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 124,
    “pageviews_avg”: 8.266666666666667,
    “date_visit.year”: 2013,
    “date_visit.month”: 12,
    “pageviews_max”: 17,
    “date_visit.quarter”: 4,
    “browser”: “Chrome”
    },
    {
    “pageviews_sum”: 172,
    “pageviews_avg”: 9.555555555555555,
    “date_visit.year”: 2012,
    “date_visit.month”: 1,
    “pageviews_max”: 25,
    “date_visit.quarter”: 1,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 127,
    “pageviews_avg”: 7.9375,
    “date_visit.year”: 2012,
    “date_visit.month”: 2,
    “pageviews_max”: 21,
    “date_visit.quarter”: 1,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 123,
    “pageviews_avg”: 6.833333333333333,
    “date_visit.year”: 2012,
    “date_visit.month”: 3,
    “pageviews_max”: 19,
    “date_visit.quarter”: 1,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 136,
    “pageviews_avg”: 8.5,
    “date_visit.year”: 2012,
    “date_visit.month”: 4,
    “pageviews_max”: 16,
    “date_visit.quarter”: 2,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 71,
    “pageviews_avg”: 5.916666666666667,
    “date_visit.year”: 2012,
    “date_visit.month”: 5,
    “pageviews_max”: 14,
    “date_visit.quarter”: 2,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 150,
    “pageviews_avg”: 7.894736842105263,
    “date_visit.year”: 2012,
    “date_visit.month”: 6,
    “pageviews_max”: 22,
    “date_visit.quarter”: 2,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 135,
    “pageviews_avg”: 10.384615384615385,
    “date_visit.year”: 2012,
    “date_visit.month”: 7,
    “pageviews_max”: 22,
    “date_visit.quarter”: 3,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 112,
    “pageviews_avg”: 7,
    “date_visit.year”: 2012,
    “date_visit.month”: 8,
    “pageviews_max”: 11,
    “date_visit.quarter”: 3,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 195,
    “pageviews_avg”: 10.833333333333334,
    “date_visit.year”: 2012,
    “date_visit.month”: 9,
    “pageviews_max”: 18,
    “date_visit.quarter”: 3,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 162,
    “pageviews_avg”: 7.714285714285714,
    “date_visit.year”: 2012,
    “date_visit.month”: 10,
    “pageviews_max”: 15,
    “date_visit.quarter”: 4,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 137,
    “pageviews_avg”: 8.058823529411764,
    “date_visit.year”: 2012,
    “date_visit.month”: 11,
    “pageviews_max”: 18,
    “date_visit.quarter”: 4,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 119,
    “pageviews_avg”: 8.5,
    “date_visit.year”: 2012,
    “date_visit.month”: 12,
    “pageviews_max”: 20,
    “date_visit.quarter”: 4,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 157,
    “pageviews_avg”: 10.466666666666667,
    “date_visit.year”: 2013,
    “date_visit.month”: 1,
    “pageviews_max”: 27,
    “date_visit.quarter”: 1,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 166,
    “pageviews_avg”: 9.764705882352942,
    “date_visit.year”: 2013,
    “date_visit.month”: 2,
    “pageviews_max”: 18,
    “date_visit.quarter”: 1,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 172,
    “pageviews_avg”: 8.19047619047619,
    “date_visit.year”: 2013,
    “date_visit.month”: 3,
    “pageviews_max”: 21,
    “date_visit.quarter”: 1,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 180,
    “pageviews_avg”: 8.181818181818182,
    “date_visit.year”: 2013,
    “date_visit.month”: 4,
    “pageviews_max”: 19,
    “date_visit.quarter”: 2,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 162,
    “pageviews_avg”: 8.526315789473685,
    “date_visit.year”: 2013,
    “date_visit.month”: 5,
    “pageviews_max”: 17,
    “date_visit.quarter”: 2,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 141,
    “pageviews_avg”: 8.8125,
    “date_visit.year”: 2013,
    “date_visit.month”: 6,
    “pageviews_max”: 20,
    “date_visit.quarter”: 2,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 88,
    “pageviews_avg”: 9.777777777777779,
    “date_visit.year”: 2013,
    “date_visit.month”: 7,
    “pageviews_max”: 19,
    “date_visit.quarter”: 3,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 73,
    “pageviews_avg”: 6.636363636363637,
    “date_visit.year”: 2013,
    “date_visit.month”: 8,
    “pageviews_max”: 23,
    “date_visit.quarter”: 3,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 106,
    “pageviews_avg”: 9.636363636363637,
    “date_visit.year”: 2013,
    “date_visit.month”: 9,
    “pageviews_max”: 25,
    “date_visit.quarter”: 3,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 140,
    “pageviews_avg”: 7.777777777777778,
    “date_visit.year”: 2013,
    “date_visit.month”: 10,
    “pageviews_max”: 16,
    “date_visit.quarter”: 4,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 211,
    “pageviews_avg”: 8.791666666666666,
    “date_visit.year”: 2013,
    “date_visit.month”: 11,
    “pageviews_max”: 21,
    “date_visit.quarter”: 4,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 105,
    “pageviews_avg”: 7.5,
    “date_visit.year”: 2013,
    “date_visit.month”: 12,
    “pageviews_max”: 13,
    “date_visit.quarter”: 4,
    “browser”: “Firefox”
    },
    {
    “pageviews_sum”: 70,
    “pageviews_avg”: 8.75,
    “date_visit.year”: 2012,
    “date_visit.month”: 1,
    “pageviews_max”: 17,
    “date_visit.quarter”: 1,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 46,
    “pageviews_avg”: 11.5,
    “date_visit.year”: 2012,
    “date_visit.month”: 2,
    “pageviews_max”: 18,
    “date_visit.quarter”: 1,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 79,
    “pageviews_avg”: 9.875,
    “date_visit.year”: 2012,
    “date_visit.month”: 3,
    “pageviews_max”: 14,
    “date_visit.quarter”: 1,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 99,
    “pageviews_avg”: 7.615384615384615,
    “date_visit.year”: 2012,
    “date_visit.month”: 4,
    “pageviews_max”: 18,
    “date_visit.quarter”: 2,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 58,
    “pageviews_avg”: 8.285714285714286,
    “date_visit.year”: 2012,
    “date_visit.month”: 5,
    “pageviews_max”: 19,
    “date_visit.quarter”: 2,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 76,
    “pageviews_avg”: 7.6,
    “date_visit.year”: 2012,
    “date_visit.month”: 6,
    “pageviews_max”: 20,
    “date_visit.quarter”: 2,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 46,
    “pageviews_avg”: 11.5,
    “date_visit.year”: 2012,
    “date_visit.month”: 7,
    “pageviews_max”: 26,
    “date_visit.quarter”: 3,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 83,
    “pageviews_avg”: 8.3,
    “date_visit.year”: 2012,
    “date_visit.month”: 8,
    “pageviews_max”: 17,
    “date_visit.quarter”: 3,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 34,
    “pageviews_avg”: 6.8,
    “date_visit.year”: 2012,
    “date_visit.month”: 9,
    “pageviews_max”: 15,
    “date_visit.quarter”: 3,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 73,
    “pageviews_avg”: 8.11111111111111,
    “date_visit.year”: 2012,
    “date_visit.month”: 10,
    “pageviews_max”: 20,
    “date_visit.quarter”: 4,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 30,
    “pageviews_avg”: 6,
    “date_visit.year”: 2012,
    “date_visit.month”: 11,
    “pageviews_max”: 8,
    “date_visit.quarter”: 4,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 2,
    “pageviews_avg”: 2,
    “date_visit.year”: 2012,
    “date_visit.month”: 12,
    “pageviews_max”: 2,
    “date_visit.quarter”: 4,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 83,
    “pageviews_avg”: 6.916666666666667,
    “date_visit.year”: 2013,
    “date_visit.month”: 1,
    “pageviews_max”: 15,
    “date_visit.quarter”: 1,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 48,
    “pageviews_avg”: 12,
    “date_visit.year”: 2013,
    “date_visit.month”: 2,
    “pageviews_max”: 19,
    “date_visit.quarter”: 1,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 72,
    “pageviews_avg”: 8,
    “date_visit.year”: 2013,
    “date_visit.month”: 3,
    “pageviews_max”: 15,
    “date_visit.quarter”: 1,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 25,
    “pageviews_avg”: 6.25,
    “date_visit.year”: 2013,
    “date_visit.month”: 4,
    “pageviews_max”: 14,
    “date_visit.quarter”: 2,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 83,
    “pageviews_avg”: 11.857142857142858,
    “date_visit.year”: 2013,
    “date_visit.month”: 5,
    “pageviews_max”: 21,
    “date_visit.quarter”: 2,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 25,
    “pageviews_avg”: 5,
    “date_visit.year”: 2013,
    “date_visit.month”: 6,
    “pageviews_max”: 10,
    “date_visit.quarter”: 2,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 145,
    “pageviews_avg”: 8.529411764705882,
    “date_visit.year”: 2013,
    “date_visit.month”: 7,
    “pageviews_max”: 16,
    “date_visit.quarter”: 3,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 96,
    “pageviews_avg”: 10.666666666666666,
    “date_visit.year”: 2013,
    “date_visit.month”: 8,
    “pageviews_max”: 16,
    “date_visit.quarter”: 3,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 19,
    “pageviews_avg”: 3.8,
    “date_visit.year”: 2013,
    “date_visit.month”: 9,
    “pageviews_max”: 9,
    “date_visit.quarter”: 3,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 36,
    “pageviews_avg”: 7.2,
    “date_visit.year”: 2013,
    “date_visit.month”: 10,
    “pageviews_max”: 14,
    “date_visit.quarter”: 4,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 69,
    “pageviews_avg”: 8.625,
    “date_visit.year”: 2013,
    “date_visit.month”: 11,
    “pageviews_max”: 22,
    “date_visit.quarter”: 4,
    “browser”: “Lynx”
    },
    {
    “pageviews_sum”: 9,
    “pageviews_avg”: 4.5,
    “date_visit.year”: 2013,
    “date_visit.month”: 12,
    “pageviews_max”: 7,
    “date_visit.quarter”: 4,
    “browser”: “Lynx”
    }
    ],
    “aggregates”: [
    “pageviews_sum”,
    “pageviews_avg”,
    “pageviews_max”
    ],
    “cell”: [],
    “levels”: {
    “date_visit”: [
    “year”,
    “quarter”,
    “month”
    ],
    “browser”: [
    “browser”
    ]
    }
    }

     

    Thank you very much.

    June 16, 2014 at 10:05 am in reply to: Error with 3 or more yDimensions.(pivot) #94821
    stapelchip
    Participant

    Hello Tony,

    the following is a simple non working example:

     

    var grid = jQuery("#table").jqGrid('jqPivot', "data.json"+window.location.search, // pivot options { xDimension : [ { formatter: urlFmatter, formatoptions:{keyAttribute:'browser'}, dataName: 'browser', label: 'Browser', align: 'center' }, ], yDimension : [ {dataName: 'date_visit.year', label: 'Year'}, {dataName: 'date_visit.quarter', label: 'Quarter'}, {dataName: 'date_visit.month', label: 'Month'}, ], aggregates : [ {member: 'pageviews_sum', aggregator : 'sum', label:'Sum of pageviews', summaryType: 'sum'} ], rowTotals: false, colTotals : false }, // grid options { groupingView : { hideFirstGroupCol : true }, gridview: false, rowNum : 10, pager: "#pager", caption: 'Website / Visits' }, { reader : 'cells' } );
    With sample data:

    { "summary": {}, "remainder": {}, "cells": [ { "date_visit.quarter": 1, "date_visit.year": 2012, "date_visit.month": 1, "pageviews_sum": 233, "browser": "Chrome" }, { "date_visit.quarter": 1, "date_visit.year": 2012, "date_visit.month": 2, "pageviews_sum": 208, "browser": "Chrome" }, { "date_visit.quarter": 1, "date_visit.year": 2012, "date_visit.month": 3, "pageviews_sum": 206, "browser": "Chrome" }, { "date_visit.quarter": 2, "date_visit.year": 2012, "date_visit.month": 4, "pageviews_sum": 178, "browser": "Chrome" }, { "date_visit.quarter": 1, "date_visit.year": 2012, "date_visit.month": 1, "pageviews_sum": 172, "browser": "Firefox" }, { "date_visit.quarter": 1, "date_visit.year": 2012, "date_visit.month": 2, "pageviews_sum": 127, "browser": "Firefox" }, { "date_visit.quarter": 1, "date_visit.year": 2012, "date_visit.month": 3, "pageviews_sum": 123, "browser": "Firefox" }, { "date_visit.quarter": 2, "date_visit.year": 2012, "date_visit.month": 4, "pageviews_sum": 136, "browser": "Firefox" }, { "date_visit.quarter": 1, "date_visit.year": 2012, "date_visit.month": 1, "pageviews_sum": 70, "browser": "Lynx" }, { "date_visit.quarter": 1, "date_visit.year": 2012, "date_visit.month": 2, "pageviews_sum": 46, "browser": "Lynx" }, { "date_visit.quarter": 1, "date_visit.year": 2012, "date_visit.month": 3, "pageviews_sum": 79, "browser": "Lynx" }, { "date_visit.quarter": 2, "date_visit.year": 2012, "date_visit.month": 4, "pageviews_sum": 99, "browser": "Lynx" } ], "aggregates": [ "pageviews_sum" ], "cell": [ { "type": "set", "dimension": "date_visit", "hierarchy": "monthly", "level_depth": 3, "invert": false, "hidden": false, "paths": [ [ "2012", "1", "1" ], [ "2012", "1", "2" ], [ "2012", "1", "3" ], [ "2012", "2", "4" ] ] } ], "levels": { "date_visit": [ "year", "quarter", "month" ], "browser": [ "browser" ] }}
    With this code you will receive the error message:

    Uncaught TypeError: Cannot read property ‘name’ of undefined

    If you remove one month in the “cells” array, there is no error but the pageviews_sum values in the table are wrong.

    It would be very nice if you could run my example.

    June 13, 2014 at 1:03 pm in reply to: Error with 3 or more yDimensions.(pivot) #95354
    stapelchip
    Participant

    Hello tony,

    i want to try it with the latest GitHub Source but if i run the gradlew script the output file “jquery.jgGrid.js” is twice as big as my original file (26515 Lines). 

    And with this file i get errors even with a simple table.

    If you can tell me how to fix this i will test it again and if necessary i provide a test case.

    Thank you :)

    May 21, 2014 at 1:10 pm in reply to: Pivot: Wrong Column Grouping #102047
    stapelchip
    Participant

    If i use a yDimension with only two entries, the column grouping ist right but the first value is used twice.

    http://i62.tinypic.com/2hhoupd.png

    The second value should be Yes, as you can see in this screenshot ( i only changed the order of the dimensions):

    http://i62.tinypic.com/okvspg.png

    By the way, thank you for this great plugin 🙂

    Edit: I realised that this problem also exists in the example from the last post. You can see tha there are 3 source.source_label entries but only two are used. (Directlink and Websearch, unknown is missing)

    May 21, 2014 at 12:58 pm in reply to: Pivot: Wrong Column Grouping #102046
    stapelchip
    Participant

    Yes of course.

    jQuery(document).ready(function(){
    var grid = jQuery(“#grid”).jqGrid(‘jqPivot’,
    “data.json”,

    {

    xDimension : [
    {
    dataName: ‘date_visit.year’,
    align: ‘center’
    },
    ],
    yDimension : [
    {dataName: ‘source.source_label’},
    {dataName: ‘browser’},

    ],
    aggregates : [

    {member: ‘pageviews_sum’, aggregator : ‘sum’, width:50, label:’Sum of pageviews’, summaryType: ‘sum’},

    {member: ‘pageviews_avg’, aggregator : ‘sum’, width:50, label:’Average of pageviews’, summaryType: ‘sum’},

    ],
    rowTotals: false,
    colTotals : false

    },
    // grid options
    {
    groupingView : {
    hideFirstGroupCol : true
    },
    gridview: false,
    loadtext: ‘Bitte warten’,
    loadui: ‘block’,
    shrinkToFit:false,
    rowNum : 10,
    pager: “#pager”,
    caption: ‘webvisits’

    },
    { reader : ‘cells’ }

    );

    });

    {
    “summary”: {},
    “remainder”: {},
    “cells”: [
    {
    “source.source_label”: “Direct link”,
    “pageviews_sum”: 116010,
    “pageviews_avg”: 20,
    “date_visit.year”: 2012,
    “source.source_id”: “Direct_link”,
    “browser”: “Chrome”
    },
    {
    “source.source_label”: “Direct link”,
    “pageviews_sum”: 117321,
    “pageviews_avg”: 20,
    “date_visit.year”: 2012,
    “source.source_id”: “Direct_link”,
    “browser”: “Firefox”
    },
    {
    “source.source_label”: “Direct link”,
    “pageviews_sum”: 119346,
    “pageviews_avg”: 20,
    “date_visit.year”: 2012,
    “source.source_id”: “Direct_link”,
    “browser”: “Lynx”
    },
    {
    “source.source_label”: “Unknown”,
    “pageviews_sum”: 115723,
    “pageviews_avg”: 20,
    “date_visit.year”: 2012,
    “source.source_id”: “Unknown”,
    “browser”: “Chrome”
    },
    {
    “source.source_label”: “Unknown”,
    “pageviews_sum”: 112487,
    “pageviews_avg”: 20,
    “date_visit.year”: 2012,
    “source.source_id”: “Unknown”,
    “browser”: “Firefox”
    },
    {
    “source.source_label”: “Unknown”,
    “pageviews_sum”: 112685,
    “pageviews_avg”: 20,
    “date_visit.year”: 2012,
    “source.source_id”: “Unknown”,
    “browser”: “Lynx”
    },
    {
    “source.source_label”: “Web search”,
    “pageviews_sum”: 114041,
    “pageviews_avg”: 20,
    “date_visit.year”: 2012,
    “source.source_id”: “Web_search”,
    “browser”: “Chrome”
    },
    {
    “source.source_label”: “Web search”,
    “pageviews_sum”: 112181,
    “pageviews_avg”: 20,
    “date_visit.year”: 2012,
    “source.source_id”: “Web_search”,
    “browser”: “Firefox”
    },
    {
    “source.source_label”: “Web search”,
    “pageviews_sum”: 117329,
    “pageviews_avg”: 20,
    “date_visit.year”: 2012,
    “source.source_id”: “Web_search”,
    “browser”: “Lynx”
    },
    {
    “source.source_label”: “Direct link”,
    “pageviews_sum”: 113345,
    “pageviews_avg”: 20,
    “date_visit.year”: 2013,
    “source.source_id”: “Direct_link”,
    “browser”: “Chrome”
    },
    {
    “source.source_label”: “Direct link”,
    “pageviews_sum”: 111848,
    “pageviews_avg”: 20,
    “date_visit.year”: 2013,
    “source.source_id”: “Direct_link”,
    “browser”: “Firefox”
    },
    {
    “source.source_label”: “Direct link”,
    “pageviews_sum”: 111196,
    “pageviews_avg”: 20,
    “date_visit.year”: 2013,
    “source.source_id”: “Direct_link”,
    “browser”: “Lynx”
    },
    {
    “source.source_label”: “Unknown”,
    “pageviews_sum”: 112940,
    “pageviews_avg”: 20,
    “date_visit.year”: 2013,
    “source.source_id”: “Unknown”,
    “browser”: “Chrome”
    },
    {
    “source.source_label”: “Unknown”,
    “pageviews_sum”: 114079,
    “pageviews_avg”: 20,
    “date_visit.year”: 2013,
    “source.source_id”: “Unknown”,
    “browser”: “Firefox”
    },
    {
    “source.source_label”: “Unknown”,
    “pageviews_sum”: 113435,
    “pageviews_avg”: 20,
    “date_visit.year”: 2013,
    “source.source_id”: “Unknown”,
    “browser”: “Lynx”
    },
    {
    “source.source_label”: “Web search”,
    “pageviews_sum”: 114373,
    “pageviews_avg”: 20,
    “date_visit.year”: 2013,
    “source.source_id”: “Web_search”,
    “browser”: “Chrome”
    },
    {
    “source.source_label”: “Web search”,
    “pageviews_sum”: 111530,
    “pageviews_avg”: 20,
    “date_visit.year”: 2013,
    “source.source_id”: “Web_search”,
    “browser”: “Firefox”
    },
    {
    “source.source_label”: “Web search”,
    “pageviews_sum”: 114705,
    “pageviews_avg”: 20,
    “date_visit.year”: 2013,
    “source.source_id”: “Web_search”,
    “browser”: “Lynx”
    }
    ],
    “aggregates”: [
    “pageviews_sum”,
    “pageviews_avg”
    ],
    “cell”: [],
    “levels”: {
    “source”: [
    “source”
    ],
    “date_visit”: [
    “year”
    ],
    “browser”: [
    “browser”
    ]
    }
    }

    I noticed some other problems with the ydimension. I attach some Screenshots later.

    May 8, 2014 at 3:58 pm in reply to: Grouping Summary Total Ends Up In Wrong Column #102012
    stapelchip
    Participant

    I think i have a similar issue.

    It happens only if the first column is hidden, like in your example.

    May 5, 2014 at 4:16 pm in reply to: Pivot: formatter for the grouping dimension not fired #102002
    stapelchip
    Participant

    I tried to make a workaround for this problem by sorting my json response serverside.

    Than i found out that “hidden:true” works only for the very last dimension.

    Do you have any suggestions to solve my problem?

    Edit: There is an option “isGroupField”. With this option enabled i can hide other dimension 🙂

    May 5, 2014 at 2:58 pm in reply to: Pivot: formatter for the grouping dimension not fired #102001
    stapelchip
    Participant

    Thank you very much, the fix is working for me.

    May 2, 2014 at 12:04 pm in reply to: Pivot: formatter for the grouping dimension not fired #101984
    stapelchip
    Participant

    Same problem for the hidden attribute.

    April 24, 2014 at 3:30 pm in reply to: jgPivot jsonReader #101976
    stapelchip
    Participant

    Thank you this works.

  • Author
    Replies
Viewing 12 replies - 1 through 12 (of 12 total)

Stay connected with us in your favorite flavor!

Copyright 2014 TriRand LtdAll Rights ReservedRSS

Back to Top