DHo Member

Maybe I'm missing something or rules have changed in Domo since this was posted … For first of the month, I don't think there's a need for the date_sub fanciness, just a simple date > concat. date( concat( year( date_col ), '-', month( date_col ), '-01' ) )

This missing feature is killing me. I need to be able to share links to dashboards with saved filter views applied. I'd also love for our team to be able to easily share a dashboard or vis with their chosen filters applied. Telling them to construct a pfilter before sharing is laughable.

This is a HUGE bummer! I'm just getting really deep with Domo and had assumed the "History" menu item meant I could restore. Now that I need it I see that history doesn't really provide any value 😞

Most of the time, I'd rather just run a slew of over/window functions in a formula tile rather than using the R&W tile at all. Then I can set individual partition and order parameters for each column. As far as I can tell, function tiles don't let you do that.

Thanks @GrantSmith. That's the work around I'm using. It works, but I wish I could do it all with a single function tile and string together a bunch of SQL statements. I've been trying to get the hang of Magic ETL, but I may have to switch back to a basic SQL flow for this particular data set.

Unless I've missed something in the Magic ETL R&W implementation, that's just going to populate my new column with a rank number. I want the "first date" value to be populated as the new column's value so I can use that for a later grouping/agg.

Great suggestion, @MarkSnodgrass 👌 I'll use that as a workaround.

🤔 How exactly would I do that? I'm "pitching in" here for a company that doesn't have a BI dev available right now. I'm looking at the js in the brick, but I'm not sure where your snippets would go. To answer your question, I'm just trying to set it up like a "normal" correlation matrix where each measure on the matrix is…

In this case the numbers are floating point rendered as currency. I've tried numbers that would trim the upper or lower limits. This isn't the first time I've tried in the last couple of weeks, but I think they all been floating point scales.

Is there any hope of Domo implementing the SQL FORMAT() AS function? This kind of workaround should not be necessary.

Thanks for the confirmation @GrantSmith. That's a bummer. I'll have to look into getting my hands dirty with the BI add-on and some python.