Aggregation Measures

Just to make sure I’m not missing something… is there not a supported way to create an aggregation measure?

I need to create a measure which is a calculation based on the sum of two other fields. So if I want a ‘By Day’ and a ‘Total’ split I am creating two separate queries and hard-coding the calculation in the query (sql server) - is that correct?

Hi there. I think you can do it in a single sql query by making running totals. There’s a bunch of online materials on this:

Sorry it I got your question wrong…

No problem - it was an interesting read nonetheless