Hi Forum,
My question is on emailing and downloading pdfs with pivot tables from dashboards. If a dashboard includes a pivot table, not all columns or rows are shown in the PDF or email. They become cut off.
Unfortunately the pivot table is needed. It is the best way to show all the information for a specific audience.
We can manually create a pdf with all columns if we download from a widget, but we want this to be automated and emailed, which you can not do from a widget.
Is there anything we can do? We have tried changing the PDF to A3, extending rows to 200,
We are on Tessitura Analytics version 15.0.3
Thank you,
Siorna and the Ticketing team!!!
Hi Siorna,
Have you already narrowed your column width as much as possible in the widget editor? Also, do you know how to edit the PDF formatting in Analytics before scheduling it? I've had success with changing the format to Landscape, getting rid of as much extraneous detail as possible (Dataset name, data as-of etc), and making the columns narrower to start off with. (Here's the PDF formatting I'm talking about:
Hope that's helpful! And if you've already tried all of this, the only other thing I can think of it's maybe finding a way to split out the pivot table into multiple widgets with filters that would essentially allow you to have multiple "pages" of the pivot table (each "page" being a separate widget would allow you to have them on separate pages of the PDF) so that you can display all the rows. If the issue is too many rows rather than too many columns I doubt the edits above will help very much!
Sarah Covie
PortTIX, LLC. | Database Manager | 20 Myrtle Street, Portland, ME 04101 | 207-842-0800 | www.porttix.com
Siorna,
I had the same issue as my VP wants a passive amount of data emailed to her daily as a PDF. The way I got around it was to do exactly what Sarah illustrates. I broke our entire season into multiple widgets that represented months and then made sure the concerts were listed chronologically. I had to expand to legal and reduce the column headers with wrap-text, then play around with it in PDF edit mode. See dash and PDF files attached. I hope that helps.
Best,
MichaelKBSalesReport.dashKB Sales Report 12-18-19.pdf