I like the table visualization very much. Thank you. However, when using a //date makro the graph will not be displayed correctly. To make this work, I need to modify all dates. Is this known? Or is there even a reason for that?
Atlassian Team members are employees working across the company in a wide variety of roles.
July 6, 2022 edited
Hi everyone!
I’m the Product Manager who worked on bringing this feature to life. Table Visualization has been a highly requested feature and our team is so happy to see that so many of you have found our MVP to be useful.
I’ve reviewed and catalogued all of your comments, and there are a few specific questions that I want to answer:
Will this work with dynamic tables (page properties reports, etc.)?
Dynamic tables are extensions, which means they don’t have any referentiality attached. We’ll make a note of this feedback and see if this is requested by more users.
Is there a way to hide the data so the chart is only visible?
We don’t have a direct way to hide table data, however, you can cut and paste the table into an expand on the same page as a work around. We planned to build this into the initial MVP, but decided that it wasn’t worth delaying the feature release when there was a viable workaround.
Is it possible to switch the X and Y axis?
For now, we do not support switching the x-axis and y-axis. I understand it’s annoying to switch the column data to be row data and vice versa, and I’m taking a note that this has been reported by users. To give you the full picture, we made the tradeoff to ship the feature without this functionality so we could get the MVP into customers' hands faster.
Do we have features for analyzing what-if scenarios? Control charts?
At the moment, we support line, bar, and pie charts. We will continue to gather interest in additional chart types.
In addition, I noted quite a few feature requests, including supporting additional data types like dates and Jira issues, connecting outside data sources, and basic table functionality and nesting.
As a PM, I constantly use tables to share information with my team and stakeholders. I want you to know that our our long-term goal is to make Confluence tables a more powerful tool for gathering, communicating, and presenting all kinds of data.
@Divya Sriram is another Product Manager on my team who is leading the effort on table enhancements and can keep you all updated on our progress as we continue to invest in this area.
Thank you @Sam Ugulava and @Divya Sriram - as someone who loves working with tables, I just want to echo some of the other comments around the ability to do more powerful filtering and formatting.
One of the tables that I commonly work with has multiple data types (numbers, text, dates, priority, status, screenshots, etc.) and with the only filtering being Ascending or Descending in alphabetical order, it's often difficult to zero in on particular rows or intersecting trends (e.g., Can I look at High Priority rows *AND* Complete status rows only?).
More dynamic filtering (akin to the filtering I can easily and quickly do on my keyboard in an Excel spreadsheet) with a chart that responds dynamically to that filtering...that would be a powerful visualization combo!
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Echoing @isaiah berg - it would also be nice if the alpha sort behaved more predictably, especially where links are concerned. They don't seem to alphabetize by the display text, and when links are mixed with plain text in a column, it's pure chaos.
Will it also soon be possible to filter the columns in a table? This would not only replace many use cases where we need to link to external excel files, but it would also make the visualization more powerful.
@Tosin Ojikutu - hey there - we're already on cloud premium - have been for a decade - we sometimes get issues where old ondemand names are not catered for by developers.
we're on a .jira.com domain - any chance of catering for that?
@Paul Douglas@Danno - Jira.com is one of the original places that Cloud was first implemented. Some of the early adopters may still be on .jira.com. I don't remember if they were actually Atlasian-hosted server instances, or the Cloud you get from a site on atlassian.net, but I thought they had all been migrated to atlassian.net. I guess not!
Check the "help" menu - does it give you an "about" option or a version? If either, what do they tell us?
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Will this be able to count and handle non numeric data? I'm looking for a quick way to chart out staffing within a department via role and full time/contract status. Is there a way to do this with this tool? For example I would like to use table visualizations to use the following data to show a breakdown of persons from a department, the breakdown of the total count of emergency staffing, and be able to make a count of a specific role. Right now this does not compile within Confluence.
Emergency Staffing
No
Department
Role
1
Fire
Fighter
2
Fire
Fighter
3
Fire
Chief
4
Police
Officer
5
Police
Officer
6
Police
Officer
7
Police
Officer
8
Police
Chief
9
Medical
EMT
10
Medical
EMT
11
Medical
EMT
Answered: I actually answered my own question, but think it's relevant to put here. I was actually able to get the charts to graph non numerical data by including a numbered column that I built in an excel file and imported. The No, (number), column in this case is not the numbered column option built within confluence, but was manually inserted in an external program. Counting on the No column now compiles the graphs.
Actually the No column does compile, but it does so incorrectly. The workaround here was to create a column, I entitled weighted, and append a 1 to each row.
I have started a community post about defects with this system here
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
September 7, 2022 edited
Hi commenters, I'm Matt with K15t and I'm working on a video about table visualization in Confluence. Since this is so new on the scene, I don't have the typical wealth of examples to pull from here at K15t.
I'd love to know how your team is using table visualization and why. And of course, any pictures you can share would be fun, since charts are so visual.
Yip - spot on - early adopter of the 'on demand' version a decade ago - havent been able to change our name yet to the more accepted .atlassian domain.... some apps aren't compatible with the name change for migrating... unless anything has changed on that?
I just commented on an issue on @Matt Reiner _K15t_ table visualization discussion page about pdf export not working for this feature. Is it just me or do I need to raise an issue with Atlassian?
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
This is a good feature, but I would have preferred more basic functionality of tables to be rolled out first:
Formulas (especially totals)
The ability to set column widths as desired...and have those columns STAY those widths (as percentages if not pixels) when the left navbar is moved to view more or less of the page or the navbar itself.
The ability to turn the horizontal scrollbar on and off.
The ability to scroll the page to the right (beyond the page "margin") in order to view tables with many columns without scrunching the content in the table cells. You know, like MediaWiki allows you to do.
82 comments