# Bar Graph with Day over day totals

**URL:** <https://community.grafana.com/t/bar-graph-with-day-over-day-totals/35090>\
**Category:** Grafana\
**Created:** [August 13, 2020, 1:45pm UTC](https://community.grafana.com/t/bar-graph-with-day-over-day-totals/35090 "2020-08-13T13:45:45Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![mchandler](https://avatars.discourse-cdn.com/v4/letter/m/4491bb/32.png) [@mchandler](https://community.grafana.com/u/mchandler)\
**Post date:** [August 13, 2020, 1:45pm UTC](https://community.grafana.com/t/bar-graph-with-day-over-day-totals/35090/1 "2020-08-13T13:45:45Z")

</div>

I use Grafana to track stats from Freshservice. One thing that has gotten me stumped is how can I show a bar graph that has the number of tickets for the last week. Currently, I am using timeShift(-1d) -2 and so om. But I am not getting the desired result. The time shift is not broken but my logic is. What is returned is the number of tickets I have at the current time a day ago.

For example Wednesday we had a total of 82 tickets, if I look at the bar graph at 9:30 on Thursday it shows Wednesday on had 35 tickets, and at 9:30 on Wednesday we had only received 35 tickets.

Does anyone know how I could solve this problem?

We are using Grafite to get the data to the board. Thank you so much in advance if you have any help.