Lightning Experience: Error when saving dashboard with table component when sorted on formula field column
Last updated 2017-09-08 ·Reference W-4144043 ·Reported By 3 users
Summary
When saving a dashboard in Lightning Experience where there is a table component sorted by a formula(number) field, an error is displayed stating that the field is not a valid column to sort by.
Repro
1. Create a formula field (format as a number) on the object of your choice
2. Create a tabular report based on the object selected in step 1
-Add a row limit sorting on the formula created in step 1
-Click Dashboard Settings and enter a field in the Name and the formula field in the Value and click ok
3. Save report
4. Create a dashboard
5. Add a table component based on the report you created
6. Save the dashboard
7. Note the error received: "[Object.Formulafield] is not a valid column to sort by."
Workaround
Use Classic interface to create and edit the dashboard.
Reported By (3)
Is it Fixed?
Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.