Katerina Kovriga {Stiltsoft} Expert

Yes, you are right - the main question is where the user wants to keep his/her data. Our workaround is oriented more to keep everything in one place (that is Confluence) and to use the Excel functionality right in Confluence.

Hi @Rik de Valk _Brainboss_ , The Table Spreadsheet macro allows you to upload existing .xlsx/.csv file to your Confluence instance and/or create a new spreadsheet from the draft. This spreadsheet has all the Excel features (cell formulas, pivot tables, conditional formatting, etc.) and you will be able to edit it from the…

Hi @Vinod , We can also suggest trying our app that is Table Filter and Charts for Confluence. Please check the Table Spreadsheet macro - seems it should cover your case. 

Hi @Jignesh Patel , The JOIN function can be unstable working with several internal SELECTs. We have this improvement on our roadmap, I've linked this question to the ticket to notify you later. As for now you may use the following structure (don't forget to use the Table Toolbox macro to nest macros if your hosting is…

Hi @Samata Sabala, Please try the following SQL query: SELECT T1.'Key', SUM(IF(T1.'Team/s' IS NULL, 1, 0)) AS 'Unassigned Team/s', SUM(IF(T1.'Fix Version/s' IS NULL, 1, 0)) AS 'Unassigned Fix Version/s' FROM T1 GROUP BY T1.'Key' Hope this helps your case. UPD. Forgot about the "Objective" column: add it to the query if you…

Hi @Katrina Atkinson , If your company uses our Table Filter and Charts for Confluence app, you may set the required cell width with the help of the Table Transformer macro.

Hi @Kirsten_Wakefield , If you are talking about this Table Spreadsheet macro, then it comes from our app that is Table Filter and Charts for Confluence. The add-on should be installed from the Atlassian Marketplace by your Confluence administrator. As the app provides plenty of different macros, it's a paid one but you'll…

