How to only show the amount of monthly value only once instead of the sum over the whole period?
Hi, so I have a dataset that looks like this (fictive dataset):
Employee Name Date Sales Monthly Quota
Sally 11/3/2018 5,000 10,000
Andrew 11/3/2018 4,500 15,000
Michelle 11/4/2018 3,500 9,000
Sally 11/6/2018 1,000 10,000
Sally 11/7/2018 700 10,000
Andrew 11/8/2018 2,500 15,000
Andrew 11/9/2018 3,000 15,000
Sally 12/4/2018 2,000 10,000
Michelle 12/6/2018 4,500 9,000
I am making a card using the dataset, but how do I make the monthly quarter appear as monthly quota for each person, instead of the sum of all monthly quotas for each person, which is what's happening now?
Comments
-
Depending on the card type, either show the average or using no aggregation might work.
Thsi will not work if you then change the date grain to say yearly nor will a table total work either. If you need it to work under those scenarios, I would split the data set(sales and quotas), remove the duplicated quotas and reappend the quotas so that they are on different rows as the sales
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive