Level 2

Solved

Is there a way to calculate Row value with Column Value

4 replies
921 views
Translate All

Hi, Is there a way where I can multiply the row values with Column Value (no. of UVs) for the following table in the work space.

For Eg., For row 1, I would like to calculate 1 * 121 = 121 , 2*28=56 ... and so on.

Thanks in Advance.

Analytics

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

MandyGeorgeAccepted solution

Adobe Champion, Community Advisor, UG Leader

There's no way to do this in workspace. Like @bjoern__koth said, one is a dimension, and the other is a metric. Dimensions are string values, so even if they are numbers, they aren't treated like numbers, they're treated like text.

If you use report builder though, this would be possible. Since the report builder is in Excel, you can build the table pulling data from Adobe directly in Excel and then have another column with a formula that multiplies the two values. Depending on what you're doing with the data, this might be a good alternative.

bjoern-koth

Adobe Employee

Hi @prashatwinkle

that is not possible. The dimension values (rows) are considered to be strings and the metric values (columns) are th actual numbers.
So, since these are different data types, it's not possible imho.

You can only create calculated metrics based on several column values only

Translate

Cheers from Switzerland!

MandyGeorge

Accepted solution

Adobe Champion, Community Advisor, UG Leader

There's no way to do this in workspace. Like @bjoern__koth said, one is a dimension, and the other is a metric. Dimensions are string values, so even if they are numbers, they aren't treated like numbers, they're treated like text.

If you use report builder though, this would be possible. Since the report builder is in Excel, you can build the table pulling data from Adobe directly in Excel and then have another column with a formula that multiplies the two values. Depending on what you're doing with the data, this might be a good alternative.

Translate

Jennifer_Dungan

Adobe Champion and Community Advisor

Yes, I second the Report Builder option if you need to use the value of the dimension as a number and not text... you will also likely have to use Excel formulas to convert the text to number.. I don't believe that you will be able to multiply it directly from the report builder data, as I believe it will be cast specifically as text... or it might work immediately.. I am not sure, I haven't specifically tried... but I know that with dates stored as text, I have had to add functions to cast as date.

Translate

bjoern-koth

Adobe Employee

Hi @prashatwinkle

if you are using custom events for the column column values, you can alternatively also give these events a value that is set to the same as your dimension contains.

For instance:

you want to track the dimension prop99 which contains the value "99" in your example
your imaginary column metric could be event11 which normally would just be an increment of 1 every time the event is counted
now, you could also assign your value of 99 to event11 instead

// directly
s.events = ",event11=99";

// or dynamically using the prop value
s.events = ",event11=" + s.prop99

this could also do the trick, with every occurrence of event11 it will be incremented in steps of 99 now

Translate

Cheers from Switzerland!

Sign up

Login with SSO

Login to the community

Login with SSO