Multi Dimension Extension not working

dionverbeke — Sun, 10 Jan 2016 23:56:41 GMT

Hi,

I'm trying to create an extension that will work with more than one dimension and one measure.

Somehow I always get a qNum error in the console. Any idea why I can't "see"

return d[2].qNum?

=========

define( ["jquery","./d3"], function ( $ ) {

'use strict';

return {

initialProperties: {

qHyperCubeDef: {

qDimensions: [],

qMeasures: [],

qInitialDataFetch: [{

qWidth: 10,

qHeight: 50

}]

}

definition: {

type: "items",

component: "accordion",

items: {

dimensions: {

uses: "dimensions",

min: 1,

max: 2

measures: {

uses: "measures",

min: 1,

max: 1

sorting: {

uses: "sorting"

settings : {

uses : "settings",

items : {

Line:{

ref: "strokeStyle",

component: "dropdown",

type: "boolean",

label: "Stroke type",

defaultValue: true,

options: [{

value: true,

label: "Smooth"

}, {

value: false,

label: "Straight"

}],

show: true

Legend:{

ref: "showLegend",

component: "switch",

type: "boolean",

translation: "Legend",

defaultValue: true,

trueOption: {

value: true,

translation: "properties.on"

falseOption: {

value: false,

translation: "properties.off"

show: true

Color:{

type: "items",

label: "Colors",

items : {

colorPalette: {

ref: "colorPalette",

component: "dropdown",

type: "string",

label: "Color palette",

defaultValue: "QLIK",

options: [{

value: "QLIK",

label: "Qlik"

}, {

value: "CUSTOM",

label: "Custom color"

}, {

value: "FORMULA",

label: "Formula color"

}],

show: true

customPalette: {

ref: "customPalette",

type: "string",

label: "Custom color palette",

defaultValue: "#EDC951, #CC333F, #00A0B0",

expression: "",

show: function(layout) { return layout.colorPalette == "CUSTOM" }

formulaPalette: {

ref: "formulaPalette",

type: "string",

label: "Formula color palette",

defaultValue: "= Concat(Distinct Color, ', ')",

expression: "always",

show: function(layout) { return layout.colorPalette == "FORMULA" }

colorLinear:{

ref: "colorLinear",

component: "switch",

type: "boolean",

translation: "Linear scale",

defaultValue: false,

trueOption: {

value: true,

translation: "properties.on"

falseOption: {

value: false,

translation: "properties.off"

show: function(layout) { return layout.colorPalette == "CUSTOM" }

colorPersistence:{

ref: "colorPersistence",

component: "switch",

type: "boolean",

translation: "Persistence",

defaultValue: false,

trueOption: {

value: true,

translation: "properties.on"

falseOption: {

value: false,

translation: "properties.off"

show: true

}

snapshot: {

canTakeSnapshot: true

paint: function ( $element, layout ) {

var options = {

size: {width: $element.width(), height: $element.height()}, //Width and Height of the circle

margin: {top: 50, right: 50, bottom: 50, left: 50} //The margins around the circle

};

//////////////////////////////////////////////////////////////

////////////////////////// Data //////////////////////////////

//////////////////////////////////////////////////////////////

var json = convertHYPERCUBEtoJSON(layout);

console.log(json);

}

function convertHYPERCUBEtoJSON(layout) {

// get qMatrix data array

var qMatrix = layout.qHyperCube.qDataPages[0].qMatrix;

// create a new array that contains the measure labels

var dimensions = layout.qHyperCube.qDimensionInfo;

var LegendTitle = dimensions[0].qFallbackTitle;

// create a new array that contains the dimensions and metric values

// depending on whether if 1 or 2 dimensions are being used

if(dimensions.length==2){

var dim1Labels = qMatrix.map(function(d) {

return d[0].qText;

});

var dim1Id = qMatrix.map(function(d) {

return d[0].qElemNumber;

});

var dim2Labels = qMatrix.map(function(d) {

return d[1].qText;

});

var dim2Id = qMatrix.map(function(d) {

return d[1].qElemNumber;

});

var metric1Values = qMatrix.map(function(d) {

return d[2].qNum;

}) ;

}

else{

var dim1Labels = qMatrix.map(function(d) {

return d[0].qText;

});

var dim1Id = qMatrix.map(function(d) {

return d[0].qElemNumber;

});

var dim2Labels = dim1Labels;

var dim2Id = dim1Id;

var metric1Values = qMatrix.map(function(d) {

return d[1].qNum;

});

}

// create a JSON array that contains dimensions and metric values

var data = [];

var actClassName = "";

var myJson = {};

myJson.dim_id = "";

myJson.dim = "";

myJson.definition = [];

var cont = 0;

var contdata = 0;

var LegendValues = [];

if(dimensions.length==2){

for(var k=0;k<dim1Labels.length;k++){

if(actClassName!=dim1Labels ){

if(cont!=0){

data[contdata] = myJson;

contdata++;

}

// it is a different grouping value of Dim1

LegendValues.push(dim1Labels);

var myJson = {};

myJson.dim_id = "";

myJson.dim = "";

myJson.definition = [];

cont = 0;

myJson.dim_id = dim1Id;

myJson.dim = dim1Labels;

// Make sure radar_area is added for usage in the radar chart layers later

myJson.definition[cont] = {"axis_id" : dim2Id, "axis" : dim2Labels, "radar_area_id" : dim1Id, "radar_area" : dim1Labels, "value" : metric1Values};

cont++;

// Make sure radar_area is added for usage in the radar chart layers later

}else{

myJson.definition[cont] = {"axis_id" : dim2Id, "axis" : dim2Labels, "radar_area_id" : dim1Id, "radar_area" : dim1Labels, "value" : metric1Values};

cont++;

}

actClassName = dim1Labels;

}

data[contdata] = myJson;

}else{

for(var k=0;k<dim1Labels.length;k++){

// it is a different grouping value of Dim1

LegendValues.push(dim1Labels);

// Make sure radar_area is added for usage in the radar chart layers later

myJson.definition[cont] = {"axis_id" : dim2Id, "axis" : dim2Labels, "radar_area_id" : dim1Id, "radar_area" : dim1Labels, "value" : metric1Values};

cont++;

}

data[contdata] = myJson;

}

return data;

}

});

Re: Multi Dimension Extension not working

prabhuappu — Sat, 16 Jan 2016 15:01:11 GMT

Hi,

Try to print the result in console before accessing it. like below code and check whether qNum is present in that object.

console.log(d[2]);

Also you can locate the error line from the console error. This would help to debug the code.

Regards,

Prabhu Appu

topic Multi Dimension Extension not working in Integration, Extension & APIs

Multi Dimension Extension not working

Re: Multi Dimension Extension not working