gantt chart help need help help help help

[Former Member]

i need to make a gantt chart or something look like this

https://global-uploads.webflow.com/5a5399a10a77cc0001b18774/5ad8f7903a40975ce19867ef_gantt_template_...

SELECT to_date(SUBSTR(20180101,7,2) ||'/' ||SUBSTR(20180101,5,2) ||'/' ||SUBSTR(20180101,1,4)) start_date, to_date(SUBSTR(20180228,7,2) ||'/' ||SUBSTR(20180228,5,2) ||'/' ||SUBSTR(20180228,1,4)) finish_date, 1 request_number FROM dual UNION ALL SELECT to_date(SUBSTR(20180201,7,2) ||'/' ||SUBSTR(20180201,5,2) ||'/' ||SUBSTR(20180201,1,4)) start_date, to_date(SUBSTR(20180331,7,2) ||'/' ||SUBSTR(20180331,5,2) ||'/' ||SUBSTR(20180331,1,4)) finish_date, 2 request_number FROM dual UNION ALL SELECT to_date(SUBSTR(20180301,7,2) ||'/' ||SUBSTR(20180301,5,2) ||'/' ||SUBSTR(20180301,1,4)) start_date, to_date(SUBSTR(20180430,7,2) ||'/' ||SUBSTR(20180430,5,2) ||'/' ||SUBSTR(20180430,1,4)) finish_date, 3 request_number FROM dual UNION ALL SELECT to_date(SUBSTR(20180401,7,2) ||'/' ||SUBSTR(20180401,5,2) ||'/' ||SUBSTR(20180401,1,4)) start_date, to_date(SUBSTR(20180531,7,2) ||'/' ||SUBSTR(20180531,5,2) ||'/' ||SUBSTR(20180531,1,4)) finish_date, 4 request_number FROM dual

[abhilash_kumar]

Hi Ozkan,

1. Go to Insert > Chart and select "Gantt Chart"

2. Go to the Data tab in the Chart Expert. Change the default drop-down of "On Change of" to "For each record".

3. Move the "request_number" field to this "For each record" section

4. Move the Start Date and End Date fields to the "Show Values" section and click OK

-Abhilash

[Former Member]

i know i tried everything but nothing workkk

[abhilash_kumar]

Have you verified if the "Start Date" and "End Date" values for each request number show up correctly inside the report?

Could you drag and drop the request_number, start date and end date fields on the details section and check?

-Abhilash

[Former Member]

i did it thankss