Gantt Chart Axes

[varunamin]

Hi,

I am creating a gantt chart but the axes displays year 1900 instead of current year from data. Please let me now what needs to be changed. Thanks!

[varunamin]

Hi,

Any solution on this one. Please let me know. Thanks!

[Frank_Hartmann]

please share a sample qvw which demonstrates the issue

[varunamin]

Hi Frank,

Have attached a sample qvw. Need solution for below issues:

1) Date Range on X axis starts from 1900

2) Filter for Tested On should also display Month, Year format.

Please let me know what changes should be made. Thanks.

[alex00321 · Accepted solution]

Hi you could check attached file to see if this works for you. thanks!

[varunamin]

Hi Alex,

Thanks! It worked but the Tested On filter shows blank when I replicate it on my dashboard.

Also is there a way to display the bars on a single row and the ones that overlap in the same time frame needs to be displayed on next row.

[alex00321]

Hi for your first question, I'm using =DATE(date(SubField([Tested On],' ',1),'MM/DD/YYYY'),'MMM-YY') to group the Test on, so you could try to update based on your own needs. For the second one, seems not possible. Thanks!

[varunamin]

Hi Alex,

I am also having the same field (Tested On) and using the same expression. But it still shows empty list box.

[alex00321]

Can you attach your application? Thanks!

[varunamin]

Hi Alex,

Have just added the filter on the dashboard that I am working on. Also need unique MM-YYYY values in Filter.

Thanks!