topic Re: How to transpose 2nd column in Dashboards & Visualizations

How to transpose 2nd column

james_n — Wed, 30 Sep 2020 04:42:46 GMT

I have query as shown below,

|stats count by stn stn_status

result:

stn stn_state count
stn_1 completed 20
stn_1 In progress 2
stn_1 failed 8
stn_2 completed 30
stn_3 completed 10
stn_3 failed 10

expected results:

Stn completed In progress failed

stn_1 20 2 8
stn_2 30
stn_3 10 10

Help me on this, Thanks in Advance.

Re: How to transpose 2nd column

rmmiller — Wed, 30 Sep 2020 04:43:10 GMT

Replace your stats command with this:

| chart count over stn by stn_state

Note: I couldn't tell whether the correct field name is "stn_state" or "stn_status" since you use both in your question. Use the correct field name in this chart command, and you should get the results you want.

Hope that helps!
rmmiller

Re: How to transpose 2nd column

woodcock — Thu, 26 Mar 2020 16:25:56 GMT

Simply change stats to chart; no other changes are necessary.

Re: How to transpose 2nd column

james_n — Fri, 27 Mar 2020 05:17:05 GMT

It Works, Thank you very much.