
1. Re: Sum of Specific Dimension / Sum of Another
Norbert Maijoor Jan 10, 2017 2:32 PM (in response to Eoghan Lyons)Hi Eoghan,
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


2. Re: Sum of Specific Dimension / Sum of Another
Eoghan Lyons Jan 13, 2017 1:59 PM (in response to Norbert Maijoor)Hi Norbert,
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?

3. Re: Sum of Specific Dimension / Sum of Another
Norbert Maijoor Jan 13, 2017 2:31 PM (in response to Eoghan Lyons)Hi Eoghan,
Not sure if I understand your question. Could you elaborate?

4. Re: Sum of Specific Dimension / Sum of Another
Eoghan Lyons Jan 13, 2017 2:55 PM (in response to Norbert Maijoor)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.

5. Re: Sum of Specific Dimension / Sum of Another
Norbert Maijoor Jan 14, 2017 1:18 AM (in response to Eoghan Lyons)Good morning Eoghan,
Find my approach based on your explanation. Is this the directions you would like to go for?

First draft 2.twbx 61.5 KB


6. Re: Sum of Specific Dimension / Sum of Another
Eoghan Lyons Jan 14, 2017 6:14 AM (in response to Norbert Maijoor)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?

7. Re: Sum of Specific Dimension / Sum of Another
Norbert Maijoor Jan 14, 2017 10:15 AM (in response to Eoghan Lyons)1 of 1 people found this helpfulGood evening Eoghan,
The following:
Bounce Rate: if [Factor]="Bounce rate" then [Actual] END
# of Transactions: if [Factor]="# of transactions" then [Actual] end
# of transactions * Bounce Rate: sum([# of transactons])*sum([Bounce Rate])

8. Re: Sum of Specific Dimension / Sum of Another
Eoghan Lyons Jan 14, 2017 2:23 PM (in response to Norbert Maijoor)Norbert,
You the man! This worked perfectly.
Thank you so much for your tenacity and helpfulness on this, it's really appreciated.
Eoghan.

9. Re: Sum of Specific Dimension / Sum of Another
Norbert Maijoor Jan 14, 2017 2:28 PM (in response to Eoghan Lyons)1 of 1 people found this helpfulEoghan,
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.