Hi Chris, Note that we do have a pagination feature - it is placed inside the Table Filter macro. So you may have the following sequence: source table <- Table Transformer (for transformation/formatting) <- Table Filter (for pagination, you may also hide the filtering options if you don't need to filter this table). 

Hi @[deleted] , You may try our Table Filter and Charts for Confluence app and its Table Transformer macro to show such macros in a "more tabular" way: Here you don't need to change anything and just leave the default SQL query "SELECT * FROM T*". And here is how your Jira Issues table will be looking after the page is…

Hi @Mike Elliott , Maybe our Table Filter and Charts for Confluence app can help your issue. For example, you'll be able to achieve the following case with the help of our add-on: * place your source table with data in the Table Excerpt macro * reuse this table wherever you need with the help of the Table Excerpt Include…

I'm afraid this is not possible within the SQL query: at this stage the macro "sees" the source table as a mini database, so its headers are considered as crucial points and can't be removed. The option to show the result as plain text corrects the macro output if the result table is a one-cell table automatically. This…

Hi @Ann King , If you use our Table Filter and Charts for Confluence app in you company, you may set the default sorting for the Two Dimensional Jira Chart with the help of the Table Filter macro: Note that the "Total Unique Issues:" row can be also hidden by the Table Filter macro if required.

Hi @Toïtiane SAFEL , Though you didn't specify the type of your hosting, I suppose that it's Cloud - its new editor is based on iFrames, so there can be difficulties with the macros' results export indeed. You also didn't specify which macros you use to create your graphs (standard Chart macro, 3rd party macros, etc.). If…

Hi @Lisset Salazar, Thanks for noticing: indeed the behavior of the =DATE() function is not correct. We've created a ticket for the developers and attached this question to it, so I'll be able to return here after the fix-release and notify you shortly.

Hi guys! I'm here to tell you about our new program for customers - I've noticed that you often ask questions about our Table Filter and Charts for Confluence app, mention it to other users and share use cases. So, I think that maybe you'll be interested into participating: if yes, please refer to our support team, they…

Yeah, it's better to transfer the question to the portal - there our team will be able to ask for all the details and advise.

Hi @VINCENT DUPONT , As a representative of the Stiltsoft team, I can name several tips that may be achieved with the help of our app that is Table Filter and Charts for Confluence (maybe you already have the add-on installed for your instance): * you may create Jira dashboards (including Gantt chart based on Jira issues)…

Hi @Onja , Saw the Table Filter macro on the page - it belongs to our Table Filter and Charts for Confluence app. The add-on also provides the Table Transformer macro that contains a Look up preset. Here is its documentation with a use case for you to check. If the two tables have a common column, they can be combined into…

Now for Cloud the Table Excerpt macro is included into the Table Toolbox macro. So you are able to reuse not the original source table, but filtered (aggregated, transformed, etc.) result table. For example, here we reuse the filtered table.

Or maybe the following case will suit you: for example, I reuse a table via the Table Excerpt/Table Excerpt Include macros but want to show only one specific cell as plain text. So you may wrap this Table Excerpt Include (or a manually created table for my example) in the Table Transformer macro and find the required cell:…

Hi @Jorge Sabino , Please, clarify the case - do you need to retrieve data within a specific cell? Then it won't be a problem: just put the Table Excerpt macro inside the cell and wrap its contents. Then reuse the Excerpt via the Table Excerpt Include macro (don't forget to tick the "Show a copy of the source table" option…

Hi @Lisset Salazar , The current behavior of the Table Spreadsheet macro is as following: after you copy/paste cells and save the changes, the source border doesn't disappear and the copied cells remain selected. To get rid of the source border, hit the "Esc" key on your keyboard. To get rid of the selected cells,…

Hi @Gaby , I'm here to inform that we've just released a new version of the Table Filter and Charts for Confluence app with the Table Excerpt macro inside the Table Toolbox macro. Now you'll be able to create macro' sequences (for example, "source table <- Table Transformer <- Table Filter <- Pivot Table") and reuse the…

Hi @Djukic Haris , We've just released a new version of the Table Filter and Charts for Confluence app with the Table Excerpt macro inside the Table Toolbox macro. This feature was mentioned in this thread. Now you'll be able to create macro' sequences (for example, "source table <- Table Transformer <- Table Filter <-…

Hi @Brad Johnson , We've just released a new version of the Table Filter and Charts for Confluence app with the Table Excerpt macro inside the Table Toolbox macro. Now you'll be able to create macro' sequences (for example, "source table <- Table Transformer <- Table Filter <- Pivot Table") and reuse the result table. Hope…

Hi @Taimoor Fayyaz , We've just released a new version of the Table Filter and Charts for Confluence app with the Table Excerpt macro inside the Table Toolbox macro. Now you'll be able to create macro' sequences (for example, "source table <- Table Transformer <- Table Filter <- Pivot Table") and reuse the result table.

Hi @Nate Dickinson , To count non numeric tabular data (similar to pivot tables in Excel) and then visualize it, you may use our Table Filter and Charts for Confluence app. As your hosting is Cloud, the first step will be to insert the Table Toolbox macro and place your source table (manually created or, for example,…

You may also use the FORMATDATE(T1.'Date', "d M yy") function with additional parameter "d M yy" that is your desired output to convert various date formats. This option is more easy-to-read than the first one. And you may try to set the yy-mm-dd date format in the Chart from Table macro (at once, without any…

Yes, it will be even simpler than the first variant: go to the Settings tab of your Table Transformer macro and set the d M yy variant of the date format (it corresponds to your "28 Apr 2016" date picker, I assume). Then use the following query: SELECT T1.'Phase', FORMATDATE(T1.'Date') AS 'Converted Date' FROM T* The…

Hi @Niall Poole , As you've mentioned the Chart from Table macro, I assume that you use our Table Filter and Charts from Confluence app. So, to change the date format from the tables coming from Confluence, you may also use our Table Transformer macro. For example, you wrap the source table in the Table Excerpt macro,…