Level 2

Question

How do I display 3 freeform tables-worth of data within one bar chart to compare each freeform table's data?

Forum|Forum|1 year ago
July 5, 2024
2 replies
1496 views

I was wondering how to make a bar chart comparing data from 3 different freeform tables (each modeling a different section within 3 different websites)? Each freeform table has Site Section with page name as a breakdown (these are the dimensions). For my column of metrics, I have a custom date range and am tracking visits.

I want to display the breakdown of visits for these 3 different website sections in a bar chart and also display the amount of views combined across all 3. To display the breakdown, I have been trying to make the results from each freeform table into a segment and then pulling the 3 segments into another table to visualize. However, I can only select one-page worth of data results to pull into a segment (some of my freeform data results have 1,111 results and I can't find a way to include all of these results in the segments).

Do you know how to fix this or if there is an easier way to do this? (create segments for each of my 3 freeform tables to visualize each of their data side by side in a bar chart? And also add up the total visits across each freeform table within that bar chart?)

Analytics

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Jennifer_Dungan

Community Advisor and Adobe Champion

Hi,

Maybe I am not fully understanding, but if you can have your data in separate tables without issues, why is creating segments to show the data in a single table to graph together causing an issue?

Your graph isn't going to show all the individual pages, so the combined table doesn't have to be as detailed as your individual tables, you can even hide the "combined table" that drives the visualization...

A

AudreyBr2Author

Level 2

Oh, I was able to figure it out! I was having issues because you can't use all results from a freeform table to create a segment as you can only see up to 400 results at a time and that's the max amount of data that could be included in your segment. I had wanted to create a segment from the freeform table.

I created a custom segment using the same advanced filters I had used to get data in the freeform table and it worked great.

Jennifer_Dungan

Community Advisor and Adobe Champion

That makes sense... I rarely use that create segment option (mostly cause I don't want a bunch of ultra-specific segments clogging up my components list, lol)

I mostly create my own custom ad hoc segments.

Glad you figured it out!

bjoern__koth

Community Advisor and Adobe Champion

To be honest, I don't think you can do that in a single visualization (at least the sums will be a problem).

Question: are we talking about the "channel" dimension here or how do you define your site sections?

That might be the simplest way to visualize the data. Else, you may want to use classification rules or a custom value in an eVar/prop you can leverage.

For the aggregated values, you will likely still have to do a separate visualization like a summary number on the table headers?

The breakdowns by individual pages in these section I would leave aside for the moment, else it will get very messy, very quickly.

Cheers from Switzerland!

A

AudreyBr2Author

Level 2

I see- but would there be a way to add up the 1.27M and 7.92M in a seperate box?

Jennifer_Dungan

Community Advisor and Adobe Champion

Well, in Bjoern's case, one of those is Visits, the other is Page Views, so you likely wouldn't add those together... but if you are looking at the same metric (like in my example), I would create a "combined" segment, that pulls the total for all together... then I would either create a "Total" column, or if I just needed a Summary block, I would use the combined segment in a hidden table, and just show the summary.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded