All examples in this section use the following dashboard as an illustration:
A WYSIWYG PDF file mirrors what you see when viewing the dashboard in your browser at a width of 1680 pixels. Essentially, the PDF is rendered as WYSIWYG: "what you see is what you get."
To use this format, expand the dashboard's gear menu and select Download as PDF, Send, or Schedule. If you are sending or scheduling the PDF, select PDF next to Format data as. Under Advanced options, you can also customize the appearance of the PDF: size and orientation (Paper Size), whether to print all rows of the data table (Expand tables), and whether the tiles are printed in a single column (Use single column layout). The Paper Size and Expand tables options are addressed in this section, while the Use single column layout format option is covered in greater detail in the final section of this article.
PDFs without Advanced Options
Here is an example of a PDF download with no advanced options applied:
PDFs and the Paper Size Option
The Paper Size advanced option introduces page breaks to format the content appropriately to the paper size and orientation you select. When a Paper Size is specified, Looker determines "rows" of elements that page breaks will form around. Looker does this to avoid inserting page breaks in the middle of visualizations.
When you specify the paper size and orientation, consider element size and dashboard layout. Dashboard tiles may need to be reorganized to accommodate the selected page size and Looker-determined line breaks. For example, page breaks may occur in very tall dashboard elements or in overlapping groups of tiles, producing a garbled PDF.
PDFs and the Expanded Tables Option
The Expand tables advanced option will display all rows of a data table, rather than just the rows visible in the tile thumbnail. When this option is selected, Looker determines groups of elements to break into rows (similar to how it determines page breaks). Then, Looker uses a CSS grid layout to position the groups of elements to accommodate the expansion (see the example below). Expanding the table increases the size of the grid rows, causing the elements around the expanded tables to move along with the expanded table:
A WYSIWYG PNG file should render the same as a WYSIWYG PDF — the only difference is the file format. The Paper Size and Expand tables advanced options are not available for this format.
To select this format, in the Send or Schedule window from the dashboard gear menu, select Visualization from the Format data as options.
PNG format is not available for downloading dashboards — it is available only for sending or scheduling dashboards.
Single Column PDFs
A single column PDF stacks each dashboard tile in a single column. The width of the PDF and dashboard tiles is 800 pixels.
To use this format, expand the dashboard's gear menu and select Download as PDF, Send, or Schedule. If you are sending or scheduling the PDF, select PDF under Format data as, and then select Use single column layout under Advanced options > Format options. If you are downloading the dashboard, select Download as PDF, expand the Advanced options menu, and check Single column format. Here is an example of a dashboard rendered as a single column PDF:
Applying Advanced Options to Single Column PDFs
Applying advanced options (Expand tables or Paper Size) to a single column PDF does not greatly change the result shown above.
Single column PDFs with the Expand tables option applied often render with page breaks in the middle of expanded tables. However, no data should be cut off.
To address unexpected behavior when very wide tables render with cut-off columns, Looker 6.20 introduced a new functionality to scale down tables with a large number of columns to fit within the 800-pixel, single-column rendering. Here is an example of a scaled-down table:
An inline visualization (or inline vis) is a unique rendering type in which each dashboard element is captured individually as a PNG.
To use this format, expand the dashboard's gear menu and select Send or Schedule, and specify Visualization next to Format data as and Use single column layout under Advanced options > Format options.
Here is an example of what to expect with this rendering option: