Using a Calculated Field to Help With Row Count Against Imported Data
Enterprise Users will be able to view and interact with pages. Performance Managers/Modellers can edit pages and objects, and Model Administrators have full permissions.
You will still need to check your personal permissions to access this area with your site Administrator.
When using an Excel document or CSV file to import data into the Ideagen Healthcare Guardian system you may want to count how many records there are.
Ideagen Healthcare Guardian doesn’t use a row count function to calculate this, but you can add a count column to help with reporting.
An example would be having a table showing the dates of all the times someone reported an issue, and the category of the issue and who reported it. If you wanted to use Ideagen Healthcare Guardian to tell you “How many people reported Issue X last month”, you would need to use a count column to help the system count the records for you.
To do this you will need to access your data connection from the administrator and open your CSV/xls connection.
You then need to click on “Insert Calculated Field” to open up the Calculated field Editor.
You then need to:
- Drag on the “Custom Value” operator into the editor box.
- Type “1” into the new text box.
- Name your new field “Count”.
Click on the green “Save Field” button and you will see a new column has been added with the numerical value of “1”.
This will allow the system to count each column based on your other criteria to give you a total count of those criteria.