Table Transformer preview shows good data, but fails when viewing Confluence Page

[Scott Gillespie]

I have a Confluence page used as a dashboard that pulls multiple pages across multiple spaces to summarize sprint delivery metrics.  The dashboard uses a series of macros including Table Transformer, and the individual sprint pages also have a series of macros including Table Filter.

In the dashboard, when in Edit mode, if I open the top-most macro (Table Transformer) and preview the results, they appear correctly. 

However, when in View mode, some of the data disappears and the calculated "Sprint Delivery %" shows as NaN%.

What could be causing this to happen?  One thing that may be at work is that during the Table Transformer preview, or when updating the Page to View mode, I see these messages below ("Set the maximum number of rows to display..."), but they go away when the data is displayed, and at least in the Transformer preview, the data ends up appearing correctly.

Do those messages refer to the "Number of rows per page" setting in Table Filter.  If so, those macros are all in the individual sprint pages, but that setting was left blank.  I even set a value of 100 for my test pages, but that didn't change the behavior described above.

In any case, please advise, as I'm at my wits end trying to understand the source of this problem.  All the individual sprint pages have the same set of macros, when tested individually, they all work.  Only when I'm trying to consolidate multiple pages do I get this result.

[Stiltsoft support · Accepted solution]

Hi @Scott Gillespie ,

At first, as you are on Server/Data Center judging by the tags, check the version of the Table Filter and Charts for Confluence app, so that we will be "on the same page" with you. The current one is 9.9.3, please update if required.

Then go to the Table Filter macros and delete anything that you've set in the "Number of rows per page" field: this setting is not connected with the messages that you see. So, if you don't need pagination, it is better to leave the field as it is by default.

The different result in the preview and view mode of the master Table Transformer macro can be caused by some inconsistency of the source data. You may check every source table on every step of your hierarchy: somewhere on the source page there may be a table where preview and view are different (empty cells in the view mode). It is necessary to find where.

If to talk about your master page, you may check your Excerpt Include macros: do they pull correct data? Maybe they pull smth else that is outdated but has the suitable label?

As I see several Table Transformer macros inside the top Table Transformer macro, you may choose to "Show all content" and see what tables were really pulled to the master pages (if they have empty cells or no, if yes - the issue lies on the source pages then).

And for the top Table Transformer macro (or other macros) that has several tables inside its body, you may check the sequence of the source tables - are you calling them correctly inside your SQL?

If nothing helps, you may refer to our support. Attach the screenshots of every Jira Issues macro that you use (in a published state without any other macros, with visible headers) and the page storage format of every page containing the Table Excerpts and of your master page as well. We'll recreate your pages (the Jira Issues macros won't be recreated, so we need these screenshots) and go step-by-step to check everything as I've described earlier.