# Time Series Component error

**URL:** <https://forum.inductiveautomation.com/t/time-series-component-error/67704>\
**Category:** Ignition\
**Tags:** vision, perspective\
**Created:** [December 16, 2022, 4:58am UTC](https://forum.inductiveautomation.com/t/time-series-component-error/67704 "2022-12-16T04:58:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dharani\_T](https://avatars.discourse-cdn.com/v4/letter/d/bc8723/32.png) [@Dharani\_T](https://forum.inductiveautomation.com/u/Dharani_T)\
**Post date:** [December 16, 2022, 4:58am UTC](https://forum.inductiveautomation.com/t/time-series-component-error/67704/1 "2022-12-16T04:58:27Z")

</div>

Hi,  
I would like to display date wise output in perspective as below,

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/1/11513edb4b582ea591bcf2fbe8e33e790f91d695.png)  
(Vision image)  
But i am getting the below result,

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/9/d9869033cd14472285c80b243aa7142c2bb855b2.png)  
This is how my dataset looks like,  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/a/1a4fc05f10082b8f37b07ccf7c61303ecba1943d.png)  
Query:

```auto
SELECT dop as 't_stamp',
       sum(count) AS 'Output'
FROM tbl_output where MONTH(dop) =MONTH(CURDATE())
and lineID= :iLine 
group by dop 
order by dop asc;

```

without group by it is displaying as component error.  
How to achieve the bar like structure as in vision?

---

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [December 17, 2022, 10:09am UTC](https://forum.inductiveautomation.com/t/time-series-component-error/67704/2 "2022-12-17T10:09:48Z")

</div>

It looks like this is a known problem for the bar chart:

> [@Perspective 8.0.14 Time Series Bar Chart width](https://forum.inductiveautomation.com/t/perspective-8-0-14-time-series-bar-chart-width/37160/13):
>
> No solution in place yet. I’ve got a ticket open to expose some options for adjusting the bar chart width on the Time Series and Power Charts. I’ll give it a bump.

The above thread has some possible css solutions as well as a link to the below solution using the XY chart instead:

> [@Stacked Bar Chart in Perspective - Detailed Steps](https://forum.inductiveautomation.com/t/stacked-bar-chart-in-perspective-detailed-steps/47107):
>
> Few months ago I needed to create a stacked bar chart and ran into issues ([Perspective 8.0.14 Time Series Bar Chart width - #3 by arun1](http://forum.inductiveautomation.com/t/perspective-8-0-14-time-series-bar-chart-width/37160/3)). There are few posts here but they don’t give a full picture. Here are the steps that I took to create one: First it is worthwhile to note that we need to use the XY chart and not the TimeSeries chart because the width of the bar chart is calculated automatically based on the amount of data in the x-axis so if you have sparse data in a wide time range then th…