@deion - sorry I have just reread this. I am afraid this not going to be possible in Adobe. The main reason is because while you can build a custom metric that only counts the hours of yesterday that have passed, it will never be a fair comparision because Adobe will look at the whole hour. So as an...

Good idea. This is not an ideal solution but in our business, we get around this by using a mixture of report builder and Tableau. Not the perfect solution but one that can be considered. Thanks Dave

@DillanGump- I think this might be something really simple.and hit_source not in (5,8,9)should beand hit_source not in (5,7,8,9)Once I did that (and renamed the page and database) your query ran fine for me.

@deion - yes if you want to create this for every hour of the day then you will need to repeat 23 times. Are you going to be using workspace or another tool (API / Datawarehouse)? I only ask because in workspace you will need to have 24 columns (you can't pivot this work with rows) which might make ...

Hi There, I have managed to solve this for you. The first thing you need is a "5pm Visit" such as below:  Then you need the following:Change Number "7" for the period you want to look back.So if your report is showing days, it will be 7 days, if it is weeks it will be 7 weeks. I hope that helps. Dav...

Hi there, Depending on what you are looking for this can be done quite easily. In the Logs section search for "Datawarehouse" in the event section: For for scheduled daily reports (not the adhoc pulls), this will only show the date that the report was first created (e.g. not a row for every day). If...

I heard back from Adobe on this today. The reason I am having an issue is because my dimension was a date. It works fine wt. an eVar.

Hi there, Hopefully this is what you are after (based on a target of 120K orders) with 4 custom metrics:     Cumulative Orders:    

Count me as a vote for this idea. Whenever I train users on the basics, one of the key things I start with is "Never use Occurrences. Adobe put it there by default but 99% of the time it's not what you want". Thanks Dave

To further reiterate on this, I used to work for a web analytics vendor. Comparing to other systems will never give the same number. With that out of the way and based on what you have said - I would overlay domain against cities in workspace. This will show you if there any suspicious bots (such as...