I am using the simple connector for Twitter, pulling information into Google Sheets (screenshot attached). My question is why does the SUM_ALL advanced setting not work when I have two separate usernames being searched? Is there another way I could set this up to have both results summed in one cell?
The option may not be supported by the simple connectors. However, I will send this to the dev team to investigate. They will respond when they have more information.
As a workaround, you would need to use a Sheets formula to sum the values as there doesn't appear to be a way to do this in the query itself.