How do I limit the number of rows/records the visual shows but download more rows via csv?

There are several places to set limits on the result set of a visual.

  • If you are using a tabular visual there is an automatic limit of 100 rows applied when rendering (option A)
  • Other chart types (lines, bars, etc) , do not have a limit shelf like tabular visual, instead they are controlled by 5000 default limit as shown by option B
  • Both option A & B mainly control how many rows the browser displays. It also applies to CSV downloads. But if you want to download more rows via CSV then option C provides a setting for that. It only applies to CSV download.

1 Like