Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Trend Total of a Filtered Table in Workspace

Avatar

Level 1

Is there a way to trend metrics of a filtered table in workspace to only show the filtered data in the trended table? I have a table of filtered product names and revenue. I'd like to trend the totals shown in this table. However, when I try to trend the totals shown for the filtered data, instead of plotting out the revenue shown for just the filtered products, the graph plots the revenue that would be shown if the table weren't filtered at all. Is there any way around this?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Correct, unfortunately, it can't be done when filtering a table.

You can apply a segment that has the conditions of your filter, then AA should be able to trend just that "filtered" data.

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Correct, unfortunately, it can't be done when filtering a table.

You can apply a segment that has the conditions of your filter, then AA should be able to trend just that "filtered" data.

Avatar

Level 1

Thank you. Unfortunately, a segment won't work for this use case, as revenue for other products can be sent in the same hit with the revenue of the products the filter is for. There are other ways I can go about this, but was really hoping there was a fast way just using workspace.