Katerina Rudkovskaya [Stiltsoft] Atlassian Partner

Hi, here I meant manual aggregation - just count the number of cars for each date manually and then visualize the data using the standard Chart macro. There are no any standard Confluence macros to group tabular data automatically.

Hi @pvsherman, Your issue concerns Confluence Cloud in general: the editor is based on iFrames and doesn’t support macro nesting. Unfortunately, I don’t have any suitable workarounds. Maybe you’ll be able to reuse your source table several times with the help of the Table Excerpt/Table Excerpt Include macros and create…

Hi @mzaldivar, You may also check this example from our documentation (please navigate to the section “Splitting cell values in a column to different rows” if the anchor doesn’t work). Seems that it looks similar to your question. If you need to do smth else, please provide a screenshot of your source table and describe…

It seems that your case and the case in our documentation are alike. Statuses are considered as plain text for the conditions (it doesn't matter what color is the lozenge, only the title matters) and it also doesn't matter if you need to color one column or several - it is done separately column by column. Maybe this…

Hi @P AI, Your SQL query is not correct: SELECT T1.'Status', FORMATWIKI("{cell:bgColor=" + CASE WHEN T1.'Status' = "BLOCKED" THEN "#FA7E70" ELSE "#8FCA7D" END +"}" + T1.'Output' + "{cell}") AS 'Output' From T1 Please pay attention to the cell:bgColor function. In your variant it looked like cell.bgColour that causes errors…

Hi @Martin Niederberger, Please navigate to our documentation regarding the Table Transformer macro and check the “Conditional formatting” section:…

You may use the standard Chart macro but the data in your source table should be aggregated beforehand. What concerns our app, it's free for Cloud 1-10 users.

Hi @razor78, We can suggest trying our app – Table Filter and Charts for Confluence. Create the following macro sequence (directly if your hosting is Data Center/Server or via the Table Toolbox macro if you are on Cloud): Use the Pivot Table macro to group your entries by dates: If necessary, filter the empty dates out…

Hi @Scott Gillespie, To change the color of your "Average" numbers, check the corresponding parts of your query: SELECT *, CASE WHEN 'Engagement Page' = "Average" THEN FORMATWIKI("{cell:bgColor=#F4F5F7|textColor=Black}", "*", '#Stories Missed', "*", "{cell}") WHEN '#Stories Missed' > 0 AND 'Engagement Page' NOT LIKE…

Hi @Scott Gillespie, I’m afraid you are not quite right here: the FORMATWIKI function with plusses overrides the initial cell formatting and ruins links, bold text, etc. It concerns manually created tables and tabular Confluence macros such as Jira Issues, Page Properties Report, etc. But if you use commas, the initial…

Hi @Marian Corpus, If you don't need to pull the Page Title, you may use the standard Excerpt/Excerpt Include macros as a similar workaround to the one described in my answer. Otherwise, I don't have any other ideas to implement your case.

Hi @Deepak Chandrashekar Naik, As @Becky has mentioned, you filter your table using the JQL inside the Jira Issues macro. In her example the JQL is “assignee = currentUser()” – it means that every user who visits the page will see his/her tickets. Or you can change the “currentUser()” operator to a specific user name and…

Hi @Marian Corpus, If your company uses our Table Filter and Charts for Confluence app, you may use the Table Excerpt/Table Excerpt Include macros as a workaround.Wrap your tables with decisions in the Table Excerpt macros and collect them into one big report with the help of the Table Excerpt Include macro. Choose to show…

Hi @hiroki, If your company uses our Table Filter and Charts for Confluence app, then you may use the Table Transformer macro to add a ROWNUM() column to your manually created and dynamic tables: SELECT ROWNUM() AS '#', * FROM T*

To preserve initial cells formatting, you need to use comma (,) instead of plus (+) inside the FORMATWIKI function: CASE WHEN 'NoOfBlocked Tickets' > 0 THEN FORMATWIKI("{cell:bgColor=red}" , 'NoOfBlocked Tickets' , "{cell}") ELSE 'NoOfBlocked Tickets' END as 'NoOfBlocked Tickets'

Hi @Asjadazeez, The Table Transformer macro works with the data coming from the Jira Issues macro. So, unwrap your Jira Issues macro, publish the page and check the date format that was pulled from Jira. For me it's, for example, Jan 09, 2023 (depends on your instance settings, language, etc.) without any hours and…

Hi @Scott Gillespie, Generally, to preserve the initial cell format (for example, bold or italic text, links, etc.), use commas instead of pluses. For example, your query may look like this: SELECT *, FORMATWIKI("{cell:textColor=", CASE WHEN '#Stories Missed' >0 THEN "Red" ELSE "Black" END , "}" , '#Stories Missed' ,…

Hi abhilocalcircles, If you can’t find the Table Toolbox macro in the macro browser, it means that you are on Server/Data Center. As I’ve mentioned before, for these hostings you just nest macros directly on the page: Other steps/queries are the same. Don’t forget that you can nest macros in different combinations in…

@abhilocalcircles, I could reproduce the issue and we'll investigate it. For now, please try this workaround if you're using Confluence Cloud: Insert the Table Toolbox macro and place the two identical Jira tables inside its body. Then go to the Table Toolbox macro and recreate the following structure inside its body: If…

Hi @Randi Ortega, We can suggest trying our app that is Table Filter and Charts for Confluence and its Table Excerpt/Table Excerpt Include macros. The macros work similar to the Page Properties/Page Properties Report macros, but allow you to collect multiple-row table into one big, combined report. As you update your…

Hi @abhilocalcircles, Please try to use the following SQL query in your case: SELECT SUM(T1.'Story Points'::integer) as 'Days Needed', count(T1.'Assignee') 'NoOfTickets', (SELECT COUNT(T1.'Assignee') FROM T1 WHERE T1.'Status' LIKE "%BLOCK%" GROUP BY T1.'Assignee') AS 'NoOfBlocked Tickets', (SELECT SUM(T1.'Story…

Hi @abhilocalcircles, Seems that the issue comes from the inappropriate usage of the external and internal SELECT statements. Unfortunately, you didn’t provide us with the screenshot of your original table, but I’ve recreated something similar myself: Here is my SQL query: SELECT 'Assignee', SUM('Story Points'::integer) as…

Hi @Huangbin Chen, The _VIEW ending means that functions preserve the initial HTML format (the original format of the cell contents), for example, links. Otherwise, they work as functions without the _VIEW ending that transform everything to plain text. So, to check how the function works in general, go to the first part…

Hi @Andreas Sundvall, If your company uses our Table Filter and Charts for Confluence app and you store your dates in a table, you may use our Table Transformer macro for conditional formatting. You may check this page for several examples. The other option is to use the Table Spreadsheet macro where you can also compare…

Hi @majd makhoul, The Table Transformer macro considers your source table as a basic SQL database, so multiple-row headers are transformed into long one-row headers. Please see the example below: SELECT * FROM T* As you can see, you can’t refer to your column as “T1.Column 0”, now you have two columns “T1.Column 0 Column…

Hi @Cliff Wilson, For the first part of the question, we suggest checking this Community thread: the dates there are counted based on the first date in a column and placed in the same column. To count dates, the second table with days between your milestones is considered. The first variant excludes weekends and…

Hi @Dirk Derichs, Please use the following settings for your Chart from Table macro: If you want to present your aggregated data in a tabular way, you may use the Pivot Table macro: Hope it helps your case.

Hi @[deleted], I can suggest the following structure for your case: Here is the SQL query for your Table Transformer macro: SELECT * FROM T1 LEFT JOIN T2 ON T1.'Names'->indexOf(T2.'PID'+")") > -1 To group the result table in a more easy-to-read way, you may use the Pivot Table macro: Hope it helps your case.

Hi @Ramesh PS, Starting with the Table Filter and Charts for Confluence version 9.6.0 (Server/Data Center) and 20 Dec, 2022 for Cloud, we’ve made an improvement to the Pivot Table macro: such prefixes as “Sum of …”, “Literal of …” etc. can be eliminated.

Hi, I see that your Jira Issues macro is wrapped in the Table Filter macro but could you please take a screenshot of the Table Filter macro settings? Now from its icon it seems that it is not our Table Filter macro and you have also said that you don't have any apps from Stiltsoft. So, we need to define what macro you are…