Has anyone created a calculated metric to get the weighted average of visit number? It's something I use often when examining customer journey, and I often extract the data to Excel. I'm wondering if it can be done in Workspace to save time.
Here is my issue. I need to multiply the '1 pct of total' metric by the visit number. But, the visit number is a string. Is there a way around that?
I've actually been working on making some weighted metrics in workspace recently, it should be possible with the use of the advanced functions.
There is a function for "column sum" - that will likely be very useful for your weighted metric calculation. For example, a very basic formula, to see how individual items contribute to an entire metric, you can do something like this.
The column sum is great because it adds up all of the rows, and then you can look at an individual rows contribution to the entire sum. The only issue with this is that it doesn't deduplicate data. For example, if I were to use visits instead of page views, it would could all the visits for all the pages in the table, massively inflating the visit count. There might be a way around this by using multiple other functions/calculations, but I haven't solved for it yet.
Like Jen mentioned, if you share the formula you use in excel for your weighted calculations, we can help replicate it in the metric builder.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
