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:
but, file hila4.txt can re run again and we can get new messages:
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?