count in set Analysis

[didierodayo]

Hi All,

1- I would like to count the ACCESS TIME where the count of ACCESS TIME per day is  <= 10.

2- I also need the access frequency based on the timestamp

how can I achieve this with set analysis?

I have tried the first one but it is not returning anything

1-  count({<TRACKING_FUNCTION_ID ={"count(TRACKING_FUNCTION_ID)<= 10"}>}TRACKING_FUNCTION_ID)

2- ??

[Anonymous]

may be like this?

=count({<TRACKING_FUNCTION_ID ={"<=10"}>}TRACKING_FUNCTION_ID)

or

=count({<TRACKING_FUNCTION_ID ={"<= 10"}>} distinct TRACKING_FUNCTION_ID)

[tamilarasu]

Hi,

1. Count({<TRACKING_FUNCTION_ID={"=Count(TRACKING_FUNCTION_ID)<=10"}>}TRACKING_FUNCTION_ID)

2 . Please post your expected output.

[didierodayo]

Hi Tamil,

for number 2

I would like to know how often screens are accessed based on the ACCESS TIME field.

Thanks

[Anonymous]

Hi Didier,

1.- =count(DISTINCT {<YourDimOnChart={"=count(DISTINCT YourFieldToCount)<= 100"}>}YourFieldToCount)

2.- SUM({<YourDimOnChart={"=count(DISTINCT YourFieldToCount)<= 100"}>} Time([ACCESS TIME]))/Sum(TOTAL <YourDimOnChart> Time([ACCESS TIME]))

Rgards!!

[maniram23]

Hi,

Count({<TRACKING_FUNCTION_ID={"=Count(TRACKING_FUNCTION_ID)<=10"}>} DISTINCT TRACKING_FUNCTION_ID)

[tamilarasu]

Hi Didier,

You mean the frquency between the two intervals.? If you could show me some small example with expected output, It would be easy for me to provide the solution.