In this case this means that this injury has not had a classification selected in the Vault system. In the next few steps we will look at seeing a classification in BI to allow us to see the number of Events with no Classification.
To do this we need to create a calculated field and set up a case to return a user-defined classification where nothing has been returned or the record is null. For this example, we are looking at Events and Event Classification.
1. In the Report Builder, press the + button at the bottom of the fields list to add a calculated field
2. Name the field - For this example I have named it "Re-Classification".
Press Case and then When; this will open a new window.
3. In the When section, select Classification where indicated.
4. Next, select "Is Null" as the Operator and press Add.
5. Next enter your Then definition, as per below add what you require returned. In this case we would like "No Classification" to be returned when there is a null/blank record returned under classification.
6. You should now see the below. Click save.
7. To ensure that the other classifications are still returned you will now need to select ELSE this will ensure the other classifications are also returned. To do this select ELSE as per below.
8. This will bring up a new window, select Classification and save
9. You can now close off your calculated field by selecting END and then save.
Note: as this stage you can also Validate your query to ensure all steps have been completed and your statement is correct.
10. Under the Calculated Fields category, your newly created field will appear "Re-Classification"
11. Drag the field into the report.
As you can now see (above) Row 260 in column Re-Classification is now showing No Classification as set up in our calculated field. You can remove or hide the original Classification column to show the one result.
Done! You are now ready to proceed with your report.