# Sql pareto for column values per row help request

**URL:** <https://forum.inductiveautomation.com/t/sql-pareto-for-column-values-per-row-help-request/59119>\
**Category:** Ignition\
**Created:** [May 2, 2022, 2:51pm UTC](https://forum.inductiveautomation.com/t/sql-pareto-for-column-values-per-row-help-request/59119 "2022-05-02T14:51:11Z")\
**Posts on this page:** 1\
**Showing post:** 21

<div class="post-metadata">

**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\
**Post date:** [May 2, 2022, 7:47pm UTC](https://forum.inductiveautomation.com/t/sql-pareto-for-column-values-per-row-help-request/59119/21 "2022-05-02T19:47:52Z")

</div>

Where’d the “u” comes from in the output?

You made that scripting method easy to understand. Thanks @JordanCClark

Company uses 8.1.0 Ignition, no script scheduler. So I tend to use prepared queries.

* * *

Was able to finish a pareto chart this afternoon by making a fault table, transaction groups, and a query like the one Phil and a few of you helped me with last year:

[HERE](https://forum.inductiveautomation.com/t/calculating-total-time-in-seconds/49322/30)

Not the same as the wide table.

Wanted to finish today, and didn’t know how else.

Thanks for helping me.  
I checked the links. That example with the unpivot didn’t make sense to me.  
Then when I clicked the link recommended off from it with the phone types, that was confusing enough that I switched gears to make the tall table and query.

---

_[View the full topic](https://forum.inductiveautomation.com/t/sql-pareto-for-column-values-per-row-help-request/59119)._