google query label replacement when using "group by"
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.
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!
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!