I was thinking of Excel's own Filter function.

Try doing the following: Go to account.adobe.com and sign out of your account.Delete all adobe.com-related cookies in your browser.Sign back into your Adobe account. If that still doesn't work, repeat the above steps, but between steps 2 and 3, uninstall the Activity Map extension from your browser....

If you have permission to use ReportBuilder (and are using a Windows computer with Excel), then you can build and schedule your reports in Excel using ReportBuilder to get the data for you. Then you don't need to go down the DB/BI tool path.

I assume that you're working with Adobe Analytics. Take a look at my post, where I provide a possible solution: https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-blogs/don-t-use-clearvars/ba-p/410740

It's great that you managed to get it to work!  I think your approach of not using "Clear Variables" is fine. I actually don't like "Clear Variables" and even contributed a post here to advise against using it: https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-blogs/don-t-use-clearva...

It's not easily done in Analysis Workspace. Unfortunately, in there, tables can only be filtered by dimensional values. Segments won't work in your case because segments are applied on the individual hits of data. In your case, though, you want a total number of Orders or an aggregate percentage of ...

I really dislike the AEM integration of ACDL, because it introduces screwed up implementations like what you're experiencing, and also it depends so heavily on custom code. With that said... I haven't used this AEM-ACDL integration myself, so my answer relies on the documentation at https://experien...

I'm not sure if you can reset ECID's Visitor object by calling Visitor.getInstance() again. My understanding is that once it has been created in a web page, it stays there until the user navigates to another web page, and then the cycle repeats. That is why I had said that you could try using plain ...

As I had mentioned, the AEM integration is kinda screwed up in that you have to rely on custom code. So you can't take advantage of the ACDL extension's capabilities if you go down that route, unfortunately. Take a look at the sample code provided at https://experienceleague.adobe.com/docs/experienc...

I believe this method doesn't work because the ECID setting takes effect when the Launch library is loaded, and doesn't change subsequently as the user interacts with your web page, including opting in/out of consent. You might need to have a rule with custom code that changes the cookie's lifetime ...