22

Allow tables to display more than 200 rows

Hi, we have a dashboard that is used for reporting. Its main component is a large table that displays data and images, but it's becoming difficult to run usable reports because of the table size limitations. Being able to display more than 200 rows of a table would be a great addition.

48 comments

  • 2
    Avatar
    Alexander Dich Jensen

    I realise that this thread is rather old, though it doesn't look like it has been solved yet.

    I would like to add my support for this suggestion, as it's very limiting for our reporting. 

    We publish a lot of content, and display performance for this content in various dashboards. Only being able to see 200 pieces of content at a time, especially when users can sort a table differently and see "invisible" data.

  • 6
    Avatar
    Dan Kamins

    To add another voice to this 2+ year old discussion, I just wasted almost an hour debugging a table that my team reported was "missing data":  rebuilding data sources, evaluating partial formulae, correlating with external reports, ... It wasn't until I finally added a column showing just an incrementing row number that I saw Klipfolio was suspiciously stopping at 200 and silently hiding the rest of my data (~50 more rows in this case).

    Regardless of how you feel about whether tables should be limited or not, it is a UI/UX disaster for a reporting tool to silently remove data without giving any warning that such is occurring or worse is even capable of occurring.  In fact the table properties itself has a "Table Rows" configuration parameter which we have set to "Show all rows" (!) -- the opposite of what actually occurs.

    Wasting a bunch of time and ultimately finding this obscure undocumented bug/"feature" as the cause for misrepresented data is actually our first strong negative experience with Klipfolio, which has otherwise been so well conceived and packaged.  I urge Klipfolio to add, at a minimum, either 1) a warning icon on tables with truncated rows to draw attention to this fact, or even more simply, 2) just change the choice label from "Show all rows" to "Show up to 200 rows" to document the limitation clearly at build time.

    Only then should a discussion really even begin about whether or not to support showing more than 200 rows.

  • 3
    Avatar
    Cody Burke

    I also would like to have the option to show more than 200 rows, or at least be alerted to the limitation. My company is making pivot tables around our logs, with filters and date ranges controlling exactly what shows up in the tables. 

    It caused a great deal of confusion and damaged the trust some people have in this software when rows that we could see in SQL were simply disappearing in a klip.

  • 3
    Avatar
    Carlos Kynäslahti

    This is another feature that should be implemented ASAP. Or at least notify the user about having more than 200 rows of data which are not displayed. I spent a bunch of time today figuring out why some of my data was 'missing' while it wasn't just displayed correctly.

     

  • 0
    Avatar
    Hugh Macken

    Just want to add a +1 on this and specifically for the paging or infinite scroll idea mentioned by @Neolab. Something similar to the following would be great.  We can do this in relation to data sources. Seems to me we should also be able to do it in relation to the actual client facing dashboards.

  • 1
    Avatar
    Pena Business Reporting Admin

    I would love to see a "paging" feature that displays "show more" records to the user in a similar manner to how data sources preview the first 250 records in the data source library. I speak on behalf of several clients who have voiced the need to see all data (>200 rows) while also not suffering from a big drop in performance. It seems this approach would work well, but open to other suggestions or ideas.

    Thank you and look forward to hearing updates about the status of this type of feature soon. 

  • 1
    Avatar
    Nick Donaldson

    Hi Scott, 

    Is this feature complete? We have multiple use cases where this will come in handy. 

    Thanks!

    Nick

  • 0
    Avatar
    Hugh Macken

    Just checking in on this again. Infinite scroll button would be the easiest way to implement this.. something similar to the "Show the next 25 elements..." that a user can see when in backend and editing klips.

  • 0
    Avatar
    Scott Lawrence

    Hi Hugh, Cody, and Pena,

    This has also been a recent topic of discussion.  I do not have a specific timeframe for movement yet, however the teams are starting to think about tables and this request is on their radar.

    Will keep you posted on any progress here.

    Cheers,

    Scott.

  • 0
    Avatar
    Jeff Bantz

    Scott -

    Add another user voice to this request. As a new user, I'm perplexed to find that such a simple request has never reached the point of actual implementation. Simply expose the maximum number of rows to display as a Table Property and leave the decision to the customer as to whether the performance is sufficient. Like many, I invested a ton of work on a dashboard only to find much of the detail data missing.

  • 0
    Avatar
    Georgi

    Allowing more than 200 rows is very important in nowadays. Please to consider this features asap.

  • 1
    Avatar
    Javier Hernández Pescador

    We continue without a result for the problem of showing more than 200 rows. We continue to expect a result from 2016.

    I need to show more than 200 rows because I want to be able to show all the elements of a year, and they are usually more than 500
  • 0
    Avatar
    Nick Quinlan

    Hey there! Just adding another request to allow tables to paginate. We're trying to expose a specific set of data to our clients and would like them to be able to see all of it.

  • 0
    Avatar
    Ruben Vieira

    Another user here who would need more than 200 rows in the tables. Infinite scroll or whatever solution you can come up with, I'll take it. Anything is better than nothing at this point.

    Thanks!

  • 0
    Avatar
    Gwen Vito

    Hi - I am still having this problem. My users are complaining there is no way to see a full  year of data. Over the course of this being worked on for apparently 5 years, has there been a solution yet? Thank you.

  • 0
    Avatar
    Dylan Kaufman

    I can't believe people have been asking for this for SIX YEARS and nothing has been done about it.

  • 0
    Avatar
    David Mennie

    The max number of rows displayed in a table Klip can vary based on several factors. Trying it out today, I get a max of 291. We should be able to expand this to 500-1000 in the short term. An infinite scroll would have serious performance concerns as this could be in excess of 100K rows for some customers and implementing full pagination is a much bigger feature.

    We are actually planning some data visualization improvements this quarter - including a focus on tables. We will try to prioritize a quick fix for this as we plan the scope of the work.

  • 0
    Avatar
    Dylan Kaufman

    I had 279 rows of data, and it was not showing them all, so it doesn't seem to be 291. Rather than increasing it to some random number that has to be changed in the Klip code, why don't you add a 2nd option next to the "show at most ___ rows" option in the Table properties?  If you want to put an upper limit of 50k or 100k rows on that, I don't see a problem with it, but the fact that we can't easily go in and change it on Table properties to something reasonable for our use case is silly.

Please sign in to leave a comment.