Skip to main content

I would like to include the minimum order date among the various measurements as illustrated in the following example. Obviously, among the size names I cannot select the minimum order date:

9 respuestas
  1. 26 feb 2024, 18:15

    Hi @Jane Smith​ and welcome to the forums.

    Sorry that this is your first question, because Tableau isn't designed to display tables to the degree that a spreadsheet application is, and you're not going to like the answer. In simple terms, Tableau will not allow non-Measures to the right of Measures in a table. There are a couple of ways around this, the main one being the placeholder method. If you search online for "Tableau Conditional Formatted Table", you will get lots of results. It's not conditional formatting you want (yet), but the way of getting your date where you want it would be the same method as those solutions offer - using a MIN(1) pill for each column, and then labelling that "chart" with whatever text you want. Your layout will end up looking something like this (I've only finished the first column, because this method is tedious).

    Hi @Jane Smith​ and welcome to the forums.There is another method, utilising a small scaffold table to determine the columns and their order. This method also isn't perfect, as all values have to be converted to strings. That can bring with it some fun number conversion idiosyncrasies that computers have (of if you want commas in your thousands, etc.).

    Anyway, there are pros and cons to each, which you will discover for yourself. I've attached both of those methods with your example data.

0/9000