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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |