Hello! In the latest version(2.8.10) API method refresh() does not apply date pattern option, but it worked a few releases ago. As you can see at the example, under drill-through date pattern does not change after clicking on the ‘Set options’ button. Thank you in advance.
Thank you for writing to us.
Please note that the
datePattern option only affects the date pattern in hierarchy members on the initial pivot table rendering. This is different for date fields in measures – the
setOptions() API call with a new
datePattern value successfully updates the pattern of date measures every time it is called. This behavioral difference of the
datePattern option for measures vs rows/columns is caused by particular technical specificities of the pivot table.
That being said, in case it is really important for you to change the date pattern in rows/columns members, the
customizeCell() API call can be used to modify the cell label – feel free to check out the quick example we’ve prepared.
Please let us know if this helps.