DQ Checks enhancement: add the ability to have different DQ Check definitions

[RDmitchell]

Expected Behavior

Feedback from City of San Francisco

Enhancement to the DQ Checks: Add the ability to have different DQ Check lists which could then be applied to different cycles. Similar to the List Settings feature. There are two use cases for this:

• Being able to differentiate between Audit DQ checks and Benchmark DQ Checks
• EPA regularly changes some of the alert fields (EX: Pre 2016 meter alerts were lumped together under general alert fields, now they are specific to Energy, waste or water). This poses a challenge when processing benchmarks from the pre 2016 cycles since the DQ checks cannot be used reliably. It currently requires us to not use the DQ checks on previous years or we have to change them and the change them back after DQ checking a previous cycle.

Actual Behavior

n/a

Steps to Reproduce

n/a

Instance Information

SHA: 1a8cd10 (2.3.3 release)

[nllong]

The good news is that the database will support this, but needs fleshing out, testing, and front end work. On Fri, Jul 20, 2018 at 13:51 RDmitchell notifications@github.com wrote:

Expected Behavior

Feedback from City of San Francisco

Enhancement to the DQ Checks: Add the ability to have different DQ Check lists which could then be applied to different cycles. Similar to the List Settings feature. There are two use cases for this:

• Being able to differentiate between Audit DQ checks and Benchmark DQ Checks
• EPA regularly changes some of the alert fields (EX: Pre 2016 meter alerts were lumped together under general alert fields, now they are specific to Energy, waste or water). This poses a challenge when processing benchmarks from the pre 2016 cycles since the DQ checks cannot be used reliably. It currently requires us to not use the DQ checks on previous years or we have to change them and the change them back after DQ checking a previous cycle.

Actual Behavior

n/a Steps to Reproduce

n/a Instance Information

SHA: 1a8cd10 https://github.com/SEED-platform/seed/commit/1a8cd10ee7752c7d9e2bb3c5193fc9b59552fee6 (2.3.3 release)

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/SEED-platform/seed/issues/1679, or mute the thread https://github.com/notifications/unsubscribe-auth/AB0ami3Nz2jv-LdjXC48L4RIAsU1-GRvks5uIjSxgaJpZM4VZHjb .

[RDmitchell]

@nllong -- In talking to the City of Berkeley today, they reiterated that they would like to have the capability to have multiple definitions of DQ check "lists" (like profile settings, ie, can save a set of DQ checks to a "name") -- they import:

• Home Energy Score files -- this would have a different set of DQ checks than benchmarking
• ESPM Benchmarking files -- different DQ checks than HES
• Asset Score Audit Template -- then there is this file type that will be imported, and they would like to have DQ checks on that file, and that would also need a separate set of checks.

[github-actions[bot]]

This issue has been automatically marked as stale because it has not had recent activity within 60 days. It will be closed if no further activity occurs. Thank you for your contributions.

[github-actions[bot]]

This issue has been closed automatically. If this still affects you please re-open this issue with a comment or contact us so we can look into resolving it.