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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 473 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 211 Visualize
- 257 Beast Mode
- 2.1K Charting
- 12 Variables
- 18 Automate
- 355 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
- 183 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive