Create a measure that returns total time user is logged in

[Anonymous]

- Attempting to measure the durration a user is logged in

Here is the dataset: 

- Filtering by a date range, I am attempting to measure how long users are logged IN.

- I started out by created two new columns, TimeLoggedIn, and TimeLoggedOff:

- Then I created a new MEASURE:

TotalTimeLoggedIn = DATEDIFF('public callcent_ag_queuestatus'[TimeLoggedOff], 'public callcent_ag_queuestatus'[TimeLoggedIn],HOUR)

- Measure does not work, here is the error:

"A single value for column 'TimeLoggedOff' in table 'public callcent_ag_queuestatus' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."

Thank you in advance for your help.

[Ashish_Mathur]

Hi,

Share the link from where i can download your file.

[Anonymous]

@Ashish_Mathur

https://drive.google.com/open?id=0B2-4sULI8pc_ellEMUFRNFp1WWM

[Ashish_Mathur]

Hi,

I cannot understand yoru question.  How have you computed timeloggin and timeloggedoff?  Also, please show the exact result that you are expecting for each agent_num.