• Replies 5 replies
  • Subscribers 961 subscribers
  • Views 402 views
  • Users 0 members are here
Related

Pivot table pdf nightmare

Former Member
Former Member $organization

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!!! 

Parents
  • $organization

    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

Reply
  • $organization

    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

Children