asked on July 1, 2020
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.
⋅ July 2, 2020
Hi Sergii,
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.
Regards,
Mykhailo
