Exported data in .csv from Jira Service Desk does not match the data shown on the page

[Cydrick Quijano]

For some reason, the data shown on the Jira Service Desk page for my my project does not match the exported .csv data. What could be causing this and what are the work arounds.

[Prince Nyeche]

Hi @Cydrick Quijano 

Welcome to Community! 13 Dec has 0 value, could that be the missing data? it would be better if you could do a side by side comparison (Actual vs exported data) as the time period is shortly. so you can determine where the missing data is coming from?

Another aspect could be that your spreadsheet program is altering the data upon pasting (rounding up number values or omitting decimal points), if that's what you did to copy the data.

[Cydrick Quijano]

Thank you. However, even if I omit the Dec 13 data, the figures would still not match. The data is also not being rounded up when exported.

[Prince Nyeche]

Hey @Cydrick Quijano 

Can you use  a plan csv text reader like atom.io with the export and see if you can get the same result? I believe the data is being changed when viewed with your current spreadsheet editor probably due to character encoding or something else.