Award Date chart doesn't switch to smaller bands when a smaller range is selected

[mariongalley]

In Live, the Award Date chart shows smaller bands (I think quarters) and dynamically updates the labels to show years for large ranges and quarters for smaller ranges. In dev the Award Date chart only ever shows years even if it's only 1 or 2 years.

[KDuerden]

Current Insights award date chart is broken down to months and I think the breakdown does need to be to the month level when zoomed in to date ranges - as the date range selector is broken down by months, so if there isn't this level of detail you can't see the results of your filtered selection.

The title text only gives the date range at the year level, so this chart is the only level of detail users have to know the approx dates.

[michaelwood]

What's the expectation on filtering if the graph changes to be month based for example?

No longer "zooming" into the graph is a product of making the graph bands clickable in order to filter by them coupled with the "Older" column needing a change of graphing library as the previous one (in Live) required an unreliable work-around.

[michaelwood]

I talked with @R2ZER0 and this would be an advanced feature to have.

It was possible previously because Live insights used a different graphing library that isn't compatible with what we currently want to do and it maintained its own own database of grants (and various other queries and logic) that allowed querying to a more granular date level that isn't supported by GrantNav (also the reason why live insights is very slow).

Maintaining this as a filterable graph that's consistent with the others, keeping the "Older" feature and making it more granular would involve developing:

• A new aggregate field on grant award date by month (or Quarter etc)
• A filter selection UI in GrantNav that can do the same filtering so that the two way integration continues to work
• An extension (or finding an existing one) to the graphing library to allow zooming/selection by a time period or breaking out the graph into a secondary graph
• New tests

All of the above would be a minimum of 1 dev week to do. The current budget doesn't allow for this and having talked with @mariongalley about the options we're going put this on the backlog to revisit.