Any help with the following would be much appreciated.
My original dataset is from a proprietary software that is updated daily.
I have a dataset where I would like to calculate the total number of units we have month-on-month. Currently, I can calculate this as a Summary Number on a card - but I would like to be able to make a card from this data and utilise it.
The Summary Number is calculated by:
- count of
- filtered to remove where
columnX= "REMOVED" and
columnX will hold a value until it is physically removed at which point it is updated to "REMOVED" status. Currently, there is no date/time associated with the move of this from the previous value to "REMOVED", so it is difficult to track the Summary Number for each month.
Rows are also added on to the original dataset, but there is a
DateAdded column that shows when this has happened. Each row has a unique value in the
I have been reading about recursive dataflows and believe this may be the way to go, but would appreciate any help in setting this up.
Thanks in advance and hope this is clear enough.
- 10.6K All Categories
- 13 Getting Started in the Community
- 30 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 301 Use Cases & Best Practices
- 499 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- 4 Private Company Board