Format as number without comma
I have a new version of an existing dashboard. The dashboard has a dropdown selector for year. Year is a formula field on the ETL defined as Year(`transaction_date`). On my original dashboard I see 2023, 2022, 2021. On the new version, I can't get the filter to remove the thousands comma. So I see "2,023" instead of "2023".
I've compared with my old dashboard and everything is the same. I can't figure out why Domo won't drop the comma. Any ideas?
Here's the format dropdown. The separator is unchecked but the card is still showing commas. I've cleared cache and closed and reopened my browser.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **
Best Answer
-
Solved it.
When I couldn't get rid of the comma, my first guess was also to change the field to text using concat() but it didn't work. My previous version workflow still exists under a different name and it works just fine. Both use the same formula for creation and I duplicated the card being used as a dropdown filter.
Removing the optional field causes 2 of the three dates to drop off and show an error to the user. But I had not considered that the optional field's format setting was affecting the dropdown. I went to the optional field and verified it was also set to number without commas and the comma indeed went away.
Thanks for the responses.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1
Answers
-
John Le
You're only one dashboard away.
Click here for more video solutions:
1 -
@ArborRose Alternatively, you could also change your field from a number to text in your ETL
1 -
You can also make it a text in a beast mode by wrapping a CONCAT() statement around it and put that in the items list:
CONCAT(yearfield)
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Solved it.
When I couldn't get rid of the comma, my first guess was also to change the field to text using concat() but it didn't work. My previous version workflow still exists under a different name and it works just fine. Both use the same formula for creation and I duplicated the card being used as a dropdown filter.
Removing the optional field causes 2 of the three dates to drop off and show an error to the user. But I had not considered that the optional field's format setting was affecting the dropdown. I went to the optional field and verified it was also set to number without commas and the comma indeed went away.
Thanks for the responses.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive