Announcements
cancel
Showing results for
Did you mean:
Partner - Contributor III

Chart with different dimensions

Good Morning

I have a question and I do not know how to solve it

Following:
I have a telemarketing employee rests table by estimated hour and time taken.
The table is as follows:

 EmployeeID Hour estimated Hour taken 1 09:00 09:00 2 09:00 09:00 3 15:00 09:00

The problem is that I have to do a line chart per hour indicating how many people were estimated to pause at 9:00 and how many actually stopped.

In the example above was to have the following answer:
At 9:00 am Estimated pause = 2, pause performed = 3

The biggest problem is that the time dimension is different columns.
If done in different graphs is correct when together gives always the same value to realized and estimated.

1- Create a separate dimension of estimated time

2- Count by set analysis disregarding the dimension

3- Have already tried count employeeId with IF

What can I do?

Thanks

1 Solution

Accepted Solutions
MVP

Check this out

Script

Table:

EmployeeID, Hour estimated, Hour taken

1, 09:00, 09:00

2, 09:00, 09:00

3, 15:00, 09:00

];

[Hour estimated] as Hour,

'Estimated' as Flag

Resident Table;

[Hour taken] as Hour,

'Taken' as Flag

Resident Table;

Straight table

Dimension

Hour

Expressions

=Count(DISTINCT {<Flag = {'Estimated'}>} EmployeeID)

=Count(DISTINCT {<Flag = {'Taken'}>} EmployeeID)

Pivot Table

Dimensions

Hour

Flag

Expression

=Count(DISTINCT EmployeeID)

MVP

Check this out

Script

Table:

EmployeeID, Hour estimated, Hour taken

1, 09:00, 09:00

2, 09:00, 09:00

3, 15:00, 09:00

];

[Hour estimated] as Hour,

'Estimated' as Flag

Resident Table;

[Hour taken] as Hour,

'Taken' as Flag

Resident Table;

Straight table

Dimension

Hour

Expressions

=Count(DISTINCT {<Flag = {'Estimated'}>} EmployeeID)

=Count(DISTINCT {<Flag = {'Taken'}>} EmployeeID)

Pivot Table

Dimensions

Hour

Flag

Expression

=Count(DISTINCT EmployeeID)

Community Browser