Natalie Paramonova _Stiltsoft_ Expert

Hi @Mo Ullah , As you are on Confluence Server/Data Center, please check the version of the Table Filter and Charts for Confluence app that you use. The current one is 9.5.2. If yours is an older one, please update. In recent versions there indeed were some issues with the today() function, your question may have the same…

For the second option we start to order dates in the upper internal Table Transformer macro. Please check once more if you copied the whole SQL query with the ORDER BY 'Date' ending and then go to the Table Transformer macro settings and check the Date format field. It should correspond with the date format in your table.…

Hi @Delasha Long , We can also suggest trying our app that is Table Filter and Charts for Confluence. You’ll have two options: Option 1. Use the Table from CSV macro. The macro allows you to connect csv/tsv files via urls or connect Google Spreadsheets directly to your Confluence pages. When any changes are made to the…

Hi @Eikra Shithil , We can suggest two available options for the case for you to choose from. Option 1. Pivot Table + Table Transformer Here is the structure for you to implement: If your tags are correct and you are on Confluence Cloud, please use our Table Toolbox to nest macros. Here the original table is reused via the…

Hi @Holly Louise Perry , Please add the "FORMATWORKLOG" function before counting the time difference: SELECT FORMATWORKLOG(T1.'Time 2' - T1.'Time 1') AS 'Difference' FROM T1 Besides you may go to the Table Transformer macro settings -> Settings tab -> Set worklog settings menu and check the parameters according to your…

Hi @Laurie Huth , To count dates that are “minus 30 days from the existing dates in the table”, you may use the following SQL query: SELECT T1.'Date 1', FORMATDATE(DATE_SUB(T1.'Date 1', INTERVAL 30 DAY)) as 'Date 2' FROM T1 The date format for the Table Transformer macro is set as “d M yy”. Hope this helps in your case.

Hi @Aleks Irinics , To color rows coming from different tables, we may suggest adding an optional column to every table indicating its belonging. For example, name it as a “Source table” and put the T1, T2, T3,… Tn in the cells. Then you may merge/transform the master report with the first Table Transformer macro and then…

Hi @Asjadazeez , Maybe the following workaround will suit you: use the Table Transformer macro instead of the Table Filter macro for filtering. Wrap your Jira Issues macro with a general JQL in the Table Transformer macro and then in the Table Excerpt macro to reuse the filtered table. So, later you’ll be able to use the…

Hi @Elena Kondrashova , Thanks to @Luis Machado - you have almost the whole case done! To wrap everything, I can suggest the following structure: The query for the internal Table Transformer macro is left as it is. The query for the external Table Transformer macro is as following: SELECT *, 'Working Hours' - 'Downtime' as…

Hi @Santhosh ESS , as I can see, you use the app extensively. We're so happy that it is helpful. Thank you for sharing!

Hi @[deleted] , thank you for sharing your use cases and ideas! It's definitely something we will think about 🙂

Hi @Keith Sottung , you can try the Layouts tool in the editor's panel. With its help, you can add and configure columns and sections and then organize tables, macros, and other content on your page.

Hello @Arvind Sinha , You can apply the following query to preserve Jira filter links: SELECT T1.'Date', FORMATWIKI( "["+(T1.'Count'->split(" issues")->0::number) +"|" + T1.'Count'->tfView->match("href=([^ >]*)")->1->slice(1, -1) + "]" ) AS 'Count' FROM T*

Hi @Temisan Sagay , besides the default Chart macro already mentioned in this thread, you can try to build a chart in afew clicks with the help of the Chart from Table macro if you have Table Filter and Charts for Confluence installed. Or you can also browse Atlassian Marketplace to look for more apps.

Hi @Arvind Sinha , If you insert the issue count option in a table cell, You can remove the word 'issues' with the help of the Table Transformer macro (the Table Filter and Charts for Confluence app). Please find the detailed instructions in the answers to this question.

Hi @Yosif Touma , If you insert the issue count option in a table cell, You can remove the word 'issues' with the help of the Table Transformer macro (the Table Filter and Charts for Confluence app). Please find the detailed instructions in the answers to this question.

Hi @Venkatesh Vivekanandan , I'll guide you through the steps. 1. Make sure that the Table Filter and Charts for Confluence app is installed in your Confluence instance. There is no app icon in the page view mode on your screenshot. You can ask your Confluence Administrator if the app is available. 2. Click the filtration…

Hi @Nikki Hailey , as a workaround, you can use the Table Filter macro that provides a number of options for better table viewing, including sorting (you can even sort by multiple columns if needed). The result:

Hi @Sandra Lawrence , it seems that the Handy Status macro (from the Handy Macros app) may help in your case. You can create a predefined list of values and after that just select the option you need to label your items.

Hi @HN-Collins , please note that you need to have the Confluence Administrator's permissions to install apps. To install the app in Confluence Server, please follow this link for instructions. If you still have issues when installing the app, please contact our Service Desk at servicedesk@stiltsoft.com or at the Service…

@Dailin Garcia Young , There is no option to do this with the help of UI for now. But Confluence Administrator can do this manually. Please contact our Service Desk at tech-support@stiltsoft.com and I'll give you the detailed instructions.

Hi @Dailin Garcia Young , You need to be a space administrator to add status sets to spaces in the space tools: Space status sets looks the following way:

Hi @Dailin Garcia Young , This is the expected behavior. If I understand your question correctly, you'll see the space status sets when you're editing a page from this specific space that the status set is created for.

Hi @Dailin Garcia Young , There are three ways to add status sets: * Personal status sets:* These sets are visible for the creator when inserting the macro and can be edited by the creator only * The macros are available for switching and copying for other users * Space status sets:* These sets are visible for all the…

Hi @Muhammad Dzakwan Zaky , As a workaround, you can use the Handy Macros app that includes the Handy Status macro. You can add predefined status sets and switch statuses from these sets in the page view mode. There are a lot of color options for text and background available in this macro:

Hi @Oleh Tsvilenko , There is no ability to change the content directly in the Page Properties Report macro in Confluence by default. You can try the Handy Macros app. The Handy Status macro allows you to change statuses within the predefined lists on the go in the page view mode including the Page Properties Report macro.…

Hi @Luke Parker , You can try to use the Handy Macros app that includes the Handy Status macro. The macro allows you to create a set of values, insert the Handy Status macro on a page (in a table), and switch the statuses from this predefined list on the go in the page view mode.

Hi @Tan Chow Tun , To discuss your request please raise a ticket in our support portal. Thank you!

Hi @nyoungb2 , The pagination feature is available in the Table Filter and Charts app now.

The pagination feature is available in the latest version 5.4.0 of Table Filter and Charts.