XYCharts Broken [2022:O]

[Ghislain Hachey]

The initial implementation of this seems not to work on production. I also can’t get it to work on my development machine.

[Brian Lewis]

see issue #171.

significant work was put into this as part of “stress-testing” e-charts (~ 1 week) but was ultimately bumped from 2020 workplan as low priority, and therefore unfunded.

Would be good to finish it off if there is space in the budget to prioritize.

‌

‌

[Brian Lewis]

The issue is that the queries underpinning this (used verbatim from the desktop version) do not use the warehouse, and are unhappy because there is a Survey record for year 2021 - so that becomes the default base year - but there is no SchoolSurvey records for that year. It errors and does not recover. To get it to work, I removed the 2021 record from survey.

‌

[Ghislain Hachey]

@Brian Lewis Time estimate to complete it?

Note that there are survey record for 2021 for yap in the most recent production DB

[Ghislain Hachey]

@Brian Lewis this remains broken. I have records for two states in SchoolSurvey or 2021 but still seem the scatter components tries to generate the echart with no dataset and results in error. I will leave this with you as one of the deliverables with Kiribati is to finalize the XYChart.

[Ghislain Hachey]

Covered by Kiribati’s “'XY Charts' - charting functionality that allows exporation of correlations between datasets.”

[Brian Lewis]

feat(XYCharts): fix issue with not displaying when current survey year is empty (use most recent warehouse year) Add new charts x/y , y - x, x- y. Prevent error when no data is available for specified year

Resolves #1026

→ <<cset 3929e4b504c6>>

[Brian Lewis]

feat(xycharts): New sets of indicators derived from warehouse data

Resolve #1026

→ <<cset 41e1c26e1d78>>