Marketing Channels & Visualizations

[rebeccaqui]

Hi! I am working on dashboards for my marketing organization. I run into issues while creating different visualizations based on marketing channel data. For example, in the below donut chart, Natural Search is blue due to it having the highest volume of visits. However, when I create a bar chart that shows visits x channel x month, Direct is blue because of how the freeform table has to be set up for that specific visualization. This can be pretty confusing for my team members who use this reporting. Is there a way to lock the order of these channels so that no matter what page/date range users are looking at the marketing channel legends stay aligned?

[MandyGeorge]

Typically, the visualizations take colour the items in the same order. Are your two visualizations pulling from different tables that have the items in a different order? You should be able to sort the items in your table(s) so that they're the same order, and then build the visualizations.

[Jennifer_Dungan]

Sadly, no, there is no way to control this...

The colours are chosen in the order of the colour scale for your report... 

Your Stacked Bar will show in the order of the columns, whereas Donut will always re-order items based on the values...

You could potentially cheat, and try to make the columns in your table scale from highest to lowest (to make the report today work); but if values shift over time, then colours will get out of sync again... 

I feel that trying to manage the orders every time your run the report isn't going to be sustainable... and then you will have the other issue which is your columns change order for every report....

Unfortunately, this is an issue I have too... but there's no solution at this point.. short of taking the data out of Adobe and bringing it into a tool where you can granularly control the colours for each visualization (possibly using Report Builder and Excel)