Skip to Content
0

How to create maximum number of sessions on that particular time report using web intelligence tool

May 03, 2017 at 04:27 AM

47

avatar image

Hi All,

I have a requirement i.e., create a “Maximum number of sessions on that particular time” (it can be day or week or month or year) report in web intelligence reporting tool.

We have objects like Day, month, year and session id.

Report should be session id vs day or session id vs month or session id vs year.

Kindly provide some information asap.

Thanks

Ram

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jyothirmayee A May 03, 2017 at 06:04 PM
0

Hi,

Get the Count([Session Id]) In ({Year/Month/Day)

Then calculate the Max([CntSessID])

Let me know how the result looks like.

Thanks,

Jothi

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Jyothi

Will check and let you know the update

0