Best Of
Re: Header Labels on Pivot Chart
@NateBI I don't believe this is an option, but I would recommend submitting this to the Ideas Exchange.
Re: Case Syntax
Instead of using ELSE WHEN just use WHEN for additional cases. Use just ELSE for your default clause.
Re: Multiple instances of same week numbers
@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.
Re: Multiple instances of same week numbers
@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
Re: Multiple instances of same week numbers
@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.
Re: Multiple instances of same week numbers
@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.
Re: Multiple instances of same week numbers
@Kunal Do you have any aggregation on your Y-Axis field?
Re: Multiple instances of same week numbers
@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.
Re: Aggregation on Lag/Lead functions
This isn't possible as you can't aggregate a window function within a beast mode. What you'd need to do is perform your lag in an ETL and then calculate the average in your card. You may lose some filtering abilities as it's going to be pre-aggregated.
Re: Is there a dataset that shows how long a Workbench Job takes to run?
@Jack_Kaye it looks like you can get this from the Domo Governance connector in the Datasets History report. That has run time, as well as start and end time. You could filter on type to get just the workbench type datasets.
mhouston