# SQL tags data to columns

**URL:** <https://forum.inductiveautomation.com/t/sql-tags-data-to-columns/27593>\
**Category:** Ignition\
**Created:** [August 20, 2019, 1:03pm UTC](https://forum.inductiveautomation.com/t/sql-tags-data-to-columns/27593 "2019-08-20T13:03:02Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![nouh.qaoud](https://avatars.discourse-cdn.com/v4/letter/n/e0b2c6/32.png) [@nouh.qaoud](https://forum.inductiveautomation.com/u/nouh.qaoud)\
**Post date:** [August 20, 2019, 1:03pm UTC](https://forum.inductiveautomation.com/t/sql-tags-data-to-columns/27593/1 "2019-08-20T13:03:02Z")

</div>

Dears  
I have haistorical tag with 3 values only (1,2,3) .  
Could you please help me to show the percentage of each value per day as below:

 ![historical%20tag](https://us1.discourse-cdn.com/inductiveautomation/original/2X/6/6b607540117a3f795a7a88226d4fd60b635e9eaa.jpeg)  
Thanks  
Nouh