Dates in pivot table

Stimulsoft Dashboards.JS discussion
Post Reply
kevdflan
Posts: 12
Joined: Tue Feb 09, 2021 5:04 pm

Dates in pivot table

Post by kevdflan »

Good afternoon,

Is there a way to show the full date in a pivot table, I have tried formatting the date but I can only get it to show the year when I need it to show dd.mm.yyyy?
Attachments
chrome_bgnvUm9rI4.png
chrome_bgnvUm9rI4.png (38.48 KiB) Viewed 1378 times
chrome_jB8cIMMi00.png
chrome_jB8cIMMi00.png (11.17 KiB) Viewed 1378 times
Max Shamanov
Posts: 759
Joined: Tue Sep 07, 2021 10:11 am

Re: Dates in pivot table

Post by Max Shamanov »

Hello,

Please send us a sample report with test data that reproduces issues for analysis.

Thank you.
kevdflan
Posts: 12
Joined: Tue Feb 09, 2021 5:04 pm

Re: Dates in pivot table

Post by kevdflan »

Hello,

Here is the mrt file.
Attachments
Training Matrix.mrt
(25.34 KiB) Downloaded 123 times
Max Shamanov
Posts: 759
Joined: Tue Sep 07, 2021 10:11 am

Re: Dates in pivot table

Post by Max Shamanov »

Hello,

Please send us test data for your report.

Thank you.
kevdflan
Posts: 12
Joined: Tue Feb 09, 2021 5:04 pm

Re: Dates in pivot table

Post by kevdflan »

Good morning,

I sent the mrt file on Friday, is this not what you need?
Max Shamanov
Posts: 759
Joined: Tue Sep 07, 2021 10:11 am

Re: Dates in pivot table

Post by Max Shamanov »

Hello,

In your report template, data is registered as Dataset. It is not saved in the report template. Send us, file with test data(XML, JSON, Excel and etc) or embed all data to resources

Thank you.
Attachments
Designer_kHthQbGCxX.png
Designer_kHthQbGCxX.png (46.16 KiB) Viewed 1281 times
kevdflan
Posts: 12
Joined: Tue Feb 09, 2021 5:04 pm

Re: Dates in pivot table

Post by kevdflan »

Good morning,

Here is the CSV files that you have requested.
Attachments
Demox-Employee_Summary.csv
(7.56 KiB) Downloaded 117 times
Demox-Home_Summary.csv
(1.14 KiB) Downloaded 120 times
Demox-Employee_Qualification.csv
(817.93 KiB) Downloaded 121 times
Max Shamanov
Posts: 759
Joined: Tue Sep 07, 2021 10:11 am

Re: Dates in pivot table

Post by Max Shamanov »

Hello,

Sorry, it is impossible to use DateTime values in the summary of the Pivot Table.

Thank you.
Post Reply