Why is my card grouped by month in the table but not in the chart, and how can I fix it?
So I am trying to create a rolling avg card, I have successfully created the 3 month lag in the BeastMode and tables as you can see below and it is grouped by each month. However, in the actual card/graph there are several values for each month instead of just one September, for instance there's like 5 Septembers. Any idea how i can fix this so they are grouped by individual month in the chart?
Answers
-
@RobSomers Hey Rob, Thanks for the response. I have no sorting on my card. I also have it sorted by month.
0 -
@RobSomers Hey, I've tried sorting using the Derived Persona Date and had no luck. One thing to mention is that I've grouped it by month and the dates usually go by day. Thanks again for the help.
0 -
@louisshh It sounds like your data is by day and you've just using your Derived Persona Date to use for graphing. Then you need to make sure all your columns that you're graphing are aggregated, otherwise it will graph each row individually. So you would need to aggregate !3monthlag and !Count of matched persona
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
2
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 762 Beast Mode
- 65 App Studio
- 42 Variables
- 704 Automate
- 182 Apps
- 458 APIs & Domo Developer
- 53 Workflows
- 11 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 132 Manage
- 129 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive