find trend over time

AsafEvenPaz · ‎08-21-2020

I have a table with values for multiple projects over several months and I am trying to figure out how to do find trends over time in Insights. Basically I would like to look at each project ID over the course of several months and calculate the rate of change for a certain value. Any pointers?

ScottSandusky · ‎09-09-2020

Hi Asaf, here are some ideas:

use the time series graph to show a project value over time. you can use the "group by" option to show multiple lines on the graph, one for each project. Create and use a time series graph—ArcGIS Insights | Documentation
use the calculate percent change tool to see how much project values have changed. Calculate % Change—ArcGIS Insights | Documentation
This cheat sheet here shows you some of the visualization options that would be good for communicating change. https://www.esri.com/content/dam/esrisites/en-us/media/pdf/data-visualization-options-in-insights-en...

View solution in original post

ScottSandusky · ‎09-09-2020

Hi Asaf, here are some ideas:

use the time series graph to show a project value over time. you can use the "group by" option to show multiple lines on the graph, one for each project. Create and use a time series graph—ArcGIS Insights | Documentation
use the calculate percent change tool to see how much project values have changed. Calculate % Change—ArcGIS Insights | Documentation
This cheat sheet here shows you some of the visualization options that would be good for communicating change. https://www.esri.com/content/dam/esrisites/en-us/media/pdf/data-visualization-options-in-insights-en...