Do you want the two entries to be combined? As in they are added together or would you like them to show as two different values, but using one calculated field?
For the first scenario, the calculation might look similar to the following:
min([Profit]) + max([Profit])
For the second scenario, in order for them to both show up, the values will need to be turned to strings. Therefore, the calculation may look similar to this:
"$" + str(min(Profit)) + ", $" + str(max(Profit))
Hope this helps a bit!
thanks for this. But what I want is the following:
Assume that I have table that consists of one column called Xall, which has
the following entries:
I want to calculate a field Xcalc that only contains two entries: the minimum AND the
maximum value of Xall, i.e.
Can this be done?
1 of 1 people found this helpful
To show the two values within the same calculation, the formula would need to look similar to the following:
str(window_min(sum([Order Quantity]))) + "; " + str(window_max(sum([Order Quantity])))
The other option would be to create two different calculations:
Since table calculations are being used in these calculations, it may be necessary to right click and select Compute Using-->the appropriate direction.
Hope this helps!
Petty that Tableau does not seem to know array (vector) constructors.