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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 198 Visualize
- 254 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 178 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive