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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 6 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 781 Automate
- 191 Apps
- 483 APIs & Domo Developer
- 84 Workflows
- 23 Code Engine
- 42 AI and Machine Learning
- 22 AI Chat
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 408 Distribute
- 116 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 146 Manage
- 142 Governance & Security
- 8 Domo Community Gallery
- 49 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive