can I copy report and modify the query of the view
We have multiple customers and we need to display the same set of reports but with different data to each of them.
The data is taken by the customer id from the DB.
Right now we copy views, change the customer id and create reports from those views.
We have failed to find a way to copy Reports and change its dependency on the view.
As a result, I have to copy views, modify the customer id and then create the report from scratch for each customer.
It's a lot of manual work. So I wonder if there is a smarter way to do that.
So the question is if it's possible to change the view of an existing report?
Also, maybe there are some API calls, which can help to automate that workflow?