Hi All,
Is there a way to have the name of the user who sent the event as a data element, so that it is possible to have this variable in the event report. I tried in the program rules but we don’t have any variables called, current_user.
Does anyone know of any way to have this variable for analysis?
Hello @prosper, I know this type of data, unfortunately it is not compatible with Android, just for the Web for now. That is why I am looking for alternatives to work around this limitation. I need an indicator that illustrates the user’s performance.
This is not directly related to your question of username as a data element in event reports, but for future viewers of this question, a SQL view can utilize the “storedby” column in the programstageinstance table to get the number of events storedby user, unique enrollments with events from the user, and unique org units of events from the event.
Here is the SQL View object for download and import. You could feasibly add to this view the month of the event, or filter for a particular data element value and specific stage.