<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Create Gantt chart in ArcGIS Dashboards with data expressions in ArcGIS Dashboards Questions</title>
    <link>https://community.esri.com/t5/arcgis-dashboards-questions/create-gantt-chart-in-arcgis-dashboards-with-data/m-p/1663933#M11586</link>
    <description>&lt;P&gt;&lt;a href="https://community.esri.com/t5/user/viewprofilepage/user-id/216871"&gt;@DarrenLloyd__DOIT&lt;/a&gt;&amp;nbsp; &amp;nbsp;I have done something kind of similar but I preprocessed the data set to prior to importing it.&amp;nbsp; For example instead of each row having a start date and a duration, I made a row for each day in the duration. So for your example it would be something like this&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Traffic Study&amp;nbsp;&amp;nbsp;Initial Assessment&amp;nbsp;&amp;nbsp;6/6/25&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Traffic Study&amp;nbsp;&amp;nbsp;Initial Assessment&amp;nbsp;&amp;nbsp;6/7/25&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Traffic Study&amp;nbsp;&amp;nbsp;Initial Assessment&amp;nbsp;&amp;nbsp;6/8/25 and so on&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;You would then have to assign an arbitrary value to each of your "Names" to get the separation. You can do this all with a new data expression. However it still comes out pretty rough looking and, at least as far as I took it, I wasn't able get different colors for the different "names" so I had to add a table to equate the labels with the name and types. Below is&amp;nbsp; the expression, table and setup as well as the sample data set I made. Hopefully that gives you some ideas if you choose to pursue.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Neal_t_k_0-1762442652119.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/143296i115D31ECA41AF2DF/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Neal_t_k_0-1762442652119.png" alt="Neal_t_k_0-1762442652119.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Neal_t_k_1-1762442748100.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/143297i7466F6D6DF123DD6/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Neal_t_k_1-1762442748100.png" alt="Neal_t_k_1-1762442748100.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;LI-CODE lang="java"&gt;var portal = Portal('https://www.arcgis.com');
var fs = FeatureSetByPortalItem(portal, '&amp;lt;itemID&amp;gt;', 0, ['Name', 'EventType', 'EDate', 'Duration_', 'Number']);//number is an assignment to separate entries 

var features = [];

for (var row in fs) {
    var name = row.Name;
    var eventType = row.EventType;
    var startDate = row.EDate;
    var duration = row.Duration_;
    var number1 = row.Number;

    // Properly skip invalid rows
    if (IsEmpty(name) || IsEmpty(eventType) || IsEmpty(startDate) || IsEmpty(duration)) {
        continue;
    }

    for (var i = 0; i &amp;lt; duration; i++) {
        var currentDate = DateAdd(startDate, i, "days");

        Push(features, {
            attributes: {
                Name: name,
                EventType: eventType,
                Date: currentDate,
                Number: number1,
                DateText: Text(currentDate, "YYYY-MM-DD"),
                Label: name +'-'+eventType
            }
        });
    }
}


