--0000000000009052a40639fc2de1 Content-Type: text/plain; charset="UTF-8" Hello Tim, I am hoping this makes sense. Following up on our conversation today. Would it be possible to have Tableau adjusted for Chicago so it either only displays Chicago numbers for both Actual and Target or it displays combined Chicago plus MIchigan for both Actual and Target? I am trying to understand the actual versus goal entries in Tableau for Tier 1 clients and Billable hours. Understanding that in May our target numbers were adjusted to be a combined goal consisting of Chicago Goals and Michigan Goals. My confusion lies in the actual vs target that displays in Tableau Example May Looking at Chicago results Tier 1 Client - Actual is 64 - Target is 79 Assuming May target is an increase of 1 from April 1 target: Chicago Target would be 71 and Michigan Target would be 14, which is a combined target of 85. But as stated above Chicago displays a target of 79 which appears to be the Chicago target of 71 plus Michigan's actual April Tier 1 count of 8. Is that correct? Billable hours I am less able to interpret due to there not being a consistent projected increase for the target. May Goals: Chicago Target is 35,680 Michigan Target is 4068 So, my question is Chicago's billable hours Target 35,680 or is it actually 31,612 which is the difference between Chicago's stated Target and Michigan's stated target? Thanks, Diane -- Diane Mockenhaupt General Manager, Chicago Office and Michigan Office dmockenhaupt@thekey.com Mobile: (224) 808-0607 Office: (847) 853-7777 TheKey.com *We value your feedback. Please leave us a Google review* --0000000000009052a40639fc2de1 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hello Tim, I am hoping this makes sense. Following up on our conversation today.=C2=A0 Would = it be possible to have Tableau adjusted for=C2=A0 Chicago so it either only= displays Chicago numbers for both Actual and Target or it displays combine= d Chicago plus MIchigan for both Actual and Target? I am trying to understand the actual versus goal entries in Tableau for T= ier 1 clients and Billable hours. Understanding th= at in May our target numbers were adjusted to be a combined goal consisting= of Chicago Goals and Michigan Goals. My confusion= lies in the actual vs target that displays in Tableau Example Ma= y Looking at Chicago results Tier 1 Client Actual is 64 Target is 79 Assuming May ta= rget is an increase of 1 from April 1 target: Chicago Target woul= d be 71 and Michigan Target would be 14, which is a combined target of 85.= =C2=A0=C2=A0 But as stated above Chicago displays a target of 79 = which appears to be the Chicago target of 71 plus Michigan's actual Apr= il Tier 1 count=C2=A0 of 8. Is that correct? Billa= ble hours I am less able to interpret due to there not being a consistent p= rojected increase for the target.=C2=A0 May Goals: Chic= ago Target is 35,680 Michigan Target is 4068 = So, my question is Chicago