I´m having a issue in calculating a key figure that lookes like this "some amount / (this month revenue + last month revenue / 60)". The key figure is to be used in a line chart where month of year is the dimension.
It is no problem getting data for "Some amount" and "This month revenue", however I can´t figure out how I get the revenue from the last of the current month you are currently calculating.
My data is pre-aggregated to one record pr. month, so "Last month revenue" is always just one row. Don´t think that makes any difference, but now you know ;o)