Add number formatting to the pivot table visualization

Table visualizations have super flexible value formatting options. Can we add the same number / date formatting options to the pivot table? Right now all numbers are rounded to two places and there’s no control over date / time formatting.

Excuse me, the date in the PivotTable cannot be formatted, how to solve it?

Correct. The point of this feature request is to add it.

For now you can only format the values in your SQL query. The exact steps depend on your database.

‘date_format(a1.dd,‘%Y-%m-%d’)’ ，It doesn’t work.

Because the JS library auto formats the dates. If you append a white space to the dates then you can avoid it.

Unfortunately, I don’t have the ability to modify the JS library yet.

You don’t need to modify the JS library to make this work. Just append literally any character that will break the automatic date parse.

Thank you very much. I’ll give it a try. I’m still a novice. :做鬼脸:

This problem has been solved. Thank you again.

Awesome! It’s not perfect but it works for now.