Symptom
When create single domain report "login data" report by using columns "Login YTD" and "Login this month" and "Login this month".
Even a user has multiple login history, data has been generated not in a total number but in separate lines.
The result will be displayed as below:
User Id | Last Name | First name | First Login | Last login | Login YTD | Login this month | Login this month |
UserA | A | User | 9/24/2015 | 9/24/2015 | 1 | 1 | 1 |
UserA | A | User | 9/8/2015 | 9/8/2015 | 1 | 1 | 1 |
Even this user has mutiple entries in a month, it will only be showed in single entry as "1" not in a total number.
Environment
Bizx Core B1508
Reproducing the Issue
1. Go to “Reports” > Ad hoc reports> login data
2. Add Columns “Logins YTD” &”Login This Month” &”Total Logins”
3. Click Preview
> Login YTD and Login this month and Total login are all “1”.
> Last login and first login is the same day.
Cause
In Login adhoc report data is displayed as it s fetched from DB. You are getting single entries as their is unique data for first and last login for each day.
Hence this is system's expected behavior to fetch the data each day and generate data in single entry.
Resolution
You can put count on total logins columns and select username column. You can put filter on First and Last login depending on date range you want with greater than or less than operators. You will get same data. In adhoc report we need to do additional operations on the data to get desired output.
Keywords
login data, output,single data,Total Logins, Count of login , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Problem