Next, we need to create a calculation that will only show the rows within a certain range of the parameter value. But, this shouldn’t be too much of a problem since our parameter will be an action based on the total rows in our (later created) scroll worksheet. Unfortunately, you can’t use the Index field to “Add from Field”. This means that however you sort the view, the Index value for 1 will be the first row in the table.Ĭreate a parameter called “Scroll” with a data type as float and all allowable values. The INDEX() calculation is Tableau’s way of numbering each row in the partition.
Step 1 | IndexĬreate a calculation called “Index”. The basic premise of this concept is that we set up a parameter value and a subsequent calculation that will return only a specified number of rows based on the INDEX() calculation. However, this does work for scrolling through a single sheet as well as multiple sheets given the steps I’ve done below. The disclaimer is, that with some complicated builds or filters, using the INDEX() calc (which this solution uses) may not be effective. So, what’s the solution? Well, parameter actions may be able to help – at least some of the time. Now, even after hiding the headers, you have three separate worksheets that do not scroll together. Here’s a terribly messy example (because that’s what they end up looking like): This becomes even worse when you have multiple sheets that tie back to a single header field. This means, inevitably, I need to introduce scrolling, which I venomently hate on a dashboard. As a data viz consultant, I encounter situations regularly where a client’s wishes, or their data, doesn’t fit neatly into the specified dashboard size.
0 kommentar(er)
