ignore Time dimension on a chart

[ziabobaz]

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

[sunny_talwar · Accepted solution]

Try this

Sum(Sales)/Sum(TOTAL {<week=>}Purchases)

[sunny_talwar]

Or this

Sum(Sales)/Sum(TOTAL Purchases)