I am creating a graphic pagination widget (a widget using shapes rather than a dynamic filter). I've been able to create a functioning widget for a discrete number of pages, however I want it to be dynamic.
For example, if the user filters the data so there are only two pages worth, the user should just see options for Page 1 and Page 2.
I'm using INDEX() to count my rows in my data set, but I can't seem to find a way to say "Hey widget! We only got 7 pages over here! Don't show buttons 8 or greater!"
Thoughts? In my example I've included Index, Page, and Page Max so you can better see how I'm splitting up the pages.
Thank you for your help and suggestions.
Michael Hesser (Tableau Forum Ambassador)
If this response has answered your question, kindly click "Best Answer"
@Michael Hesser (Tableau Forum Ambassador)
Hi, attached you will find a workbook, using the data driven parameter extension an a auxiliary page (maybe can be done without this one). I have also changed the bin calc, the bin size. I am sure you will figure it out. It has some interesting tips!!!
I did not hide the extension objects (height 1, width 1, and put them in some corner) and the new sheet created, but it is something you would do in a production environment
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
