Forum Discussion
Use Calculation in Matrix Total
FYI for anyone reading this. I have solved this by creating three measures:
Total uPVs = SUM('Data'[Unique Pageviews]) Total Conversions = SUM('Data'[Conversions] Conversion Rate_Proper = DIVIDE ([Total Conversions],[Total uPVs])Conversion Rate_Proper then goes into the value field in the matrix.
Works a charm.
Sam
Hi SamBerger ,
Based on your description, it seems like there're three different columns in your table named 'conversions ', 'unique pageviews' and 'Conversion Rate calculation', right? Could you share more details about your raw data and requirement?
Regards,
Jimmy Tao
Hi Jimmy,
Thanks for the reply. Yes, that is correct - see table below. This is the dataset in its entirety.
Date Day of Week Name Unique Pageviews Week Label Date Sorter Conversions Conversion Rate 19/11/2018 Monday 31381.0 Last Week 1 4576 14.6% 20/11/2018 Tuesday 32044.0 Last Week 2 4787 14.9% 21/11/2018 Wednesday 30498.0 Last Week 3 4491 14.7% 22/11/2018 Thursday 29649.0 Last Week 4 4332 14.6% 23/11/2018 Friday 25553.0 Last Week 5 3701 14.5% 24/11/2018 Saturday 15765.0 Last Week 6 2425 15.4% 25/11/2018 Sunday 17179.0 Last Week 7 2639 15.4% 12/11/2018 Monday 32600.0 Week Before 1 4855 14.9% 13/11/2018 Tuesday 31677.0 Week Before 2 4689 14.8% 14/11/2018 Wednesday 29508.0 Week Before 3 4343 14.7% 15/11/2018 Thursday 28203.0 Week Before 4 4167 14.8% 16/11/2018 Friday 24955.0 Week Before 5 3689 14.8% 17/11/2018 Saturday 15794.0 Week Before 6 2355 14.9% 18/11/2018 Sunday 17322.0 Week Before 7 2603 15.0% So in terms of the matrix, Day of Week Name is going in Rows, Week Label in Columns and Conversion Rate (calculated by dividing Converstions into Unique Pageviews) in Values.
In terms of results, the Week Before 'Total' would be 14.83% ( Total Conversion for 'Week Before' = 26701 / Total Unique Pageviews for 'Week Before' = 180059).
Let me know if you need any further info.
Thanks,
Sam
FYI for anyone reading this. I have solved this by creating three measures:
Total uPVs = SUM('Data'[Unique Pageviews]) Total Conversions = SUM('Data'[Conversions] Conversion Rate_Proper = DIVIDE ([Total Conversions],[Total uPVs])Conversion Rate_Proper then goes into the value field in the matrix.
Works a charm.
Sam