Hi EyalGershon
Great question! And welcome to the community!
I believe you could do something similar to what was asked in this community post: http://community.retool.com/t/how-to-loop-through-an-array-and-hit-an-api-for-each-value-in-a-column/4291/6
The idea is to loop over an array of items (this could be months) and then for each item in the array trigger the query you have already written. The month would then be dynamic and passed in as an 'additionalScope'. If you scroll to the bottom of the community post you will see a great overview on how to use this in a JavaScript Code query.
1 Like