AnsweredAssumed Answered

Bar chart readers

Question asked by Andy Rathbone on Oct 9, 2018
Latest reply on Oct 10, 2018 by Andy Rathbone

Hi,

 

I'm creating a bar line chart with a data set that has 5 columns and around 30 rows.

LocationSalesRejectsMarketSite
London246151001A
Brighton12351002A

 

The last two columns are ID's and do not need to show on the chart or in the tool-tip.  But I will need to access them as part of the click action.  I have done something similar before, but I can't get this to work.

 

I have tried the below in pre execution but this is not working.

 

function a(){
    var d = this.chartDefinition;
    
    d.crosstabMode = false;
    d.seriesInRows = false,
    
    d.readers = [
        {names: 'category', indexes: 0},
        {names: 'value', indexes: 1},
        {names: 'value2', indexes: 2},
        
        {names: 'ma', indexes: 3},
        {names: 'site', indexes: 4}
        ];
    
    d.plot2 = true; 
}

 

Could someone please let me know what I am doing wrong and what I need to do to get the result I am after.

 

Thank you

Andy

Outcomes