AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Tableau tabular report9/28/2023 ![]() ![]() However, the only axis we can rename is at the bottom. Now we want to label this column as our “Profit” column. Once you’ve created a calculated field for AVG(0), drag it onto your columns and you end up with something like this: You do this by dragging an aggregate measure onto the columns shelf that will be the same for all of the items in your dimension. STILL not what we want! Okay this is the golden piece – if you want Tableau to draw your values in a straight horizontal line, you have to force it. In order to force Tableau to draw text rather than bars, you can change the mark type to text and drag your metric into the view: Thank you Tableau, but that’s not what we want. In this case, it has seen you are trying to display a metric based on a dimension and it has decided the best way to do that is create a bar chart. What Tableau is doing is what it’s supposed to do – build a visualisation based on best practices. Because we’re creating a dual axis table, we need to put the metric in our columns shelf: The first thing to do when building a dual axis table is build your first metric with its highlight values. Instead, what we are trying to do is highlight figures based on different calculations for each metric. This table is only highlighting values where profit was less than 0, and highlighting subsequent profit ratio and sales figures. But you would end up with something like this: If you were doing one table with one highlight calculation, you could use a shared axes table and just drag your highlight calculation to colour. Essentially by colouring your table, you have one chart type that is text-based showing your figures, and another one that is colour-based showing your different highlight formulas. This is because, as I mentioned in my Apples and Oranges post, shared axes don’t allow you to have two different chart types in the same axis. In order to create this, we cannot use a table created with shared axes. Profit < 0), which subcategories have a total sales figure below $100,000, and which subcategories have a negative profit ratio. Great! But what if we wanted to add some colour? Maybe we want to highlight some figures on our table, like which subcategories are unprofitable (i.e. It’s as simple as a few double clicks:īy first double clicking a dimension and then our measures, Tableau automatically creates shared axes that generate a table. Let’s say we’ve got our trusty superstore sales and we want to give our basic black-and-white excel table. But it’s something people ask for often, and its something that Tableau can definitely do. EVERYTHING we’ve been doing at the Data School for the last few months *wink* *wink*). Tables have their time and place, but there are often better ways of presenting data to gain valuable insight (e.g. Tables are something that people often ask of data analysts, mostly because its something they’ve gotten used to over the years using Excel spreadsheets. ![]()
0 Comments
Read More
Leave a Reply. |