-
1. Re: Calculated constant
Joe OppeltSep 27, 2016 12:56 PM (in response to Steffen Nielsen)
You don't need a new data source. LODs or Table Calcs will take care of this.
Post a sample packaged workbook. Specify the version of Tableau you are on. A concrete example will give you a concrete example solution!
-
2. Re: Calculated constant
Steffen Nielsen Sep 27, 2016 1:42 PM (in response to Steffen Nielsen)See attached example of what I am trying to do.
I am on Tableau 10.0
-
Example2.twbx 31.6 KB
-
-
3. Re: Calculated constant
Joe OppeltSep 27, 2016 2:28 PM (in response to Steffen Nielsen)
In the attached I created the numbers using table calcs in the "Include Color" sheet. I just threw the values onto the text shelf... They appear for all rows (if there is data there).
For the record, I added an extra function into the process. You can pick which color you want to do the calcs for.In the "Cost/Income..." sheet I used LODs to grab the green data, and a table calc to compute the final result. You can discard [Calc1] and [Calc2] from the viz. I just left them on there for demonstration purposes.
-
Example2 A.twbx 43.5 KB
-
-
4. Re: Calculated constant
Steffen Nielsen Sep 28, 2016 11:31 AM (in response to Joe Oppelt)Thank you so much - this works like a charm :-)