Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I'm currently working on a project where I need to compare the following:
We are working under the assumption that a busier a day will be, the more chances a unit have to be assigned during an activity and I'd like to get the correlation between the two items. There is one - I've used Excel to get it, but now I need to add it to QV.
Given the fact that I need to exclude some data point using "IF" conditions (both in Calls and Activities), I am using variables to simplify the correlation expression. Attached is spreadsheet with the data for Calls and Activities - the number I need to use to create the Correl expression.
I've tried multiple times it QV to create a Correl expression, but I either get an error or a value of "-" (minus sign).
Anyone can provide assistance on that?
Regards,
Nic
Any one can provide assistance on that question?