Linking to Date Fields

[#1]

I am having difficulty with the attached qvd.

The quality table is not linking in properly with teh rest of the data. I have created the neccessary links but cannot seem to pull data for Quality scores against agents, whilst also producing other kPI data.

Can anyone see anything obvious that I am missing?

Any help would be much appreciated.

Kind Regards

Richard

[stephencredmond · Accepted solution]

Hi,

In your Quality table you are using:

   Month&[AgentID] as %Key_Quality

To generate the key.  The Month is a cross table value from Excel which is a date in Integer format.

In the Link table you are using:

   MonthStart(Date(RecvdDate))&CallLogAgentID as %Key_Quality,

So the month is in a date format.  Quick change is to floor the month:

   Floor(MonthStart(Date(RecvdDate)))&CallLogAgentID as %Key_Quality,

Should be good to go.

Regards,

Stephen

[stephencredmond]

BTW if you put the Date key value and values from Quality and the Key table into a table box, you would see the disconnect very quickly.

Regards,

Stephen

[#4]

Thankyou for youe help.

Worked a treat.

Rich