Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have some data about an engineer service call. The call has a time when the customer rang (CallInDate), and a time when the engineer attended(CallCDate) and the type of call.
I have 2 time dimensions for the call. One linked with the CallInDate and one linked with the CallCDate.
I want a table that has month/year in the first column, number of calls taken (CallInDate) as an expression and number of calls completed (CallCDate) in the month.
Obviously I can easily do one or the other by using the appropriate dimension and doing a simple Count(), but how can I get both in the same table?
George,
see the attached example.
I hope it´s showing what you are looking for.
Good luck!
Rainer
Hi thanks for the example, the table structure isn't quite what I have though.
I have a fact table, with many different things, one of them is the call data.
They key difference between your example and my data is that the call data, with CallInDate and CallCDate is that there is only one row, containing both dates in different fields.
George,
please provide some example data (example.qvw).
Thank you!
Rainer
Hi Rainer,
See attached
Thanks.
Hi George,
I´m not exactly sure what your starting point is.
I guess the table CallData.
See the attached file.
It´s nearly the same as the first one.
Good luck!
Rainer
Sorry, yes, the table CallData is the starting point.
Thanks for the help. Is the only way going to be changing my table structure (i.e. doing a resitent as you have)?
The real tables are quite a bit more complex but if this is the only way then I'll have to figure it out.