Hi everyone! Could you please help me with the following: is it possible to merge two ranges when determining a range in a dashboard query from google sheets?
For example:
I need to create a barchart visualizing data from a table consisting of two rows: E5:P5 and E7:P7, without E6:P6
How can I do so?
Welcome to the 
community support forums !!
We are excited that you joined our OSS community. Please read about some of the FAQs in the community 
I am not an expert with the Google Sheet plugin but seems like you need to use Transformation to make this working.
I hope this helps.