Not perfect yet.... but find my approach as reference below and stored in attached workbook version 9.3
if attr([Factor])="Bounce Rate" then mid(str(sum([Actual]*100)),1,5)+"%"
elseif attr([Factor])="# of transactions" then STR(sum([Actual])) end
First draft.twbx 37.9 KB
Many thanks for taking the time to do that up.
I can see it does show both factors required in the calculation. Is there any way to set this up that it completes the calculation itself in the calculated field?
Not sure if I understand your question. Could you elaborate?
No problem Norbert, thanks.
In your calculated field you see both the number of transactions and the bounce rate in the table.
However, would I would like to see as a result of the calculated field is:
# of transactions / number of visitors
i.e. I would like to see the calculation/result rather than the two individual components side by side.
Effectively yes. The only difference being I'll be dividing by Visitors rather than multiplying by the Bounce rate, but that is a moot point, the key is being able to make the calculations between different responses under the same dimension.
How did you do that?
You the man! This worked perfectly.
Thank you so much for your tenacity and helpfulness on this, it's really appreciated.
1 of 1 people found this helpful
You are welcome. Once again...Thanks for the "points". Appreciated.
Keep posting on the forum concerning your challenges. There a lot "peaps" around willing to help.
Have a nice one.