Is there a way to calculate Row value with Column Value

Question

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.

MandyGeorge · Accepted Answer

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 · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO