trafalger Coach

I would create a month beast mode (Monthname(DateColumn)), drag that to your X-Axis and then make a year (Year(DateColumn)) beast mode and use that as the series.

Or do a group by ID, find the greatest value and join it back on.

I'd use the Rank and Window Tile https://domohelp.domo.com/hc/en-us/articles/360042922814-Old-Magic-ETL-Tiles-Rank-and-Window and then partition by your ID.

How are you pulling it now? Manually? Could you use the SFTP connector?

this would be soooo useful!

In terms of filters for a new dashboard, you can embed page filters in a URL on a table card, I've used that a good amount to "jump" to a new dashboard with certain filters set: https://domohelp.domo.com/hc/en-us/articles/360042933114-Using-Pfilters-to-Apply-Filters-from-URL-Query-Parameters-to-Embedded-Dashboards

Updated link: https://www.btpartners.com/technology-blogs/servicetitan-connector-press-release

I will try updating, I'm not sure the last time that it's been updated.

What happens if you filter out SUM(Value) <> 0?

This is helpful, thank you @pydomoguy!

Congrats everyone! Well deserved across the board!

This should be fun!

This would be extremely helpful!

I love connecting with other Domo users and see other use cases!

And I agree with @MarkSnodgrass, if you can change the connector to append it's a 30-second fix instead of building out a recursive dataflow. 

It's something I've brought up with Domo, there needs to be a "return to here" option so you know how small to reduce things. 

Personally, I love using the bullet chart for this - you can set a target from a value in your datatset. 

@Sandis - I'd build a recursive dataflow to capture and collect each days data so you have 1 dataset with all of the data. Something like this using Magic: https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_ETL_DataFlow Or this using SQL:…

That usually has to do with the "height" of a page, once a page reaches a certain "height" Domo will warn you "Your content is getting taller" and then won't allow you to export as a PDF. You can either make your page shorter or just email the page. If it's a story, stories email really well. 

Thanks for the heads up on the Covid dataset, @DataMaven! Made this that hits my inbox every morning. 

Not sure if it's best practice, but Domo is adding the commas since it's formatted as a number. Quick way to fix this is to make a beast mode that is Concat(`numberfield`) and then Domo will view it as Text. Sometimes I've had to do Concat(`numberfield`, '') and add a space too. 

I think that was Domo giving the option to scroll the text - I don't think it has any function that I'm aware of other than that. 

The best way to transform the raw data would be with an ETL - either Magic or MySQL. If you are unfamiliar with SQL, I'd recommend the Magic ETL: https://www.domo.com/learn/video-magic-etl

Try removing the quotes around the "run-job" portion. Weirdly for me that works only having the path in quotes.

Thanks for the replies @ST_-Superman-_ and @Property_Ninja! Sorry I wasn't clear, what I'm actually doing is creating a pivot table with columns that change but was just testing out the stored procedure in domo. I just dumped the results of the stored procedure into a new table, called it in the next transform and then…

@ST_-Superman-_ I know this is an 8 month old post, but can you use a Called Stored Procedure as an output? I did this: Create Procedure GetAllDates() BEGIN Select * from `newexceltest`; end and then the next step is just Call GetAllDates but it won't output anything. Any ideas?

I figured it out - basically, I was adding dashes to my dataflow name like "dev-dataflow" but once I removed those it stopped happening. Lesson learned! 

Hmm that's pretty helpful! Thank you!