2347666 - Dashboards 2.0 - Tile drill down shows no results when a DATE and Timestamp field is used as Category

SAP Knowledge Base Article - Public

2347666 - Dashboards 2.0 - Tile drill down shows no results when a DATE and Timestamp field is used as Category

Symptom

A Date and a  Timestamp Field (any Date/Timestamp Field from the queried domain) 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

SuccessFactors Workforce Analytics (ANA) - All versions

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. Confirm fields needed in the Drill Down tab.
  4. Preview the tile and drill down on a specific column.

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.  Please see JIRA 'CALC-2778 Dashboard Tile not showing data properly’.

Resolution

 Currently the pivot function in Dashboards 2.0 doesn’t work with date values.  Please see JIRA 'CALC-2778 Dashboard Tile not showing data properly’.

 This is an enhancement request as confirmed by Product Management.  A possible workaround is to use Adhoc reporting to get the details.

 

Keywords

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

Product

SAP SuccessFactors Workforce Analytics all versions