Katerina Kovriga {Stiltsoft} Expert

Hi @Julia Barnard , Maybe this thread gives you a hint - here we are talking about a similar pair of macros coming from the 3rd party app, but the concept seems to be the same https://community.atlassian.com/t5/Confluence-questions/Reporting-of-pages-using-Table-Excerpt-Include/qaq-p/1556626

Maybe the anchor didn't work in the previous link: https://docs.stiltsoft.com/display/TFAC/Custom+Transformation+-+use+cases+with+advanced+SQL+queries#CustomTransformationusecaseswithadvancedSQLqueries-FormattingaheaderofJiraIssue The "Formatting a header of Jira Issue" section is relevant.

Yes, the name is correct and the link given in the first reply is working fine for me. https://marketplace.atlassian.com/apps/27447/table-filter-and-charts-for-confluence?tab=overview&hosting=cloud The app is free for Cloud 1-10 users, otherwise it's a paid one.

Hi @Rachi Manwal , You may check this part of our documentation - the example was done for the Jira Issues table, but it can be manually created table, Page Properties Report macro, etc. as well.

Hi @Rachi Manwal , Another hint from our developers - in the AlaSQL query on which our Table Transformer macro is based, it's INSTR function: SELECT *, INSTR(T1.'String to find',"new") AS 'Position' FROM T1 The output for my example table will be 11 and 16 respectively. Here you may correct the output by +/-1: the indexOf…

Hi @Konstantin Löscher , If you have Confluence Cloud, you insert macros via "/", for Server/Data Center it's "{". If you don't see the Table Excerpt, Table Filter, Pivot Table, etc. macros in the macrobrowser, it means that your company doesn't use the Table Filter and Charts for Confluence app, the add-on is not…

Hi @Haroon Habibi , Are you asking about the Table Filter and Charts for Confluence app (that is our add-on) and its Table Filter macro? If this is the case, you may transfer your Excel sheet to Confluence using the Table from CSV macro or the Table Spreadsheet macro (use its import option). Then you will be able to use…

It couldn't work before: by this configuration you tell the macro to find Excerpts with the name "All Teams" on the pages that contain labels ... and then don't specify the label itself. So go the pages that contain your Excerpts, check what labels they have and enter their names in the field. If you didn't use labels…

Here I see that you choose "Pages with labels", but the field with Page labels is blank - your labels are missing. Seems that somebody deleted them. 

Hi @Eva Kröger , The error points that the Excerpt with such name can't be found on the corresponding pages. Please check if there are no any typos in the Excerpts' names: the names should be equal in the Table Excerpt Include macro and all the Table Excerpt macros that you are trying to collect. Then check the path…

Yes, you are right - it's a bit of JavaScript provided by our developers. The JavaScript methods in general are documented here, but if you have any specific case that is not very common and is not documented, you may raise a support request (the portal is confidential), attach a screenshot of your original table with a…

Hi @Rachi Manwal , Please clarify what app/macro are you using for the case? If we are talking about our Table Filter and Charts for Confluence app and its Table Transformer macro, you may try the following query: SELECT *, T1.'String to find'->indexOf("new") AS 'Position' FROM T1

Hi @Sarah Holdgrafer , Please raise a support request - our portal is based on the Jira Service Desk and it's confidential. Attach a screenshot of your table with the headers visible and describe what exactly you need to get (on what condition to color rows, use alternating colors, etc.). We'll try to guide you through the…

Hi @Young Cho , If your company uses our Table Filter and Charts for Confluence app (it's a 3rd party plugin) and we are talking about Confluence, please note that its Chart from Table macro supports the Jira Issues macro as a source table. It means that you will be able to aggregate your issues with the help of the Pivot…

Hi @Konstantin Löscher , We can suggest trying our Table Filter and Charts for Confluence app: * You may wrap your source table in the Table Excerpt macro and then reuse it wherever you need (any page/space) and as many times as you need via the Table Excerpt Include macro. * The Table Excerpt Include macro can serve as a…

And an update from me - the Table Spreadsheet macro that also belongs to our Table Filter and Charts for Confluence app and is compatible with our other macros can do the trick: go to the Background colors icon -> Alternating colors -> select the required cells' range and the type of formatting. This feature copies the…

Hi @Sarah Holdgrafer , If your company uses the Table Filter and Charts for Confluence app (that is our add-on), note that you can apply conditional formatting via its Table Transformer macro. It is not exactly your case as I see it, but if you already have the app installed for your instance, the coloring based on…

Hi @Adrian M , If we are talking about visualizing/calculating data coming from the Jira Issues macro in Confluence, you may use our Table Filter and Charts for Confluence app and its Chart from Table, Pivot Table and Table Transformer macros. Here are several examples of possible visualizations. The add-on is also…

Hi @maziar ebrahimi , If your company uses our Table Filter and Charts for Confluence app (you may try to find its Table Filter or Pivot Table macros in the macrobrowser to check), you may use the Table Transformer macro to show the current date using the NOW() SQL function. SELECT FORMATDATE(NOW()) AS 'Today is' FROM T*

Hi @Harsh Shridhar , This is me once more time - I've consulted with our developers and understood that I've missed an obvious workaround for your case: please create a sequence "source table <- Table Transformer <- Chart from Table" inside the Table Toolbox macro. Now go to the Table Transformer macro and set the…

Hi @Harsh Shridhar , Unfortunately we don't have such option. You may check how to set colors for the Chart from Table macro in our documentation: select the required chart type in the page tree and navigate to the corresponding section. The conditional formatting is available for tables and supported by the Table…

Hi @Andrew Crile , Unfortunately this ticket is still not implemented, but I've added one more vote (customer request) to it - we'll get to this thread once the feature is released.

Hi @Torkil Johnsen , Thank you for the description of your workaround! But please note that the Table Transformer macro you've kindly mentioned above belongs to the Table Filter and Charts for Confluence app (the plugin is developed and supported by our company). Not to confuse other Community members, the app is not…

Hi @Lynn Crush , We can suggest trying our Table Filter and Charts for Confluence app (the app is developed by our company). You'll be able to export your tables in the CSV format using the Table Filter macro and/or CSV/XLSX formats with the help of the Table Spreadsheet macro.

Hi @Paul Golightly , If you are talking about the Table from CSV macro provided by the Table Filter and Charts for Confluence app, please raise a support ticket - the portal is confidential, attach your CSV file and we'll look into the issue.

Hi @Robin Rast , At the moment it is not possible for the new Cloud editor.

As it's not a fully functional SQL database, some complex combined queries may work unstable. Your idea was right, sorry for the inconvenience.

Please use the two Table Transformers for this table: 1) The internal TT will add a new column with a date that corresponds to the start of the week SELECT *, FORMATDATE(DATEADD(DAY,1-WEEKDAY(NOW()),NOW())) as 'Start of the week' FROM T1 2) The external TT will compare the dates: SELECT T1.'Assigned on Date',…

Hi @Rachi Manwal , As I understand now, you are trying to compare your dates with the today's date plus/minus several days. For example, for this table I need only dates with a red background: today is 28 Sep 2022, so the start date will be 26 Sep 2022. It means that it will be "today - 3 days". Then every day the "today"…

Hi @Ashley Rawlings , It's expected behavior for the macro. If you need to collect multiple-row tables into one combined report, I can suggest trying our app that is Table Filter and Charts for Confluence and its Table Excerpt/Table Excerpt Include macros. Further the report can be filtered, aggregated and visualized using…