I'm sorry if this is basic question, but I cant figure it out...
I have a really simple line graph where I use the Timestamp data on the X axis https://www.evernote.com/l/AAJMNjCU9zRM67MA27w5WHDAFfhVGMU-yto and then use the "Funding Used" column to show the sum of funds used inside a month https://www.evernote.com/l/AALu5aSU6UhBH6lUiGaFlNhhf_jI69PRdvg
This all works perfectly - except in the data I want to filter out some of it as it belongs to a different project - so I use a SELECT which correctly filters the data I do not want out (when I check with the lightening bolt it is working fine) but now the data in the graph seems to be cumulating. It should be pretty much identical to the display in the previous working example...
I have tried looking at ways to sum and groupby via month but i cannot work it out.
Any help would be greatly appreciated.
Kind regards, Steve