Some times you have those days when you just forget the basics. Here's mine
Attached is a sample qvw where I am looking to compute the Inactive Turnover% = SUM(Inactive)/SUM(ActiveSummary) and display it on a table by InactiveReason.
It is a snapshot metric and therefore if the dimension is monthly, then it uses the month's values (easily done), if it is Quarterly, then uses end of quarter values for that quarter, if it is yearly, then end of year values.
I know this is possible in an expression but don't remember if I need to create the associated QuarterEnd and YearEnd values for each record in my MasterCalendar when I ultimately add it or can I do it without it.
For instance,
LOAD * INLINE [
AsOfDate, Active, Inactive, InactiveReason
1/31/2013, 1776
1/31/2013, , 3, Voluntary
1/31/2013, , 5, Involuntary
2/28/2013, 1278
2/28/2013, , 56, Voluntary
2/28/2013, , 34, Involuntary
3/31/2013, 1852,
3/31/2013, , 40, Voluntary
3/31/2013, , 60, Involuntary
4/30/2013, 1298,
4/30/2013, , 48, Voluntary
4/30/2013, , 52, Involuntary
];
If put in a straight table with Year and Quarter as the dimensions with Inactive Reason, I want Inactive % to be 40/1852 for Voluntary and 60/1852 for Involuntary.
any assistance is appreciated
