[Arcade] Using Date Type of data in a chart by using tierce API

JasonBOCQUET — Tue, 16 Jul 2024 10:15:17 GMT

Hi,

I have a code to retrieve and list all of the rows who have the same ID that the point i'm clicking on and showing this list on the pop-up box of the point.

Now, I want to use this code to retrieve a list of establishment who have a common ID with the establishment that i'm clicking on and see what are they opening and closing date.

To do that i found quickchart (i already use it for other case, work very well) propose a GANTT chart.

Here is my code :

var date_crea = $feature.ets_date_creation var Ending = Date('2024-07-16') var fs = FeatureSetByName($map, "Ancienneté d'implantation siège", ['ets_date_creation', 'ets_siren'], false) var filt_fs = Filter(fs, `ets_siren = '${$feature['ets_siren']}'`) var match_arr = [] for (var f in filt_fs) { Push(match_arr, Text(f['ets_date_creation'],'YYYY MM DD')) } var HTML = "" HTML += ""+Concatenate(match_arr, " ")+"" var param_charts = { type: 'horizontalBar', data: { labels: match_arr, datasets: [{ data: [ [date_crea, Ending], ], }, ], }, options: { legend: { display: false }, annotation: { annotations: [{ type: 'line', mode: 'vertical', scaleID: 'x-axis-0', value: Date('2021-10-30'), borderColor: 'red', borderWidth: 1, label: { enabled: true, content: 'Deadline', position: 'top' } }] }, scales: { xAxes: [{ position: 'top', type: 'time', time: { unit: 'month', parser : 'YYYY-MM-DD' }, ticks: { min: date_crea, max: Ending, } }], }, }, } var param_url = URLEncode(Text(param_charts)) var chart_url="https://quickchart.io/chart" + "?width=600&height=600&v=2&c=" + param_url HTML += `<img src='${chart_url}' /></div>` return { type : 'text', text : HTML }

when i call "date_crea" (the creation date) to make the left terminal of the X axis, it works the API recognize the date. But when i use the creation date in the data to create the content on the chart, i see nothing.

Anyone have an idea to see my data on the chart ?

topic [Arcade] Using Date Type of data in a chart by using tierce API in ArcGIS Online Questions

[Arcade] Using Date Type of data in a chart by using tierce API