Trying to put a Velocity chart in confluence page but the SQL query returns 0 rows

[Rama]

I'm trying to create velocity chart in confluence page as instructed in the below page:

Calculating Velocity - StiltSoft Docs - Table Filter and Charts for Confluence

But in the table transformer, SQL query returns 0 rows. Not sure what i'm missing. Can someone help.

@Katerina Kovriga _Stiltsoft_ 

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

Please raise a support ticket.

As you have Server/Data Center, attach the page storage format (upper right corner - menu ... - View Storage Format). If you don't see the option, ask your Confluence administrator to do it for you.

Then we'll be able to recreate your macros, their settings and queries.

The Jira Issues macro won't be recreated, so please attach the screenshot of its output in the page view mode.

[Rama]

@Katerina Kovriga _Stiltsoft_ thank you, I've raised the support ticket.

[Mike Bernards]

Hi @Rama and @Katerina Kovriga _Stiltsoft_ ,

Running across this same issue and response.  Was there a cause and/or resolution that can be shared here?

Imagining others will similarly wish to publish velocity charts in Confluence :) 

Thank you

[Stiltsoft support]

Hi @Mike Bernards ,

Please check the output of the Pivot Table macro - do you see the proper table in the macro preview?

If everything looks good, please check how the columns coming from the Pivot Table macro are named and if they correspond the names used in the Table Transformer macro. For example, in the docs we have the TT1.'Sum of something' names and your pivot table may return simplified names TT1.'Something'.

If the issue persists, please turn to our support using the link above.