SAP Knowledge Base Article - Public

2347666 - Dashboards Tile Drill Down Shows no results when a DATE and Timestamp field is used as Chart Category

Symptom

A Date and a  Timestamp Field (any Date/Timestamp Field from the queried domain) is selected as chart data Category (X-axis).  The Dashboard tile shows the correct data in the chart, however no details are displayed in the drill down.

When a Non-Date or none-timestamp Field is used, the drill down shows results.

Environment

SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Step through each item in the Analytics Tile Builder process (Admin Center > Manage Dashboards > Manage Standard Dashboards and YouCalc Files > Analytics Tile Builder).
  2. Choose your domain.  In setting up the tile, select a Date / Timestamp field as a Category for the chart data. 
  3. You will notice the following message prompt: "Looks like you have selected a date field as a category.  Please note that date fields are currently not supported as a category.  No drill down list will be available"
    Information message for Chart Date Category.jpg
  4. Confirm fields needed in the Drill Down tab.
  5. Preview the tile and drill down on a specific column.
  6. Result with Date field: Drill down shows no data/results.

Dashboards 2.0 no drill down for chart with date category.jpg

Result with timestamp field: Error message.

timestamp2.jpg

Cause

Currently the pivot function in Dashboards 2.0 doesn’t work with date and timestamp values.

Resolution

Currently the pivot function in Dashboards 2.0 doesn’t work with date values.

A possible workaround is to use Adhoc reporting to get the details.

If you feel the behavior should be changed, please feel free to submit an enhancement request:
2090228 - How to submit enhancement requests for SAP SuccessFactors products

 

Keywords

Dashboards 2.0, Tile Builder, Dashboards Category, Chart Category, Date fields , KBA , LOD-SF-ANA-DSH , YouCalc Dashboards and Tiles (Dashboards 2.0) , Product Enhancement

Product

SAP SuccessFactors HCM Suite all versions