Inflectra Customer Forums: Creating a custom graph or report with time as function (Thread) Hi! Im looking for a way to create a burndown chart from all the test cases not in Passed, grouped by day. One of the built-in widgets in SpiraTest 5.4.0.4 does this so Im sure theres a table to reference to. Could I have an example of ESQL that lists the non-passed test cases per day? Best regards, Tuomas en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spiratest/issues-questions/1901.aspxthreadId=1901Tuomas Peurakoski (tuomas.peurakoski@sogeti.com)esql custom graphs groupingCreating a custom graph or report with time as function Hi! Im looking for a way to create a burndown chart from all the test cases not in Passed, grouped by day. One of the built-in widgets in SpiraTest 5.4.0.4 does this so Im sure theres a table to reference to. Could I have an example of ESQL that lists the non-passed test cases per day? Best regards, Tuomas Mon, 20 Aug 2018 06:24:11 -04002018-08-25T13:18:17-04:00/Support/Forum/spiratest/issues-questions/1901.aspxmessageId=3383Jim R (donotreply5@kronodesk.net) Hi Tuomas, Many of the standard graphs have complex sets of queries iterated over a date range. Th Hi Tuomas, Many of the standard graphs have complex sets of queries iterated over a date range. They are not simple ESQL queries Im afraid. Please check out the Reports forum where users and also Inflectra team members have posted various report examples. Regards Jim. Sat, 25 Aug 2018 13:18:17 -04002018-08-25T13:18:17-04:00/Support/Forum/spiratest/issues-questions/1901.aspx#reply3383