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 toany 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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 198 Visualize
- 254 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 176 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive