Performance Analytics Breakdown Relations not working

[crowe1288greg]

I've created an Automated Indicator for Daily New Calls.

I've created 2 breakdowns:

Site Agent: the elements are the desk agents. I'm able to see each agent with their number of calls.

Hour of Day: this is a scripted breakdown using a bucket group. This groups the calls by the hour of the day. Examples, 00,01,02,03,04,...,24

Collect breakdown matrix is turned on. I've confirmed the data is being collected within the pa_scores_l1 & pa_scores_l2 tables.

Example:

Site Agent A: 12 calls in the day. Breakdown Hour of Day: 08-3 calls, 09-3 calls, 10-6 calls.

I'm unable to get the breakdown relations to work properly. I think its because the 2nd breakdown is scripted.

Here's what the breakdown relation look like:

Name: Site.Agent.HourofDay

Breakdown: Site Agent

Related Breakdown: HourofDay

Table: new_call

Breakdown field:created_by

related breakdown field: created by

When I'm viewing on the Analytics Hub, selecting the breakdown Site Agent, it lists the agents with their total number of calls for the day.

If I click on an agent, it shows Site.Agent.HourofDay - Related Breakdowns.

When I expand this it shows 'No elements to display'.

I've confirmed all the data looks good between the pa_scores_l1 and pa_scores_l2 tables.

Within the breakdown relation, I've tried different  selections in the 'breakdown field' & the 'related breakdown field'. I receive the 'No elements to display' each time.

Any suggestions?