# Graphs appearance group by date then shift

**URL:** <https://forum.inductiveautomation.com/t/graphs-appearance-group-by-date-then-shift/17055>\
**Category:** Ignition\
**Created:** [February 20, 2018, 4:53pm UTC](https://forum.inductiveautomation.com/t/graphs-appearance-group-by-date-then-shift/17055 "2018-02-20T16:53:47Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Julio.Bautista](https://avatars.discourse-cdn.com/v4/letter/j/3bc359/32.png) [@Julio.Bautista](https://forum.inductiveautomation.com/u/Julio.Bautista)\
**Post date:** [February 20, 2018, 4:53pm UTC](https://forum.inductiveautomation.com/t/graphs-appearance-group-by-date-then-shift/17055/1 "2018-02-20T16:53:47Z")

</div>

I have this excel file that people want to duplicate onto ingition and was wondering if its possible to split the x axis in two showing information based on shifts within a date.

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

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [March 2, 2018, 10:02am UTC](https://forum.inductiveautomation.com/t/graphs-appearance-group-by-date-then-shift/17055/2 "2018-03-02T10:02:56Z")

</div>

The bar chart could probably do this for you, with a bit of scripting, but the colors aren’t making any sense to me. 😕

---

<div class="post-metadata">

**Author:** ![Julio.Bautista](https://avatars.discourse-cdn.com/v4/letter/j/3bc359/32.png) [@Julio.Bautista](https://forum.inductiveautomation.com/u/Julio.Bautista)\
**Post date:** [March 2, 2018, 12:28pm UTC](https://forum.inductiveautomation.com/t/graphs-appearance-group-by-date-then-shift/17055/3 "2018-03-02T12:28:33Z")

</div>

Really that’s great. I don’t know how I would start to generate a graph like this through scripting if you don’t mind giving me a hint. The colors, I would just want to know if I would be able to change than by cell block similar to like in excel

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [March 2, 2018, 2:32pm UTC](https://forum.inductiveautomation.com/t/graphs-appearance-group-by-date-then-shift/17055/4 "2018-03-02T14:32:48Z")

</div>

Let’s start at the beginning. How is the data coming in? Is it a database query? Is it entered by hand?

---

<div class="post-metadata">

**Author:** ![Julio.Bautista](https://avatars.discourse-cdn.com/v4/letter/j/3bc359/32.png) [@Julio.Bautista](https://forum.inductiveautomation.com/u/Julio.Bautista)\
**Post date:** [March 26, 2018, 1:26pm UTC](https://forum.inductiveautomation.com/t/graphs-appearance-group-by-date-then-shift/17055/5 "2018-03-26T13:26:49Z")

</div>

the data will be entered through ingition and saved onto a database. So to answer your question a databasequery