# Trying to build traffic funnel reports **URL:** \ **Category:** Ask the Community\ **Tags:** visualizations, dashboard\ **Created:** [November 25, 2022, 5:36pm UTC](https://community.holistics.io/t/trying-to-build-traffic-funnel-reports/1311 "2022-11-25T17:36:51Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![michael.mccann](https://community.holistics.io/user_avatar/community.holistics.io/michael.mccann/32/668_2.png) [@michael.mccann](https://community.holistics.io/u/michael.mccann)\ **Post date:** [November 25, 2022, 5:36pm UTC](https://community.holistics.io/t/trying-to-build-traffic-funnel-reports/1311/1 "2022-11-25T17:36:51Z")
![image](https://community.holistics.io/uploads/default/original/1X/8a73e9664a496b1fb628fe2c72c7747e0fd188a2.png) Hey guys, I am trying to build traffic funnel reports. As you can see from the picture I have built one chart that has our different funnel stages listed in the rows and then the number of leads reaching each stage of the funnel as the chart values. There is also a column for each different facebook ad that we are measuring. This is how I want that report to look and I did this using a pivot table quite easily. Now beneath that, I am looking to measure the ratios of those figures _ **but I want the table to vertical just like the one above.** _ I have had to create custom measures to build the metrics but i can’t put them as rows in the table - this means I haven’t been able to build a vertical report. Does anyone know how this can be done? Does anyone have any examples of any similar reports built nicely using holistics? I hope all that makes sense. Many thanks, Michael ---
**Author:** ![datbth](https://community.holistics.io/user_avatar/community.holistics.io/datbth/32/1414_2.png) [@datbth](https://community.holistics.io/u/datbth)\ **Post date:** [November 28, 2022, 4:49am UTC](https://community.holistics.io/t/trying-to-build-traffic-funnel-reports/1311/2 "2022-11-28T04:49:35Z")
Hi Michael, Thank you for posting your question! Could you take a look and confirm that this is what your desired report looks like? ![image](https://community.holistics.io/uploads/default/original/1X/abafa47ba8d342f6ea3ca44a42648b8a944c594e.png) > **[c1311](https://docs.google.com/spreadsheets/d/1sYZvBJLHWJPtBs5ZUolzeceaKHTxLR2z9PQbKtlDXv4/edit?usp=sharing)** > > This Sheet is private Also, could you share the formulas of your custom measures? Best, Dat ---
**Author:** ![michael.mccann](https://community.holistics.io/user_avatar/community.holistics.io/michael.mccann/32/668_2.png) [@michael.mccann](https://community.holistics.io/u/michael.mccann)\ **Post date:** [November 28, 2022, 8:48am UTC](https://community.holistics.io/t/trying-to-build-traffic-funnel-reports/1311/3 "2022-11-28T08:48:30Z")
hey Dat - yes, this is the kind of report I want to see! The formula is the proportion of people that pass on from one stage to the next in the funnel. For example, checkout from plans page CTR, is (number of people who reach checkout) / (number of people of reach the plans page). Hope that makes sense. Thank you for the quick response!! ---
**Author:** ![michael.mccann](https://community.holistics.io/user_avatar/community.holistics.io/michael.mccann/32/668_2.png) [@michael.mccann](https://community.holistics.io/u/michael.mccann)\ **Post date:** [December 13, 2022, 10:37am UTC](https://community.holistics.io/t/trying-to-build-traffic-funnel-reports/1311/4 "2022-12-13T10:37:53Z")
hi Dat, did my response make sense to you? ---
**Author:** ![di.hoang](https://community.holistics.io/user_avatar/community.holistics.io/di.hoang/32/421_2.png) [@di.hoang](https://community.holistics.io/u/di.hoang)\ **Post date:** [December 14, 2022, 9:09am UTC](https://community.holistics.io/t/trying-to-build-traffic-funnel-reports/1311/5 "2022-12-14T09:09:03Z")
Hi @michael.mccann Thanks for your sharing. We really appreciate it! At the moment, I’m afraid that there is no perfect solution for your case, except for using Transform model. In the near future, if we support [the ability to swap the table columns and rows](https://community2.holistics.io/t/transpose-between-columns-and-rows-in-table-pivot-table/1026), I believe it can help solve the issue 😃 ---
**Author:** ![di.hoang](https://community.holistics.io/user_avatar/community.holistics.io/di.hoang/32/421_2.png) [@di.hoang](https://community.holistics.io/u/di.hoang)\ **Post date:** [March 17, 2025, 2:25am UTC](https://community.holistics.io/t/trying-to-build-traffic-funnel-reports/1311/6 "2025-03-17T02:25:21Z")
Hi @michael.mccann, We’re excited to share that you now **can display metrics as rows in your pivot table** 🎉 For detail, please visit our community post here: [[Launched] Show metrics as rows in Pivot Table](https://community2.holistics.io/t/launched-show-metrics-as-rows-in-pivot-table/2411) We look forward to your feedback once you’ve had a chance to try it! 😊