Symptom
This KBA describes how to report on the Total Logins per Month, Year to Date (YTD) and the Total Logins to Date.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental
Environment
- SAP SuccessFactors Workforce Analytics
- Adhoc
Resolution
You have created an ad Hoc Report using the Login Data domain and want to see for a specific user the Total Logins per Month, Year and overall Total to Date.
You can create such report using the Logins This Month, Logins YTD and Total Logins fields and grouping them as follow:
Group By Sum(Logins This Month), Sum(Logins YTD), Count(Total Logins);
Group By: User Name, First Name, Last Name, User ID;
This can be done by:
- Add the desired columns to the report and the Logins This Month, Logins YTD, Total Logins columns.
- In the column section, choose the option Group By and select Logins This Month, Logins YTD as sum and Total Logins as count
- Save and preview the report and you should be able to display the specific user the Total Logins per Month, Year and overall Total to Date.
See Also
Keywords
Ad Hoc report, Login data, adhoc report, Count logins , KBA , LOD-SF-PLT , Platform Foundational Capabilities , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , How To