Hey @skatofiabah Yes, we need to use DISTINCT - SELECT count(distinct(concat(post_visid_high , post_visid_low , visit_num))) as visit

Hey @skatofiabah, I see you're using date_time, which should be fine. It is something else; maybe the data feed didn't have a complete dump. I have seen such issues in past where sometimes the feed files are not properly ingested into the system, which can cause issues. I don't have the visibility o...

Hey Everyone, It's time for the final quiz.  Question:A virtual report suite inherits most of the service levels of the base report suite. Which settings are NOT inherited:A. Report suite name, eVars, classificationsB. Permission groups, report suite ID, processing rulesC. Report Suite name, report ...

Filter-wise, I don't think there are any issues in SQL. RAW data/feed data will always be higher than the workspace, but in this case, you might have to dig a bit deeper.  One more thing: does the segment use 'Contain' filters or 'Equals'? Maybe you can double-check the same as both would yield diff...

So, in your query, have you tried replacing post_page_url ="URL value" with post_evar7 = "URL value"? Does the number match, then?

Hey @skatofiabah Would it be possible to share a screenshot of the workspace data?

Hey @skatofiabah, In Adobe Workspace, we don't have any out-of-the-box dimension that shows the page URLs. Hence, I'm assuming you must be using an eVar or Prop to check the same in the workspace.  If that is the case, can you try checking the same in your downstream data and check if it returns the...

Hey @RajeshwariPa1, You can learn more about these function in these blog - https://www.fullstackanalyst.io/blog/adobe-analytics/advanced-time-series-analysis-through-linear-regression-statistics-in-adobe-analytics/https://blog.developer.adobe.com/predictions-using-advanced-statistical-functions-in-...

I don't think that is something that is possible in AA and is out of the box. The only places where you see all events combined are in the data feeds columns - event_list and post_event_list, where you need to use event lookup to identify the event. However, in the workspace, I don't think we have s...

At this point, it seems the data view editor offers no way to copy settings, like components, to an existing data view. So, has to be done manually. Maybe you can put this in the idea forum so that we can have this feature incorporated in future releases.