Could minor changes to freehand SQL query preserve existing charts?
I often create charts whose data source is a freehand SQL query. Any subsequent change to that SQL erases all of the charts I've made, no matter how minor. Just now I added a "WHERE mydate > '2018-04-01'" line to filter out a few bad records -- and that simple filtering addition erased my charts I'd built this afternoon.
I get that if the data fundamentally change, some charts will change too, like the warning says: "Changing the SQL for this report may result in some formatting options being removed." But it would be a big time-saver if, when the resulting columns are the same, changing the SQL did not erase the charts.
If there's something I'm missing now that I could be doing to save my charts, I'd love to know that too.