Best Of

Re: Using RegEx to Extract Date

Try this:

REGEXP_REPLACE(`string`, '^.*(\d{2}-[A-z]{3}-\d{4}).*$', '$1')

You need to replace the entire string not just the substring. This is why there's ^.* and .*$ to match anything before and after the date value respectively.

GrantSmith

2

Re: Dynamic Chart Height

This would be especially useful for scheduling reports off of dashboards since recipients cannot scroll. I often have to leave a significant amount of white space in the dashboard to avoid cutting off the table.

MichelleH

5

Re: PLEASE stop tables from auto-expanding when new items are added

Think this is a nice feature request - the option for Auto-collapsed, Auto-Expanded, or Expand New Items. Tables expanding when new items get added is frustrating when dashboards are designed to show summarised details with an option to go deeper.

BrettG

1

Re: How can I show % change summary # for Period over Period chart?

Thanks Grant. Yes, we have utilized non-period over period charts and created Beast Modes to capture the % change. It just seems like % change should go hand-in-hand with period over period charts and it would be much simpler that way so I am surprised Domo did not give these charts that capability. Perhaps a good idea to suggest.

MattGo

1

Re: Current Year, Prior Year, and Budget on Same Card

https://www.youtube.com/watch?v=CDKNOmKClms

Here you go @user054650 . If you have further questions, check out some of the videos on my channel!

If you're looking for one on one support, I am available at a reasonable rate to provide consulting services, reach out to me at jae@onyxreporting.com.

BTW @GrantSmith , in your solution you put the offset in the Report Date column. The offset should go into the Activity Date.

jaeW_at_Onyx

2