Use Date Inside Pivot Value Cell
Question:
How can I use the date in the Pivot values?
Answer:
You can follow these steps:
1. Convert the date into an Integer with this chunk of SQL:
GETYEAR([Date])*10000
+GETMONTH([Date])*100
+GETDAY([Date])
2. After you have an Integer representation of a date in the cell use some Jquery to format it the way you want. Using this in the "Edit Script" section:
widget.on('ready', function(){
$("div.table-grid__tbody div.table-grid__content__inner").map(function(i, cell) {
var input = cell.innerHTML.replace(/(\d\d\d\d)(\d\d)(\d\d)/, "$2/$3/$1");
// console.log('input');
// console.log(input);
cell.innerHTML = input;
});
});
Published 10-14-2021
