# Perspective Charts

**URL:** <https://forum.inductiveautomation.com/t/perspective-charts/68014>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [December 28, 2022, 6:25am UTC](https://forum.inductiveautomation.com/t/perspective-charts/68014 "2022-12-28T06:25:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Divya\_Chorge](https://avatars.discourse-cdn.com/v4/letter/d/f05b48/32.png) [@Divya\_Chorge](https://forum.inductiveautomation.com/u/Divya_Chorge)\
**Post date:** [December 28, 2022, 6:25am UTC](https://forum.inductiveautomation.com/t/perspective-charts/68014/1 "2022-12-28T06:25:13Z")

</div>

I want to show the average data of one column from SQL in perspective by using charts.  
I have tried to use the SQL AVG function in named query but still I am getting error.

---

<div class="post-metadata">

**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:** [December 28, 2022, 11:15am UTC](https://forum.inductiveautomation.com/t/perspective-charts/68014/2 "2022-12-28T11:15:25Z")

</div>

You need to post your SQL and the error message for anyone to help you. Use the \</\> code formatting button to preserve code indentation and apply syntax highlighting.