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
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 762 Beast Mode
- 65 App Studio
- 42 Variables
- 704 Automate
- 182 Apps
- 458 APIs & Domo Developer
- 53 Workflows
- 11 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 133 Manage
- 130 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive