Versions Compared

Version Old Version 2 New Version 3
Changes made by

Scott Nightingale

Scott Nightingale

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Child pages (Children Display)
alltrue
depth3

API Interface V4

...

OpenAPI 3.0 Swagger Definition

...

Each Flow Dashboard user is automatically generated an API authentication token which can be found on the User Settings page under API Token

Data Definition

Calculating Aggregate Metrics

Extractions that Met Recipe

Code Block
SELECT COUNT(id) FROM extractions
WHERE extractions.recipeMatch NOT NULL
AND extractions.recipeMatch.recipeId = recipes.id
AND extraction.groupheadId = groupheads-recipes.groupheadId
AND recipe.id = grouphead-recipes.recipeId
AND extractions.duration BETWEEN recipes.durationMin AND recipes.durationMax
AND extractions.brewWaterVolume.value BETWEEN recipe-groupheads.brewWaterVolumeMin.value AND recipe-groupheads.brewWaterVolumeMax.value

Extractions that Missed on Time

Code Block
SELECT COUNT(id) FROM extractions
WHERE extractions.recipeMatch NOT NULL
AND extractions.recipeMatch.recipeId = recipes.id
AND extractions.duration NOT BETWEEN recipes.durationMin AND recipes.durationMax

Extractions that were Too Fast

Code Block
SELECT COUNT(id) FROM extractions
WHERE extractions.recipeMatch NOT NULL
AND extractions.recipeMatch.recipeId = recipes.id
AND extractions.duration < recipes.durationMin

Extractions that were Too Slow

Code Block
SELECT COUNT(id) FROM extractions
WHERE extractions.recipeMatch NOT NULL
AND extractions.recipeMatch.recipeId = recipes.id
AND extractions.duration > recipes.durationMax

Extractions that Missed on Volume

Code Block
SELECT COUNT(id) FROM extractions
WHERE extractions.recipeMatch NOT NULL
AND extractions.recipeMatch.recipeId = recipes.id
AND extraction.groupheadId = groupheads-recipes.groupheadId
AND recipe.id = grouphead-recipes.recipeId
AND extractions.brewWaterVolume.value NOT BETWEEN recipe-groupheads.brewWaterVolumeMin.value AND recipe-groupheads.brewWaterVolumeMax.value

Extractions that Missed on Both Time and Volume

Code Block
SELECT COUNT(id) FROM extractions
WHERE extractions.recipeMatch IS NULL