the data structure is making each of the values a separate measure and the resulting % change calculation a separate calculation -
so what to do - either you end up creating a series of separate KPI indicators for each measure or re-structure the data
Typically the way to restructure the dat is by pivoting but in Tableau proper you are limited to 1 pivot per data set - that won't work with your set because you subdivide the measure (eg latency, mbps etc) - Tableau Prep would allow you to make multiple pivots to the same data set -
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Unfortunately, I used a simple data set for the example. I typically have five or six history files per array and then multiple sets by array type. I won't be able to manipulate the data just because of the effort of regularly doing that. Is there anything I can do by color coding or conditional formatting?
Well you would have to work with each of your measures individually - sorry