Fixed Functions... fixed

I would like the ability to pass the date grain from the card or page into a fixed function as a variable. Currently, I have a fixed function that is fixed by month for example. This works perfectly when the card or the dashboard it is used in is set to look at the data at a monthly level. However, I would like to be able to change the dashboard to graph by quarter, or year and have the fixed partition adjust to those date grains.
Comments
-
Agree, things like
date grain
,date range start
anddate range end
should be available to be used in BeastModes just like variables, as often you'd need to adjust calculations based on these values.1 -
This would be super helpful to make fixed functions more flexible. If a card uses a function fixed by month, then it will show incorrect information if the user changes the date grain of the card. An alternative would be to hide the card's date range altogether, but that also removes the ability to filter by date.
0 -
In your formula, are you doing something like FIXED (BY Month('date')) ?
If so, you do not need the MONTH formula. I have found it works well with fixing by the date and gives me the flexibility you are looking for.
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 310 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 114 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 797 Beast Mode
- 78 App Studio
- 44 Variables
- 757 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 72 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive