2667021 - Time series chart's tooltip shows the last day of the previous month, instead of the first day of the month in SAP Analytics Cloud (SAC)

• Time series chart's tooltip shows the last day of the previous month, instead of the first day of the month in SAP Analytics Cloud (SAC).
• The label of the same chart shows the correct date (first day of the month).
• The time dimension used in the time series chart is in a flat format (not hierarchical).

• SAP Analytics Cloud (SAC)
• SAP Cloud Platform

1. Log on to SAP Analytics Cloud (SAC).
2. Create a new story, using a model created from SAP Cloud Platform Live Data Connection.
3. Insert a time series chart.
4. Add a time dimension and a measure.
5. Hover on a data point on the chart.
6. Observe that the tooltip shows the last day of the month, however it should show the first day of the current month.
   For example: Tooltip shows 2018.02.28, however on the chart 2018.03.01 can be seen.

This is expect behavior for Time series chart, x-Axis of Time Series Chart always uses the first day of the month for labels. If hovering over the data point, the time will show the last day of month. The data point and lable doesn't line up ideally. 

There isn't a way to directly choose to view month level in a flat date from a live model in the product, but it would be possible to create a star join hierarchy in HANA(Data Souce) with the time data with a month level, and from there months could be chosen and the data would line up nicely.

• How to find User Assistance for SAP Analytics Cloud?
• Ask a question on the SAP Community!
• 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , LOD-ANA-DES , Story Design & Visualizations , Problem