# Reporting Issues **URL:** \ **Category:** Ignition\ **Tags:** ignition81, reporting\ **Created:** [October 5, 2023, 3:12pm UTC](https://forum.inductiveautomation.com/t/reporting-issues/80081 "2023-10-05T15:12:26Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Thomas\_Magill](https://avatars.discourse-cdn.com/v4/letter/t/65b543/32.png) [@Thomas\_Magill](https://forum.inductiveautomation.com/u/Thomas_Magill)\ **Post date:** [October 5, 2023, 3:12pm UTC](https://forum.inductiveautomation.com/t/reporting-issues/80081/1 "2023-10-05T15:12:26Z")
Two issues: -For some reason I cannot perform math on the Details column of this report. It works for the total.value, but just keeps giving me N/A otherwise. ![ReportingMathIssue](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/0/101627a7d342a4017ef0f2ec734736891d3ef588.png) -How do I format the timestamp on x axis of bar graph? I somehow did this before, redid the data source on a graph so had to redo everything, and can't figure out how to get the date into a MM-dd format. ![ReportingRowDateFormat](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/0/80ccf399ede7f499b702a721ebe36aed3df2ea46.png) Many thanks! ---
**Author:** ![Thomas\_Magill](https://avatars.discourse-cdn.com/v4/letter/t/65b543/32.png) [@Thomas\_Magill](https://forum.inductiveautomation.com/u/Thomas_Magill)\ **Post date:** [October 12, 2023, 6:56pm UTC](https://forum.inductiveautomation.com/t/reporting-issues/80081/2 "2023-10-12T18:56:12Z")
bump ---
**Author:** ![schenk](https://avatars.discourse-cdn.com/v4/letter/s/6bbea6/32.png) [@schenk](https://forum.inductiveautomation.com/u/schenk)\ **Post date:** [October 12, 2023, 10:44pm UTC](https://forum.inductiveautomation.com/t/reporting-issues/80081/3 "2023-10-12T22:44:36Z")
Can you provide a copy of the report with a static csv source that matches the format of the expected dataset? ---
**Author:** ![Thomas\_Magill](https://avatars.discourse-cdn.com/v4/letter/t/65b543/32.png) [@Thomas\_Magill](https://forum.inductiveautomation.com/u/Thomas_Magill)\ **Post date:** [October 13, 2023, 5:20pm UTC](https://forum.inductiveautomation.com/t/reporting-issues/80081/4 "2023-10-13T17:20:47Z")
[reportToCSV.csv](https://forum.inductiveautomation.com/uploads/short-url/nGcT8FTOGcMOPLCAX8aHJblg7Ps.csv) (1.4 KB) [Untitled-1.xml](https://forum.inductiveautomation.com/uploads/short-url/lju3GNN2GgoGlmcXkVM7KRt6Vuc.xml) (18.0 KB) full xml from report attached, plus my attempt at converting to csv. I couldn't get the online coverters to work with the copy from the report data pane, so it's just the section thats giving me trouble. ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [October 13, 2023, 5:24pm UTC](https://forum.inductiveautomation.com/t/reporting-issues/80081/5 "2023-10-13T17:24:01Z")
Does `@processed@` work (without the division)? Tip: the syntax for bulleted list is `- listItem` with a space. ---
**Author:** ![Thomas\_Magill](https://avatars.discourse-cdn.com/v4/letter/t/65b543/32.png) [@Thomas\_Magill](https://forum.inductiveautomation.com/u/Thomas_Magill)\ **Post date:** [October 13, 2023, 5:28pm UTC](https://forum.inductiveautomation.com/t/reporting-issues/80081/6 "2023-10-13T17:28:35Z")
yes, @processed@ works, as well as @total.processed@ and @total.processed/16@ ---
**Author:** ![schenk](https://avatars.discourse-cdn.com/v4/letter/s/6bbea6/32.png) [@schenk](https://forum.inductiveautomation.com/u/schenk)\ **Post date:** [October 13, 2023, 6:22pm UTC](https://forum.inductiveautomation.com/t/reporting-issues/80081/7 "2023-10-13T18:22:55Z")
Can you right-click the report in the project browser and export as a `.zip`? ---
**Author:** ![Thomas\_Magill](https://avatars.discourse-cdn.com/v4/letter/t/65b543/32.png) [@Thomas\_Magill](https://forum.inductiveautomation.com/u/Thomas_Magill)\ **Post date:** [October 13, 2023, 6:47pm UTC](https://forum.inductiveautomation.com/t/reporting-issues/80081/8 "2023-10-13T18:47:05Z")
[SystemMetrics\_2023-10-13\_1446.zip](https://forum.inductiveautomation.com/uploads/short-url/ha3f0VV06Mjd0u3UjvkLljbGogk.zip) (44.9 KB) attached ---
**Author:** ![schenk](https://avatars.discourse-cdn.com/v4/letter/s/6bbea6/32.png) [@schenk](https://forum.inductiveautomation.com/u/schenk)\ **Post date:** [October 13, 2023, 7:25pm UTC](https://forum.inductiveautomation.com/t/reporting-issues/80081/9 "2023-10-13T19:25:29Z")
I put in a static csv data source using this data and set it as the data key on the table ```auto t_stamp, processed "2023-10-12 16:09:04.016",77 "2023-10-12 17:09:04.016",83 "2023-10-12 18:09:04.016",36 "2023-10-12 19:09:04.016",83 "2023-10-12 20:09:04.016",48 "2023-10-12 21:09:04.016",54 "2023-10-12 22:09:04.016",85 "2023-10-12 23:09:04.016",35 "2023-10-13 01:09:04.016",75 "2023-10-13 02:09:04.016",62 ``` Without changing anything in the report, it works as expected... ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/8/284a7fa9463387d4b2e38026738125334f401034.png) Try testing this on yours. If the static data works, maybe compare the xml in the preview between it and the data from your DB? ---
**Author:** ![Thomas\_Magill](https://avatars.discourse-cdn.com/v4/letter/t/65b543/32.png) [@Thomas\_Magill](https://forum.inductiveautomation.com/u/Thomas_Magill)\ **Post date:** [October 15, 2023, 5:09pm UTC](https://forum.inductiveautomation.com/t/reporting-issues/80081/10 "2023-10-15T17:09:07Z")
It doesn’t surprise me that it works for you. I had it working before and the total works. I’m assuming it’s something super simple I’m missing but after messing around with it for a couple hours, had to seek assistance ---
**Author:** ![Thomas\_Magill](https://avatars.discourse-cdn.com/v4/letter/t/65b543/32.png) [@Thomas\_Magill](https://forum.inductiveautomation.com/u/Thomas_Magill)\ **Post date:** [November 1, 2023, 3:13pm UTC](https://forum.inductiveautomation.com/t/reporting-issues/80081/11 "2023-11-01T15:13:20Z")
There's some sort of issue/bug/config error on my side where it's treating the count as a string(doesnt do this for the total). I verified this by scripting the data into a dataset. Was forced to convert to float before I could perform math on it.