Multiple instances of same week numbers
My dataset has a date field that has 2022 running data on it. When I'm trying to create a line chart using that date range, it is repeating those weeks. I want to have only one instance of that week. How to resolve this?
In the attached ss, you can see Week-6 getting repeated 3 times. I only want to see that week or any other week only once
Answers
-
@Kunal Are you sorting on any fields? That can sometimes cause this issue, so I would recommend removing any fields you're using to sort and see if there's one that's causing the problem.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
2 -
Thanks for your response, Rob. I'm actually kinda sorting it because I'm using the rank and window function to get the cumulative values (by sorting on dates). And then plotting the cumulative values against the dates. So I don't think I can remove the sorting.
0 -
Do you mind posting a screenshot of your sorts?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
0 -
Here you go !
0 -
@Kunal It will be an issue of sorting on your card, nothing in the ETL most likely. And I think the issue will probably be that in your card you need to sort by whatever date you're graphing by.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
1 -
@RobSomers I tried to sort it by Batch Date on my card but the repetition of weeks is still pertaining. I see this issue when I'm trying to view it per month too
0 -
Hi @MichelleH , so I'm dealing with cumulative data where I need to sum up each row and for that, I need to use the rank & window. That's where I'm sorting it by dates and aggregating the amount column by sum
0 -
@MichelleH actually that's one of the suggestions I got from Rob and tried it to see if it works. But currently, I'm not sorting anything on the card and I'm still having this issue
0 -
That's what my data looks like and I'm plotting Account Balance vs Batch Date
0 -
@Kunal I agree with @MichelleH. If you aren't doing any aggregation on the account balance, then it won't group and aggregate that field and it will just graph each line separately.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive