opaolilo/sqlite-data-viz-delight

Promote version e6515ed to main

Do not apply any changes on dashboard page and current functions. From "Monitoring" page delete the following charts: Status Count by Date, Events by Source ID and Events Count by Source ID

Promote version e6515ed to main

delete this block

Do not apply any changes on dashboard page and current functions. From "Monitoring" page delete the following charts: Status Count by Date, Status Proportion, Events by Source ID and Events Count by Source ID

Promote version e2d3558 to main

Do not apply any changes on dashboard page and current functions. Add Overview block to "Monitoring" page with the same design and functions

Do not apply any changes on dashboard page and current functions. Add Overview block to "Monitoring" page with the same design and functions from the same block listed on "Dashboard" page

Do not apply any changes on dashboard page and current functions. From "Monitoring" page delete the following charts: Status Count by Date, Status Proportion, Status Trend, Events by Source ID and Events Count by Source ID

Promote version e2d3558 to main

from Monitoring page remove the following charts: Status Count by Date, Status Proportion, Status Trend, Events by Source ID and Events Count by Source ID

copy "Dashboards" page to a new page called "Monitoring". Keep same layout, design and functions

Promote version 52bdfbd to main

copy "Dashboards" page to a new page called "Alarms"

delete "Alarms" page

create the same block on "Alarms" page

Do not apply any changes on dashboard page and current functions. Create a new function to monitor the count of status_api per specific amount of time using the query below, where "-30" must be a variable input listed on "Alarms" page and the possible status_api are

add the option to Upload SQLite Database same as listed on "Dashboard" page. also add the time range option for the last 2160 hours

Do not apply any changes on dashboard page and current functions. Create a monitoring dashboard on "Alarms" page to monitor the count of status_api per specific amount of time using the query below, where "-30" must be a variable input listed on "Alarms" page. Query:

Promote version 78d9cf8 to main

Do not apply any changes on dashboard page and current functions. Create a new function to monitor the count of status_api per specific amount of time using the query below, where "-30" must be a variable input listed on "Alarms" page. Update "Alarms" page to have a monitoring dashboard with options to set the monitoring amount of time and status_api count thresholds to trigger alarms per status_api listed in expectedStatus. Query: SELECT

Promote version 78d9cf8 to main

on the "Alarms" page, create a monitoring dashboard that monitors the number of status_api count per specific amount of time using the query above, where "-30" should be a variable set on "Alarms" page. Query: SELECT

Promote version 78d9cf8 to main

create a new function to monitor the status_api count for a specific amount of time using the following query: SELECT

create a header with modern menu that should contain 3 pages: Dashboard, Alarms and Configuration. Dashboards should be the home page.

add options to automatically refresh every 5 , 15 and 60 seconds

add a new function to count the number of events per source_id using the following query: SELECT source_id, COUNT(*) as total

create a new function to count the number of events per date and per source using the following query: SELECT

Promote version b769815 to main

create a new function to count the number of events per source per day using the following query:

delete the icon and the test listed in this block

delete this block

remove this block

Promote version 6584cdd to main

the filter from Status Count by Date chart is not working. Please fix the filter

Promote version 9dc3e2a to main

the filter must list only the lines related to the status selected

add a filter by status appliable only in the chart from this block

Promote version 6584cdd to main

add a filter by status

add a space between this block and the next block

move this block to be just after Upload SQLite Database block

Promote version 49c089e to main

move Status Count by Date chart to above Request Status Distribution chart

update Status Count by Date chart to have the same style as Status Trend chart, where vertical values should vary based on the status_api count value and horizontal value should list the dates listed in month_day response from dateStatusQuery. Every status_api count value should be shown as a line in the chart

Promote version 8424544 to main

update "Status Count by Date" to list in the horizontal only the dates from "month_day" listed in dateStatusQuery. The status_api count value must be listed as line chart

add a new function to extract and list the status count per date. Use the following query to get the data from DB: SELECT

Promote version 3116728 to main