# Displaying Minutes in Reporting instead of seconds

**URL:** <https://forum.inductiveautomation.com/t/displaying-minutes-in-reporting-instead-of-seconds/41369>\
**Category:** Ignition\
**Created:** [December 10, 2020, 12:52am UTC](https://forum.inductiveautomation.com/t/displaying-minutes-in-reporting-instead-of-seconds/41369 "2020-12-10T00:52:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![nicholas.robinson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nicholas.robinson/32/22188_2.png) [@nicholas.robinson](https://forum.inductiveautomation.com/u/nicholas.robinson)\
**Post date:** [December 10, 2020, 12:52am UTC](https://forum.inductiveautomation.com/t/displaying-minutes-in-reporting-instead-of-seconds/41369/1 "2020-12-10T00:52:53Z")

</div>

In the reporting module I’m using a tag history query with value duration on in seconds to populate a bar chart.

I want to show the values in minutes, not seconds.

What is the simplest way to accomplish this?

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/9/b9358457a09aede0f9252b92d3495e2201043260.png)

Thanks,

Nick

---

<div class="post-metadata">

**Author:** ![michael2](https://avatars.discourse-cdn.com/v4/letter/m/3e96dc/32.png) [@michael2](https://forum.inductiveautomation.com/u/michael2)\
**Post date:** [December 10, 2020, 1:17am UTC](https://forum.inductiveautomation.com/t/displaying-minutes-in-reporting-instead-of-seconds/41369/2 "2020-12-10T01:17:49Z")

</div>

[https://docs.inductiveautomation.com/display/DOC81/Keychain+Expressions](https://docs.inductiveautomation.com/display/DOC81/Keychain+Expressions)  
This should have what you’re looking for.

---

<div class="post-metadata">

**Author:** ![nicholas.robinson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nicholas.robinson/32/22188_2.png) [@nicholas.robinson](https://forum.inductiveautomation.com/u/nicholas.robinson)\
**Post date:** [December 10, 2020, 1:50am UTC](https://forum.inductiveautomation.com/t/displaying-minutes-in-reporting-instead-of-seconds/41369/3 "2020-12-10T01:50:20Z")

</div>

That was actually useful for something else, but it seems like its not applicable to the bar chart since its key is not specified using @DataKey@

I’m still looking for a solution.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/4/240df561a5bbb05641fb20d3de217231589c9191.png)

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/4/94180fc99c564010ab4d0397402313d7a02cf378.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/4/04f6d64f00e1747856fad178db790473a2be3e60.png)

---

<div class="post-metadata">

**Author:** ![zacht](https://avatars.discourse-cdn.com/v4/letter/z/ea5d25/32.png) [@zacht](https://forum.inductiveautomation.com/u/zacht)\
**Post date:** [December 10, 2020, 3:21pm UTC](https://forum.inductiveautomation.com/t/displaying-minutes-in-reporting-instead-of-seconds/41369/4 "2020-12-10T15:21:20Z")

</div>

I would look into [script data sources](http://forum.inductiveautomation.com/search?q=report%20script%20data%20source).

[User manual documentation](https://docs.inductiveautomation.com/display/DOC81/Scripting+Data+Source)

---

<div class="post-metadata">

**Author:** ![nicholas.robinson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nicholas.robinson/32/22188_2.png) [@nicholas.robinson](https://forum.inductiveautomation.com/u/nicholas.robinson)\
**Post date:** [December 10, 2020, 4:28pm UTC](https://forum.inductiveautomation.com/t/displaying-minutes-in-reporting-instead-of-seconds/41369/5 "2020-12-10T16:28:14Z")

</div>

@b_zacht I’ve actually been over that page like 20 times in the last 20 hours but it didn’t occur to me what to do with it. Thanks for your advice, it helped me fix my issue.

One small tip I can give to others is that you also have to take the t\_stamp column otherwise the bar graph will not show up properly, the first value would be put on the X axis instead of being a bar. That is why I’m not doing this in a loop.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/2/82fcbe021581fef1e0bf7aeaf90a2b43ca9ad448.png)

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/2/6289e451752dedc3afd30571142c873aedcfb135.png)