// Return using FeatureSet(Text(...)) pattern
return FeatureSet(Text({
    fields: [
        { name: "Name", type: "esriFieldTypeString" },
        { name: "EventType", type: "esriFieldTypeString" },
        { name: "Date", type: "esriFieldTypeDate" },
        { name: "Number", type: "esriFieldTypeInteger" },
        { name: "DateText", type: "esriFieldTypeString" },
        { name: "Label", type: "esriFieldTypeString" }
    ],
    geometryType: "",
    features: features
}));&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Thu, 06 Nov 2025 18:08:25 GMT</pubDate>
    <dc:creator>Neal_t_k</dc:creator>
    <dc:date>2025-11-06T18:08:25Z</dc:date>
    <item>
      <title>Create Gantt chart in ArcGIS Dashboards with data expressions</title>
      <link>https://community.esri.com/t5/arcgis-dashboards-questions/create-gantt-chart-in-arcgis-dashboards-with-data/m-p/1661357#M11576</link>
      <description>&lt;P&gt;I would like to create a Gantt chart in ArcGIS Dashboards to track dates/ duration days for a permitting timeline project. We have a permit process that requires multiple groups submit permits for a single location. Since Gantt charts are not native to the dashboard, I am planning to use a data expression. I found a post that references using data expressions to make a "quasi" Gantt chart, but I could use a little more specific assistance in the data types needed and execution of the data expression.&lt;/P&gt;&lt;P&gt;&lt;A href="https://community.esri.com/t5/arcgis-dashboards-questions/gantt-chart/td-p/1310961" target="_blank"&gt;https://community.esri.com/t5/arcgis-dashboards-questions/gantt-chart/td-p/1310961&lt;/A&gt;&lt;/P&gt;&lt;P&gt;For example, I have a table with date fields and duration days.&lt;BR /&gt;Name = Traffic Study&lt;BR /&gt;Initial Assessment Date = 6/6/25&lt;BR /&gt;Initial Assessment Days = 8&lt;BR /&gt;Review Start Date = 7/7/25&lt;BR /&gt;Review Period Days = 45&lt;/P&gt;&lt;P&gt;I appreciate the help!&lt;/P&gt;&lt;P&gt;&lt;a href="https://community.esri.com/t5/user/viewprofilepage/user-id/363906"&gt;@jcarlson&lt;/a&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;a href="https://community.esri.com/t5/user/viewprofilepage/user-id/657631"&gt;@C_McNamara&lt;/a&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 28 Oct 2025 15:36:42 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-dashboards-questions/create-gantt-chart-in-arcgis-dashboards-with-data/m-p/1661357#M11576</guid>
      <dc:creator>DarrenLloyd__DOIT</dc:creator>
      <dc:date>2025-10-28T15:36:42Z</dc:date>
    </item>
    <item>
      <title>Re: Create Gantt chart in ArcGIS Dashboards with data expressions</title>
      <link>https://community.esri.com/t5/arcgis-dashboards-questions/create-gantt-chart-in-arcgis-dashboards-with-data/m-p/1663933#M11586</link>
      <description>&lt;P&gt;&lt;a href="https://community.esri.com/t5/user/viewprofilepage/user-id/216871"&gt;@DarrenLloyd__DOIT&lt;/a&gt;&amp;nbsp; &amp;nbsp;I have done something kind of similar but I preprocessed the data set to prior to importing it.&amp;nbsp; For example instead of each row having a start date and a duration, I made a row for each day in the duration. So for your example it would be something like this&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Traffic Study&amp;nbsp;&amp;nbsp;Initial Assessment&amp;nbsp;&amp;nbsp;6/6/25&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Traffic Study&amp;nbsp;&amp;nbsp;Initial Assessment&amp;nbsp;&amp;nbsp;6/7/25&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Traffic Study&amp;nbsp;&amp;nbsp;Initial Assessment&amp;nbsp;&amp;nbsp;6/8/25 and so on&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;You would then have to assign an arbitrary value to each of your "Names" to get the separation. You can do this all with a new data expression. However it still comes out pretty rough looking and, at least as far as I took it, I wasn't able get different colors for the different "names" so I had to add a table to equate the labels with the name and types. Below is&amp;nbsp; the expression, table and setup as well as the sample data set I made. Hopefully that gives you some ideas if you choose to pursue.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Neal_t_k_0-1762442652119.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/143296i115D31ECA41AF2DF/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Neal_t_k_0-1762442652119.png" alt="Neal_t_k_0-1762442652119.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Neal_t_k_1-1762442748100.png" style="width: 400px;"&gt;&lt;img src="https://community.esri.com/t5/image/serverpage/image-id/143297i7466F6D6DF123DD6/image-size/medium?v=v2&amp;amp;px=400" role="button" title="Neal_t_k_1-1762442748100.png" alt="Neal_t_k_1-1762442748100.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;LI-CODE lang="java"&gt;var portal = Portal('https://www.arcgis.com');
var fs = FeatureSetByPortalItem(portal, '&amp;lt;itemID&amp;gt;', 0, ['Name', 'EventType', 'EDate', 'Duration_', 'Number']);//number is an assignment to separate entries 

var features = [];

for (var row in fs) {
    var name = row.Name;
    var eventType = row.EventType;
    var startDate = row.EDate;
    var duration = row.Duration_;
    var number1 = row.Number;

    // Properly skip invalid rows
    if (IsEmpty(name) || IsEmpty(eventType) || IsEmpty(startDate) || IsEmpty(duration)) {
        continue;
    }

    for (var i = 0; i &amp;lt; duration; i++) {
        var currentDate = DateAdd(startDate, i, "days");

        Push(features, {
            attributes: {
                Name: name,
                EventType: eventType,
                Date: currentDate,
                Number: number1,
                DateText: Text(currentDate, "YYYY-MM-DD"),
                Label: name +'-'+eventType
            }
        });
    }
}


// Return using FeatureSet(Text(...)) pattern
return FeatureSet(Text({
    fields: [
        { name: "Name", type: "esriFieldTypeString" },
        { name: "EventType", type: "esriFieldTypeString" },
        { name: "Date", type: "esriFieldTypeDate" },
        { name: "Number", type: "esriFieldTypeInteger" },
        { name: "DateText", type: "esriFieldTypeString" },
        { name: "Label", type: "esriFieldTypeString" }
    ],
    geometryType: "",
    features: features
}));&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 06 Nov 2025 18:08:25 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-dashboards-questions/create-gantt-chart-in-arcgis-dashboards-with-data/m-p/1663933#M11586</guid>
      <dc:creator>Neal_t_k</dc:creator>
      <dc:date>2025-11-06T18:08:25Z</dc:date>
    </item>
  </channel>
</rss>

