Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a line chart
Dimension: WEEK
Measure: sum(Sales)/sum({<week=>}Purchases)
My intention is that the chart shows Sales for the given week, divided by TOTAL purchases which were made, regardless of the week. So, in fact, the denominator will always be the same.
The above formula does not work.
Please, correct
Try this
Sum(Sales)/Sum(TOTAL {<week=>}Purchases)
Or this
Sum(Sales)/Sum(TOTAL Purchases)