I want to create a vertical bar that while show me for each file, the last status of the file. I have files that can be in status: Start, Completed, Failed. I file that is in Failed status will be re-run and probably will move to a different status when the time passes. I want to create a query such as: select Distinct FileName, status from log
but when I'm looking on the diagram, I see that for 24 hours, the same files are in Start and Completed. And for a period of time I only want the last status of the file.
in my messages I have fileName and Status of the file, for example:
hila1.txt received
hila2.txt received
hila2.txt started
hila3.txt received
hila3.txt started
hila3.txt completed
hila4.txt received
hila4.txt started
hila4.txt failed.
but, file hila4.txt can re run again and we can get new messages:
hila4.txt received
hila4.txt started
hila4.txt completed
I want to create a View (Diagram) that will show me for the last status of
each file how many files in each status.
For this example:
received - 1
started - 1
completed - 2
failed - 0 (because hila4.txt had run again and succeeded).
can it be done?
Could someone please help me?