SAP Knowledge Base Article - Public

2412424 - How to report on the Total Logins per Month, Year to Date (YTD) and the Total Logins to Date - Adhoc reports

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:

  1. Add the desired columns to the report and the Logins This Month, Logins YTD, Total Logins columns.
    • Select columns.jpg
  2. In the column section, choose the option Group By and select  Logins This Month, Logins YTD as sum and Total Logins as count
    • Define Aggregates.jpg
  3. 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.
    • Report result_2.jpg

See Also

2298105 - BizX: User Login Data Report

Keywords

Ad Hoc report, Login data, adhoc report, Count logins , KBA , LOD-SF-PLT , Foundational Capabilities & Tools , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , How To

Product

SAP SuccessFactors Workforce Analytics all versions