Best Of

Re: Add Left- and Right-Anti-Joins to JOIN Tile in Magic ETL 2.0.

@Highland This would be nice. I do want to point out that there is a simpler way to accomplish this without the formula tile in current state. All you would need to do is have a filter after the join to only include rows where the join key from Table B is null. Hopefully that makes a slightly easier work-around in the meantime!

MichelleH

1

Re: Add a line option for symbols... and the ability to add multiple measure and a dimension to charts

A lot of what you're describing can be done with bullet charts. It has that satisfying goal line for the bar to punch through, as well the ability to shade incremental goals in the background before the one big goal. You can't break it up into a stacked series, but I think you would end up with something easier to interpret than a stacked bar

DavidChurchman

1

Re: Dashboard Custom Page Breaks

I echo this idea, the ability to place custom page breaks would be very helpful! I was going to add this as a new idea, I am glad to see that others in the community agree.

KandiKraner

4

Re: Holidays between two dates

Since you can't do conditional joins within Magic ETL 2.0 what you can do is add a constant to both datasets in your ETL and call it Join Column with a value of 1. Then do a join on both datasets on the join column. Then feed that into a filter tile to filter where company_holiday_date is BETWEEN your date_start and date_end. Then you can do a group by and count the number of records you have, joining that metric back to your original dataset A based on the start and end dates to record the number of holidays between the two dates.

GrantSmith

2

Re: Existing dataset as output

If you go to the ETL and then click on Versions, you should be able to restore to a previous version where the output dataset existed.

https://domo-support.domo.com/s/article/360042923074?language=en_US

MarkSnodgrass

1

Re: Domo Publish Enhancements

Other improvements / bugs that need addressing are.

Dashboard filter options don't get published correctly to our subscriber instances.

Also some DEFAULT filters on our boards never show up in the subscriber instances.

Jones01

1

Re: Domo Publish Enhancements

It would also be nice to be able to delete unnecessary PDP rules. For example, we started using dynamic PDP, but we can't remove the old PDP rules we no longer need. This has resulted in hundreds of rows of unnecessary/unused PDP rules in some of our publication jobs.