PIvot Date Format for null/blank values


#1

how to handle blank or null values inside pivot for fields as date type

i have in my dataset some rows with fields as date type but this fields also can be empty…and for that situation i always got some error and pivot doesnt’ render .

i think i need put some value for blank or null but what?


#2

The error with the blank values in date field is confirmed. we’ll fix it in the future updates.
For now you may try place any non-empty value in that fields. it will prevent the error and the pivot will render, while you will have “undefined” in the filter for that fields.