Dear all,
I have a table such this:
codesignaloperationvalue335145PQF_J6_SF_DPMean39,90335145PQF_J6_SF_DPMax183,63335146PQF_J1_SF_DPMax2180,82335146PQF_J1_SF_DPMean2013,08
I would like to add the two new rows listed hereafter:
335145PQF_J6_SF_DPPerc183.63 / 39.90 * 100335145PQF_J6_SF_DPPerc2180.82 / 2013.08 * 100
Is there any way to do it in Tableau?
Thanks all!
- Vincenzo
Vincenzo,
The reason that is not working is that your third calculation is a row-level calculation. That means that it is calculated for each row of data from the source. But if you look at the source data, either Max or Mean is NULL in each row, so Max / Mean will always be NULL (see image below).
Do you have any ability to "re-shape" the data at the source level and get Max and Mean in the same row (for each code / signal)? Then it would be very easy to do what you want.
If that's not possible, You could do an aggregated calculation: MIN(Max_Comp) / MIN(Mean_Comp)
However, there are some limitations:
1. You won't be able to create ad-hoc bins (you could do a calculated bin)
2. You will have to make sure your view is at the level of code and signal (meaning that those two fields will have to be present in the view on Rows, Columns, Color, Level of Detail, etc... to define that as the level of aggregation.)
I'm guessing that those limitations (which also exist for the original table calculation solution) will mean that it is not really going to be a good, viable solution. So, if there is any way to re-shape the data and get Max and Mean in the same row, that really will be best.
Regards,
Joshua
