Issue with formatter function in Viz chart's flattened dataset

[swaroop_anasane]

Dear All,

Following is my JSON data:

var oData1 =  {TechKPI:[{date:new Date("2014-02-01T09:28:56"),a:87.3, b:33.3, c:81.1, d:12.2, e:5.2,f:15.9},

  {date:new Date("2014-02-02T09:28:56"),a:87.4, b:34, c:81.1, d:11.5, e:1,f:16.3},

  {date:new Date("2014-02-07T09:28:56"),a:87.8, b:33.1, c:81.5, d:13.7, e:8.7,f:15.7},

  {date:new Date("2014-02-15T09:28:56"),a:87.1, b:33.1, c:81.4, d:13.2, e:8.1,f:15.2},

  {date:new Date("2014-02-28T09:28:56"),a:87.1, b:33.5, c:81.1, d:13.2, e:8.1,f:16.4},

  {date:new Date("2014-03-01T09:28:56.321"),a:87.4, b:34, c:81.1, d:11.5, e:1,f:16.3}]};

Flattened dataset as follows:

var oDataset = new sap.viz.ui5.data.FlattenedDataset({

  // a Bar Chart requires exactly one dimension (x-axis)

  dimensions:[

  {

  axis:1,

  name: "Value",

  value: {

  path : 'a' , 

                        formatter : function(fval) { 

                          return fval.toString();

                        }

  } 

  }

  ],

  // it can show multiple measures, each results in a new set of bars in a new color

  measures : [

     // measure 1

  {

  name : 'B', // 'name' is used as label in the Legend

  value : '{B}' // 'value' defines the binding for the displayed value  

  }

  ],

  // 'data' is used to bind the whole data collection that is to be displayed in the chart

  data : {

  path : "/TechKPI"

  }

Here, in the formatter function, I am getting a null value for fval.

Any help would be appreciated to understand what's going wrong here.

Thanks in advance.

Warm Regards,

Swaroop

[swaroop_anasane · Accepted solution]

Dear All,

Have got the answer for this one. Please follow my blog for the same:

Thanks,

Swaroop