1 of 1 people found this helpful
Could you post a packaged workbook with some sample data? There are several different ways to accomplish what you want in Tableau, but the exact method depends on how your data is organized and how your views are laid out.
For example, if you want to have different KPIs for different measures, you probably won't be able to use Measure Names/Measure Values, since Tableau only allows for one calculated field on the Marks card and that field is not sensitive to exactly which Measure Name/Value is being drawn. Most likely you'll need to use the extra axes technique. I put together a workbook outlining a bunch of different options here:
In the case where you want the KPI to be based on a comparison from one row to the next, the LOOKUP() function is one way to get there, but exactly how it gets used again depends on how your data is set up.
I was actually able to get the view I was trying to accomplish. I did reference the color coding column techniques and used a table calculation (window_max()) to help determine which shape needs to be shown.
It took a lot of work but I was able to do the same to compare by week and by month as well.
Message was edited by: Abigail Bautista added image
tableau dashboard view.png 6.1 KB