Thanks a lot, you are a wizard !I will never have though of using segment for time range selection. We are Friday and the result look like this: Thanks again !!!!!!   Robin

Thanks Jennifer. There is still one point I don't get. I want the order to be adapted regarding the current day, so dynamically: On Monday: value 1 for Sunday, 2 for Saterday, ... On Tuesday: value 1 for Monday, 2 for Sunday, ...In your proposition (that I like by the way, thanks a lot !!!), it's ab...

Hi all,  I created a combo graph to show by day of the week, evolution of request. The 2 lines represents the last 7 days and last 8-14 days based on rolling dates: The data source is this one: I only used the 2 last columns for the visualization. The date range are rolling dates and the question ...

Thanks Jennifer, By changing with minus 365 days, result looks ok: I found that depending if you choose minus x year, month, days, ... the granularity is different. By selecting month, it won't take care of the day. So I have to select days to force the tool to stay on day granularity. Hope it will...

Hi all, For some report I have to create my own date range, mainly year to date. For this one I think I'm good (I created this on the 12JAN2023):  But I want to compare this period with previous year YearToDate. So I dit this: same definition for the second one by adding minus 1 year but result is ...

Thanks but what is needed is really a flag on the DWH export to explain which hit is the last one of the session.Because as the DWH export is daily, there are some uncomplete sessions (session spread on 2 days because it was around midnight) and as they only want to ingest complete session in the ex...

Sorry, this one is not the solution: I thicked the accepted solution wrongly. Any idea how I can undo this? Exit page is set for all page of the visit, meaning all page of the visits will be in this segment because they all have one exit page.That's the reason why I wanted to use the metric exits bu...

Hi all, I want to create a segment containing last hits of the visit. I was thinking about using metric exits with condition exists but this one is not present in the segment builder. And also, I must be able to add this info in the Datawarehouse export. Any suggestion about how I can do that?   Rea...

And what if you compare visit and occurences? Because occurences is the sum of metrics Page views and page events. So maybe good to add those 4 metrics in your freeform. Page view metric is only populated when a page name is set in the dimension page. For the page event, you have to look to the cust...

I try this with some small adjusment to get this: Visit container: Page equals Page ATHEN within 1 Page viewPage equals Page B AND Exit Page equals Page B ANDEXCLUDE Visit container: Page equals Page ATHEN within 1 Page viewPage equals Page BTHEN within 1 Page viewPage existsI had to change the cond...