2 of 2 people found this helpful
Good morning Bernard
This would be a best guess - it would be easier if you would share your workbook as a twbx file
There is a basic different between Tableau and spreadsheet based analytics like excel - tableau is a data based processor that creates an underlying table based on the dimensions and measures you place in your viz - that said when you make a Calculated Field a column is added to that table with the results of that calculation - that column is dynamic in the sense that as you change make a change to a field in the calculation the column (and table update)
OK - so what - in your case you need to create a calculation for Base Fee > [Parameter Base Fee]
and a second for Price Increased > [current price] * [parameter for price increase]
Then you would do an If statement for New Revenue > IF sum([Price Increase] > avg([Base Fee)] Then sum([Price Increase)] else Avg([Base Fee)] end
Then drag New Revenue to the canvas -
you can do it by month by setting up the dimension on your view to show months -
This should get you started - Let me know if this helps
Jim and All,
Attached is a copy of my workbook.
I am trying to do something that I thought would be easy which is to take
the maximum of either the base monthly fee or the # of orders charged x
price to get the revenue for this field.
I narrowed down my data to only 5-6 rows to test it.
The numbers in the table change, but the totals at the bottom seem to stick
on the wrong values.
Thanks in advance for your help.
On Sat, Apr 8, 2017 at 7:41 AM, Jim Dehner <email@example.com>
Distribution Analysis.twbx 17.0 MB