Hi @abhijithr  Thanks a lot for your comment, i am only looking to sum up the "time frames". each session id can have multiple time frames.

Hi I have a dimension of evar type where the time is mentioned in microsecond. Attached is the screenshot where it shows time spent in cart for a session id.There can be multiple  time frames for one session id, depending the number of items in cart etc.How can i convert it to metric as a sum of all...

Yes, I have checked and all the values are "1.0002442201269182". None of the session id's are duplicate here.

thanks for reply, my task is to get count of unique session id's on a particular tipo pagina page, This is why i am using approximate distinct count. I tried using @visits  but thats not giving correct count either.On ~99999 - Its working fine, as they are default session id's and i want to exclude ...

I have created a metric which is suppose to count session id on certain conditionIn the attached screenshots, metric Def -- The definition of metric count, i.e. count of session id's (Excluding the one's ending with 99999)but when i export them in csv, the payment instance count in column B, row num...

You got me right, i have a dimension where Cart - Payment - Confirmation steps are thereUnder which i drop session id's to see how many unique sessions are there and here i want to see how many dropped out from Cart, example, 10 people/session ID's added to cart but only 8 went to payment and due to...

I have a dimension where 5 pages are listed and the counts of id's visited each page, I need to find how many ID's dropped out between two Pages, for an example, on page 1 there were 10 id's and on page 2 there were 8 id's, i want to find how to list those 2 missing ID's