Sql pareto for column values per row help request

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

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.

1 Like