Skip to content
Advertisement

SQL- parse data

I am creating a Test Automation ‘Health Page’

On this page I would like to display a 7 day trend of how many tests ended with status PASS/FAIL/UNDEFINED. I am doing it in Oracle Application Express. I would like the graph to look something like this: enter image description here

However I do not know how to separate the results into days. Here is my count query:

This is the result of the query:

enter image description here

How can I change the query to give me a result for DAY 1, DAY 2, DAY3 etc(Im ok if it also shows shortened version of date in format ‘DD-MM’)?

to_char(EXE.ACTUAL_END_DATE,’DD-MM’) as DAY ,

Advertisement

Answer

You can use GROUP BY and to_char(actual_Start_date ,'d')which would return 1 – 7

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement