K4’s database offers an opportunity to review how your staff is working. An analysis of the data can offer insights as to when people and completing their tasks. At The Washingtonian we created a tool to provide a graphical report on how each article for an issue progresses. It shows the status of each article at the end of each day for a 6 week period. An interactive version of this report allows you to view the activity of each article for a given day. This analysis can be done with most workflow systems that provide access to their data.
The Graphic View database is a proof of concept written in 4th Dimension v11. Data about articles, text objects and layouts are imported into this database and a graphical representation of this data is created.
|In generating a report the user needs to select the issue, the type of data and the suffice, which is based on the naming convention. In this example we want all article objects from the Feb issue which end in “main”.|
|A spreadsheet is generated with a key. Along the top are the dates covering a 6 week period. A key shows the colors and corresponding status’. Below that are the objects that matched the search, in this case articles ending in “main”. By viewing each line you can see the days the object was checked into K4 and the last status at the end of that day.|
|Here is a view of another portion of the spreadsheet later in the month. We can see a lot more activity.|
|Click on any colored cell to see all activity for that object for the day. We can see that this object was check in 3 times this day and the status and other information for each check in.