Assign date range field on a per column basis

dp4ge
Member
I have a single table that some columns or calculations use one date field and other columns use another date field.
However domo only allows you to associate a single date field to the entire chart/table. This is extremely frustrating.
For example the red columns use TransactionDate but the green columns use InvoicePostedDate
My workaround is I lose the ability for a user to use the date filters altogether. I have to hardcode my date ranges (YTD, MTD, PriorYear, PriorMonth, etc) in beast mode and that is extremely time consuming and limiting as it doesn't allow the user to put custom date ranges.
1
Comments
-
Related to
1
Categories
- 10.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 477 Transform
- 1.8K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 218 Visualize
- 260 Beast Mode
- 2.1K Charting
- 12 Variables
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 249 Distribute
- 65 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 191 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive