I am getting an error "Error while communicating with Datasource" and in Show Details I am getting as Cannot mix aggregate and Scalar Expressions.
I am using a calculation say ceiling(sum(sales)/date difference between two dates(based on parameter selection)).
When this is in local extract, it is working fine without errors. But when I publish the data source then I am getting the error.
Please help me on this
I would reach out to our support team about this. If you can provide steps to reproduce this it would be great. This seems like an issue that either shouldn't happen or have an error message presenting you with information why it can't work.