Line Charts Showing Grand Totals Instead of Filtered Channel Data (Linear Attribution)

[Lux6]

In Adobe Analytics, we need a line chart that shows the monthly trend for specific marketing channels (filtered totals). However, using a 90-day linear attribution model and applying segmentation still results in a chart displaying the grand total across all channels, even those excluded by the filter. This forces us to export data to Excel for accurate charting, which is inefficient. Is there a way to configure Adobe Analytics to correctly display filtered channel totals in a line chart?

[juliusonyancha]

Hi @Lux6 have you considered creating a segment that captures the marketing channel in question? It's unclear from the screenshot shared what target the line chart should visualise. I have set-up a filter within the analytics workspace freeform table which works as it should (only the filtered items are trended)

[Lux6]

Yes, unfortunately it didn't work as well. Visits and revenue are the dimensions that we would want to be visualized in the line chart using the selected marketing channels as shown in the screenshot. It always shows that grand total instead of the selected marketing channels.

[Lux6]

I just realized I attached the wrong screenshot. This is the one I'm pertaining to. 

In the chart, the filtered total is the 900k+, however in the line chart, the revenue for November is at 2.6M. 

[Harveer_SinghGi1]

@Lux6 I see your point that how could the graph count for a single month could be higher than the total of the filtered values of the freeform table.

It looks like the line chart is plotted using the grand total i.e. 11.15M and not the filtered total as you'd expect. For that matter other trend type visualizations like Area and Area Stacked are also behaving in that manner. I'm assuming when you run a trended visualization on a ranked report it uses the grand totals for plotting the graph.

While I don't have the clear explanation for why the graphs behave this way I believe you can use the suggestion from my comment below to avoid the work of exporting the data to excel for accurate charting, you can achieve the correct charting based on the filtered totals if you convert your dimension level filters to a segment and use it either on panel or in freeform table against the metrics.

So instead of doing this,

do this,

or this,

Cheers!

[Jennifer_Dungan]

I assume this is CJA, since you have the "People" metric (unless this is some custom metric that you made called "people")?

 I cannot replicate this in Adobe Analytics, or in the CJA sandbox....

In AA, the "out of" is part applies to filters on the the breakdown, not segments applied to the panel.

In both AA and CJA, I created a simple segment and the "out of" matched the column value, and the line graph looks correct (properly segmented):

For the record, here is the data without the segment:

Can you share more details about how your segment is made? Maybe there is something strange there that is causing the issue?

[Lux6]

We didn't use segment for this one, we just decided to filter out the irrelevant marketing channels and retain the ones that we need. We also used segment but still it shows the grand total instead of the selected total. 

[Harveer_SinghGi1]

Hi @Lux6 ,

If I understood the question correctly, what you are trying to understand is why the Freeform for People metric says "850 out of 113,887" instead of "850 out of 850" because 850 is the returned UV count by your filters.

This is working as designed as you are seeing the numbers against dynamic dimension items and not static dimension items where you could choose to either show the sum of current rows or grand total under row settings.

What this means is, when you filter the line items of a dimension, the values are dynamically returned based on the filter you applied and for dynamic items the grand total will not change, it will show the count as per the total count for that dimension even when it is filtered. When you use static items on the other hand, you can choose to show either the sum of filtered rows or grand total (like it shows for dynamic rows). Static rows are basically items that do not change with changing settings like segments, panel filters or time period. For example, when you drag over specific line items of a dimension into free form table, those specific items always get pulled into the table. Other example is the rows that you choose to always return in table using Display only selected rows option.

So what you are seeing is working as designed and if you wish to use dynamic rows and still show the grand total for filtered rows than instead of applying the filter on dimension you need to convert that filter into a segment and apply it either on panel level or on column level in the freeform, above/below the metrics.

Cheers!