I am trying to create a trend graphic and to do that I have to summarize the data twice to achieve the sum(max) fields, the problem is that the graph does not recognize the group by month.
The table is correct, but the graphic doesn’t recognize the relation.
I have created an issue for it:
https://github.com/metabase/metabase/issues/13284 - upvote by clicking on the first post
Without knowing exactly what you’re trying to do, you might be able to use Custom Expressions instead as a workaround:
I tried to but it wasn’t sucessfull.
For this specific question I have to sum the max values groupping by the id of the contract, which is in another table.
I don’t think that Custom Expression allow me to sum(max)