Can't get This Quarter card filter to work as desired
I'm having an issue with my card where I want to reference information that is only within Quarter without using the date range field. I have multiple date columns that all have different meanings in the data set.
I have date fields for:
IO Start Date
IO End Date
Campaign Start Date
Campaign End Date
Revenue Period
I want the card to only look at data within the current quarter for the Revenue Period field. Unfortunitly using the "This Quarter" option doesn't do this, rather showing all campaigns meeting my criteria that with an IO start date of this Quarter but aggregating all of my Amount data which is broken out by Revenue Period for the entire campaign, regardless on if that Revenue Period is in this Quarter.
Is there a way to do this outside of referencing the current date's year/quarter and then only counting revenue period $s that meet that criteria?
Best Answer
-
I have a couple of questions and thoughts - not knowing what card you are using. But, in the card design, you can pick what date field you want it to focus on - one solution could be to use the Revenue Period date field in that spot. Now the card, filtered on this quarter will show the revenue that came in the quarter. From what I read in your post, that will do what you want. If there are other reasons for other date information / selection, let me know and we can work through it.Dojo Community Member
** Please like responses by clicking on the thumbs up
** Please Accept / check the answer that solved your problem / answered your question.1
Answers
-
I have a couple of questions and thoughts - not knowing what card you are using. But, in the card design, you can pick what date field you want it to focus on - one solution could be to use the Revenue Period date field in that spot. Now the card, filtered on this quarter will show the revenue that came in the quarter. From what I read in your post, that will do what you want. If there are other reasons for other date information / selection, let me know and we can work through it.Dojo Community Member
** Please like responses by clicking on the thumbs up
** Please Accept / check the answer that solved your problem / answered your question.1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive