Calculated Column

shannonwrege

Can you define a column which is calculated by other columns and not actually in the data set? For example, if you have a column that lists Wins (e.g. "12") and a column that lists Losses (e.g. "4"), can you have a calculated column to show in a responsive table that drops the Wins and Losses column and adds a calculated Record column (e.g. "12-4")?

jr42.gordon

Absolutely. There are a number of ways you can handle this.

First, how are you adding data to the table? Array of string? object? Already defined HTML table?

The answer to this question will help me provide you with the correct answer.

shannonwrege

The data is packed in an array. The actual field values are integers, but they could be strings if it makes a difference.

jr42.gordon

So assuming your data is array of objects, I would define columns as following

{
   "responsivePriority": 2,
   "data": 'wins'
},
{
   "responsivePriority": 2,
   "data": 'losses'
},
{
   "responsivePriority": 1,
   "data": null,    // this will allow usage of full object
   "render": function ( data, type, full, meta ) {
      return (data.wins + '-' data.losses);
    }
}

If you don't want to show this combined column all the time, or only on specific resolutions, then utilize responsive classes.

Also, you will probably need a custom sort function for this combined column.

shannonwrege

That did it. Thanks!