Trying to push the limits with macro: 'Chart from Table'. I want to see stars and no bars.

[Laurie Huth]

I work at a large company that locks down access to a lot of things. Therefore, I don't have access to as many macros as I'd like. I'm currently using the 'Chart from Table' and "Table Transformer" macro. I want a certain look. For example.

What I want it to do:

• I like the little stars that appear. However, the stars only appear when the end date is missing. For example, the Jira ticket written in white text (and no star) has a start and end date ("Due Date" and an "Enforcement Date"). The ones with stars just have a "Due Date". (The "Enforcement Date" was never populated in the Jira ticket.) Note: The ‘Chart from Table’ macro requires a start and end date in the 'Values column' field.

• 
• I don't want a colored bar (like the blue one that goes across). However, it shows because of the end date ("Enforcement Date").
• Note: I got clever and was able to show both the Summary and Due Date next to the star by writing this SQL line: 

           FORMATWIKI(SUM("*" + 'Summary' + "*" + ", Due " + 'Due')) AS 'Summary',

Here is the table:

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Laurie Huth. 

As I see, you are using the Gantt chart type via the Chart from Table macro.
To learn about all the possibilities of the Gantt chart (milestones (“stars”), events, dependencies, color schemes, etc.), please navigate to this section of our documentation. Here we have an example of what you should have in your source tables and how to operate with this data.
And here is an example how to build a Gantt chart based on the Jira Issues macro – hope this helps with your experiments.

[Laurie Huth]

I clicked on the two links. However, I received errors when loading both pages. Can you double check the links? Thanks!

[Katerina Rudkovskaya _Stiltsoft_]

Please try to follow these links:

https://docs.stiltsoft.com/display/TFAC/Gantt+chart+type?utm_source=atl_community&utm_medium=answer&utm_campaign=table-filter-traffic-sources&utm_vendorID=1216111 

https://docs.stiltsoft.com/display/TFAC/Building+a+Gantt+Chart?utm_source=atl_community&utm_medium=answer&utm_campaign=table-filter-traffic-sources&utm_vendorID=1216111