Data comparison by adjustable date

808
5
10-22-2018 06:18 AM
by Anonymous User
Not applicable

I have an Operations Dashboard that shows crime data.  I want to be able to compare one time frame to the previous time frame based on a filter condition selected by the user.

For example, if the user selects "One Week" as the time frame they want to see the indicator will show if crime is up or down from the previous week. If they choose "One Month" it'll show compared to the previous month.... etc.

I'm trying to figure out how I could set up my conditional formatting to have this variable time frame comparison.

Has anyone else worked on something similar?

0 Kudos
5 Replies
AndrewHargreaves2
Occasional Contributor III

I'd love something similar...

by Anonymous User
Not applicable

Andrew,

The current work around I'm doing is having a few indicators showing a predetermined time frame.....

I'm not sure if you've tried something similar but just tossing out ideas.

AndrewHargreaves2
Occasional Contributor III

Thanks Brandon Jumonville

How are you getting that % value in the middle of your indicator?

0 Kudos
by Anonymous User
Not applicable

Andrew,

I'm creating a "Reference" that compares the previous time frame to the current (last 30 days referencing last 60 to 30 days). The option to use a reference is at the bottom of the Data pane (it took me a while to find it because I was just kind of glossing over it)/

You are given several more options in the "Fields: {}" after setting a reference

And this was the layout I decided on after playing around with it a bit.

I hope that helps.

0 Kudos
HeathAnderson
Occasional Contributor II

I am looking for similar functionality.  Is creating multiple indicators still the only way?  Has someone found out how to do this with a serial chart?  If not, did you submit it as and idea?

https://community.esri.com/t5/arcgis-dashboards-ideas/idb-p/arcgis-dashboards-ideas

0 Kudos