Multiple instances of same week numbers

Kunal

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

RobSomers

@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.

Kunal

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.

RobSomers

Do you mind posting a screenshot of your sorts?

Kunal

Here you go !

RobSomers

@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.

Kunal

@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

MichelleH

@Kunal You should not need to sort by your date field since Domo will automatically sort by whatever date is in the X-Axis. If you manually add a sort date without aggregation, you could see duplicate dates since it will try to sort by every unique date

Kunal

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

MichelleH

@Kunal You can still have the rank and window in your ETL. I'm referring to the sort fields that are applied to the card in Analyzer.

Kunal

@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

MichelleH

@Kunal Do you have any aggregation on your Y-Axis field?

Kunal

That's what my data looks like and I'm plotting Account Balance vs Batch Date

RobSomers

@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.