Symptom
- In the Chart Structure components, if we choose Numeric to fetch the Measures count then the values will be in Decimal.
- How to change decimal or number format in Table widgets
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
- SuccessFactors HXM Suite
- Analytics & Reporting (Ad Hoc, YouCalc, ORD)
- People Analytics (Analytics Cloud for SF)
- Query Designer - Filter, Calculated Column, Params
- People Analytics (Analytics Cloud for SF)
- Analytics & Reporting (Ad Hoc, YouCalc, ORD)
Reproducing the Issue
1. Go to the Report Center.
2. Create a new Story.
3. Add Chart Structure Component with Numeric Point.
4. Measures added might fetch the count with decimal points.
Cause
Decimal places format of Measures should be set correctly.
Resolution
1. Open Designer of the impacted component.
2. Select a measure (3 dots) -> Click on 'Format'
3. Change the decimal places to 0 under Formatting.
4. Numeric component measures will be fetched without decimal numbers.
For Charts there is another way to set the format:
1. Select Chart
2. Click Edit
3. Go to Styling by clicking paintbrush icon > Number Format -> set Decimal Places to 0
As for Table widgets:
1. Select the column within the widget and right-click
2. From the options select Table Functions >
3. Select Edit Styling
4. Go to Number Format > Decimal Place > Set it to 0
Keywords
decimal, story, chart, number, point, table decimal, table styling, widget number format, decimal places , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , LOD-SF-ANA-SAC , Stories in People Analytics , How To
Product
Attachments
Pasted image.png |