Stew Stryker
Member³
I'd love to learn how to build a Gantt style graph, but the Help doesn't go there. I've tried pushing it around a little but no luck either.
In the following query, if commitment_type has 4 string values, can you give me hints on how I could display a Gantt graph showing the min and max dates?
In the following query, if commitment_type has 4 string values, can you give me hints on how I could display a Gantt graph showing the min and max dates?
Code:
SELECT commitment_type,
MIN(dg.record_date) AS record_date_min,
MAX(dg.record_date) AS record_date_max
FROM aeo.aeo_directed_giving dg
GROUP BY commitment_type;