Accepted Solutions
Hi @PSGeo , a few of these questions have been covered here and here, but I wanted to also follow-up directly in this post.
An example, I have a table with vehicles with different symbol based on the attribute type of vehicle: simple symbol with colour change according to the attribute: bikes red, cars blue and motorbikes violet, etc.. Why there is no option to associate the colour of your graphs with the colour of your symbols in the map for that fc?
Charts should automatically match the symbology colors when possible. For instance, here the layer is using Single Symbol symbology and the bar chart matches the layer color:
Similarly, bar charts will match Unique Values symbology when the layer symbology uses the same field that’s used for the bar chart Category or Date parameter:
Why the bar chart does not allow having data distributed by dates? An example, I want to see the vehicles categorized by type of vehicle per years. Is this possible?
Bar charts support date fields and it’s possible to apply a Split By field to a temporal bar chart to see the breakdown of different categories over time. For instance, here I’ve created a temporal bar chart using the “Created Date” field and then each time bin is split into category groups using the “Borough” field:
Is it also possible having the count coming on a table with the lines having the type of vehicles and columns with dates?
It is possible to export a chart as a data table using the Export As Table option:
Here’s a snippet of the data table that's exported for the temporal bar chart above:
Do you guys remember to have pie charts to show small differences between two dates as an exercise in the university? Something like: imagine the number of cars, bikes, trucks for two distinct years shown proportionally on a pie chart divided in the middle with one year in one side and the other year on the other side and both showing those attributes. Is this possible in arcgis pro?
Maybe using arcade?
We discussed this a bit in this Pro Idea but I’ll elaborate here. As I mentioned, we do not currently support the kind of chart you described, but I would suggest a multiseries pie chart as an alternative. This involves setting the Split By field for the pie chart. Since date fields are not allowed in the Split By parameter, you can create an Arcade expression to extract the year. When a Split By field is set, the pie chart will display as a grid of mini-charts where each mini-chart shows data for a specific year:
Alternatively, a 100% stacked bar chart is another good option for viewing proportional changes over time. Here I’ve created a bar chart that shows the years on the x-axis and the y-axis shows the breakdown of “Complaint Type” values. The important step here is to set the Display multiple series as dropdown to “100% Stacked”. The resulting chart clearly shows the part-to-whole relationship between the categories as they change over the time:
Thanks!
Hi @PSGeo , a few of these questions have been covered here and here, but I wanted to also follow-up directly in this post.
An example, I have a table with vehicles with different symbol based on the attribute type of vehicle: simple symbol with colour change according to the attribute: bikes red, cars blue and motorbikes violet, etc.. Why there is no option to associate the colour of your graphs with the colour of your symbols in the map for that fc?
Charts should automatically match the symbology colors when possible. For instance, here the layer is using Single Symbol symbology and the bar chart matches the layer color:
Similarly, bar charts will match Unique Values symbology when the layer symbology uses the same field that’s used for the bar chart Category or Date parameter:
Why the bar chart does not allow having data distributed by dates? An example, I want to see the vehicles categorized by type of vehicle per years. Is this possible?
Bar charts support date fields and it’s possible to apply a Split By field to a temporal bar chart to see the breakdown of different categories over time. For instance, here I’ve created a temporal bar chart using the “Created Date” field and then each time bin is split into category groups using the “Borough” field:
Is it also possible having the count coming on a table with the lines having the type of vehicles and columns with dates?
It is possible to export a chart as a data table using the Export As Table option:
Here’s a snippet of the data table that's exported for the temporal bar chart above:
Do you guys remember to have pie charts to show small differences between two dates as an exercise in the university? Something like: imagine the number of cars, bikes, trucks for two distinct years shown proportionally on a pie chart divided in the middle with one year in one side and the other year on the other side and both showing those attributes. Is this possible in arcgis pro?
Maybe using arcade?
We discussed this a bit in this Pro Idea but I’ll elaborate here. As I mentioned, we do not currently support the kind of chart you described, but I would suggest a multiseries pie chart as an alternative. This involves setting the Split By field for the pie chart. Since date fields are not allowed in the Split By parameter, you can create an Arcade expression to extract the year. When a Split By field is set, the pie chart will display as a grid of mini-charts where each mini-chart shows data for a specific year:
Alternatively, a 100% stacked bar chart is another good option for viewing proportional changes over time. Here I’ve created a bar chart that shows the years on the x-axis and the y-axis shows the breakdown of “Complaint Type” values. The important step here is to set the Display multiple series as dropdown to “100% Stacked”. The resulting chart clearly shows the part-to-whole relationship between the categories as they change over the time:
Thanks!
Hi @PSGeo ,
It sounds like you want to plot this temporal data using a line chart or a calendar heat chart. In either case, this data will need to be reshaped to prepare it for charting. Your data is currently in a “wide” format where each observation is a separate column. To chart time series data, it’s often better to reshape the data to a “long” format, where each observation is a separate row. I used the Transpose Fields tool to reformat your table like so:
Car | Date | Count |
Volkswagen | 1/1/2024 | 5 |
Volkswagen | 2/1/2024 | 23 |
Volkswagen | 3/1/2024 | 1 |
Volkswagen | 4/1/2024 | 5 |
Chevrolet | 1/1/2024 | 2 |
Chevrolet | 2/1/2024 | 10 |
Chevrolet | 3/1/2024 | 1 |
Chevrolet | 4/1/2024 | 3 |
Ford | 1/1/2024 | 0 |
Ford | 2/1/2024 | 15 |
Ford | 3/1/2024 | 7 |
Ford | 4/1/2024 | 7 |
Seat | 1/1/2024 | 1 |
Seat | 2/1/2024 | 14 |
Seat | 3/1/2024 | 5 |
Seat | 4/1/2024 | 1 |
Now that the data is in the correct format, I can create a line chart using the following parameters:
- Date or Number: Date
- Numeric field(s): Count
- Split by: Car
You could also use this reformatted data to create a calendar heat chart, although a calendar heat chart does not support a Split by field, so you’ll either have to plot all of the car types together on one chart or filter your data (eg using a definition query) and create separate calendar heat charts for each car type.
Hope this helps!
Thanks,
Chris
Hi @PSGeo ,
Sorry for the confusion—now I think I understand. Assuming that the “Date” field type is Date (if it isn’t, you’ll have to convert it), then then you should be able to plot this data using a calendar heat chart or a matrix heat chart. I’ve generated some fake data to illustrate these two options.
In a calendar heat chart, time is represented by two dimensions. Here I’m showing days of the month on the x-axis and months on the y-axis:
However, a calendar heat chart does not allow you to split the data into groups, so it’s merely showing you the trend for all cars together.
A matrix heat chart will allow you to view temporal trends divided into groups. Here I’ve created a matrix heat chart that shows “date” on the x-axis and the “car” on the y-axis:
This chart uses temporal binning (introduced in Pro 3.2) to aggregate dates into two week intervals. The chart allows you to see the patterns over time broken down by car type.
Please feel free to email me (callen@esri.com) if you want to discuss further. Thanks!
Chris
