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
Table row comparison in percentage (not total)
I want to make a percentage comparison between two rows of a one-column table. From the x page views of the landing page, how it compare to the page view of the last page of the journey. However, I need the table to consider the first row as 100% but now it shows the % of the total page views (both rows together).
Is there a way for me to consider the first row as 100%? Or a Calculated metric I could use?
thanks
1 Accepted Solution
Correct answer by
I don't think you can do that in this way.. but there may be options...
If you are always looking at the same 2 pages, I would suggest making them columns. So keep your metric at the top, then add your pages as subs of the metric.. then you can create a calculated metric between the 2 columns (hide the % on the pages and rely only on the calculated metric which is now column 3)
Of course, this only works if you are always looking at the same specific pages.....
However, you could also consider a fallout chart? This will show all the steps, and calculate the % of continuation/fallout for each step... (this will also be more "direct" looking specifically at users who actually went to the first page, then the second page in that order). You can remove the "all visits/all visitors" top row, you don't need to leave it there (since you may only have a small subset of users coming to this flow)
Correct answer by
I don't think you can do that in this way.. but there may be options...
If you are always looking at the same 2 pages, I would suggest making them columns. So keep your metric at the top, then add your pages as subs of the metric.. then you can create a calculated metric between the 2 columns (hide the % on the pages and rely only on the calculated metric which is now column 3)
Of course, this only works if you are always looking at the same specific pages.....
However, you could also consider a fallout chart? This will show all the steps, and calculate the % of continuation/fallout for each step... (this will also be more "direct" looking specifically at users who actually went to the first page, then the second page in that order). You can remove the "all visits/all visitors" top row, you don't need to leave it there (since you may only have a small subset of users coming to this flow)
Thank you so much!
I thought about something similar however my cia´s analytics subscription only includes metrics for the calculated metric part. it doesn't allow me to use specific URLs there.
Also, I already tried the fallout and I´ve two issues.. First is that the numbers don´t match with what I´m getting from the table (image below)
and second, one of my goals is to create a summary number with the % I get from the last URL. And I cannot get the summary number for the last line of the fallout, or can I?
