The problem with this is that because there is more than one hit in a visit (typically). It will find a hit that doesn't have evar30 and include that visit, regardless of if any of the other hits in the visit do have evar30. It has to be an "exclude" instead of a "does not exist". 

So you're basically looking for visits that did not interact with evar30.   If you do option 1, in the visit it's going to look for a hit where evar30 doesn't exist. Once it finds it, it will include that visit. This means that if the visit has more than one hit, one with evar30 and one without evar...

I agree with @Jennifer_Dungan, the mean function is exactly what I would do. The only thing I might suggest differently is the Median function instead, depending on what your data looks like. But generally, either of the measures of central tendency (mean or median) are going to be the simplest way ...

Clicking "show grand total" just shows/hides the total that is at the top. What determines whether it is a "grand total" or "column sum" is based on how you've brought the dimension in.  Generally speaking, dragging and dropping an entire dimension, whether or not you use a filter, will show you a d...

Yeah, that's true about using the instances for when the evar actually fires.   But for the post_evar, even if you're using the post event list, the instances will only fire when the evar actually fires. So if you want occurrences for the evar, you still need to do a distinct count of the visit_page...

Actually, the tables sum is correct. This is because the total for a freeform table can either be a "grand total" or a "column sum."  With the dimension that you have in your table, page URL, the people column is telling you how many unique visitors saw each of the URL. It's very possible that one p...

Based on your screenshot having the metric "people" I'm assuming you're using CJA and not Analysis Workspace? I've only used CJA a little bit, but I attempted to build something similar. I made a table and a line graph from it, and then did a filter on the table, but the line graph didn't change. So...

In the data feeds every line is equal to one server call. So one row would equal one instance of an evar. The "evar" column is populated when an evar fires, the "post_evar" column is populated when an evar fires or has a persisted value. So if you want to count the number of times for it firing, loo...

You might get a better/faster response to this if you post it in the AJO community, this section is primarily for Analytics/CJA.   Adobe Journey Optimizer - Adobe Experience League Community

The purpose of the alerts is to let you know when something significant is happening so that you can react quickly to it. For that reason, the reports are sent as soon as the data is available. If it's coming in at 12:30am I'm assuming that it's a daily granularity alert. If that's the case, then yo...