google query label replacement when using "group by"

in #spreadsheet6 years ago

Google query function return data ranges's header when using "group by".

The header includes property. Such as count, sum.

You can use as below.

=QUERY(F2:G4,"SELECT F, SUM(G) GROUP BY F LABEL SUM(G) '합' ",1)

F2:G4 is data range.

[label is not used]
구분 | sum count {colname}
col1 | col2

[label is used]
구분 | 합
col1 | col2

You can express it more clearly and pretty.

Sort:  

Hello @zero6pak! This is a friendly reminder that you have 3000 Partiko Points unclaimed in your Partiko account!

Partiko is a fast and beautiful mobile app for Steem, and it’s the most popular Steem mobile app out there! Download Partiko using the link below and login using SteemConnect to claim your 3000 Partiko points! You can easily convert them into Steem token!

https://partiko.app/referral/partiko

Congratulations @zero6pak! You received a personal award!

Happy Birthday! - You are on the Steem blockchain for 2 years!

You can view your badges on your Steem Board and compare to others on the Steem Ranking

Vote for @Steemitboard as a witness to get one more award and increased upvotes!

Coin Marketplace

STEEM 0.30
TRX 0.26
JST 0.039
BTC 95213.51
ETH 3406.88
USDT 1.00
SBD 3.49