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
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 88 SQL DataFlows
- 554 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 564 Beast Mode
- 9 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive