@Asheesh_Pandey Thanks for the response. but distinct count only works for dimension. Isn't it? How can I use it for "Units" Metric?

Hi Everyone, I am trying to get all SKUs which has more than 10 units sold in a visit. Here is report with segment definition which is giving wrong output:I understand the fact that product variable could have multiple SKUs with varying quantity in an order hit and only all hits which qualifies my c...

Hi, I think you want to use service now so that your JWT token won't expire after 24 hours(OAuth case). What I did for this problem to generate JWT dynamically whenever it require. Please check screenshot for the code which can help you. Just add your keys and let me know if it helps you.JWT generat...

Hi sharon19403573 , You need to understand the differentiation between page view and custom link request. Only then you can interpret any debugger properly.

Thanks, Will keep this in mind!

Here is the final working logic. Thanks for all the help davidj85759080​

Thanks, davidj85759080​! Appreciate your help!

Hi ursboller​, Earlier I thought to use the formula for “approximate distinct count” and get the number of days that I had in my timeframe but when I use it against Product dimension, it completely shatters meaning of "approx". Please check below screen. That is why it is not at all reliable. Also ...

Hi,In a business case, I am calculating a metric and in that, I need to divide a dimension by "Number of Days an analytics user selected in the calendar" while fetching a report. Please note it is very different from Function (Approximate Distinct Count(Dimension (Days)).Any suggestion to achieve th...

Hey Dave,Instead of defining days manually in the segment and calculating units/day, can't we have any method, where a number of days can be taken automatically from calender (date rage) which user select and we divide it by same? If we get Days by doing Approx Count Distinct at (Day) dimension, It ...