Best Of
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.
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
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
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.
Re: Splitting up multiple-value fields into multiple rows
@jrtomici Do you have a maximum number of items that could be in your comma-separated list? If so, you could use the Split Columns tile in MagicETL to break them each out. Then you would need to create a branch of the dataflow for each split to filter to the rows that have a value in that position and rename the field you filtered to "Num". After that you can use an Append Rows tile to merge all your splits back together. Unfortunately it's a somewhat tedious setup, but that's how I've been able to work with it.
Re: Splitting up multiple-value fields into multiple rows
You could attempt to utilize a MySQL dataflow which would give you a bit more flexibility in this case but will execute slower. Here's an example I found which you could use as a template: https://stackoverflow.com/questions/5041537/mysql-csv-row-to-multiple-rows
Re: Row Count growth change
@renee12345 Here is an example that I believe will work for you. I changed two things. I changed the DAY() function to Date(). The DAY() function returns the numerical day of month (i.e. 15 for Dec 15th, 2022) and Date() will return the actual date (i.e. 2022-12-15). Another change I made was that I added in date_add to ensure it was pulling in yesterday's date. This wasn't necessary as curdate()-1 will also work here as @MichelleH pointed out.
(SUM(CASE WHEN DATE(`Snapshot Date`) = CURDATE() THEN `Row Count` ELSE 0 END)
-
SUM(CASE WHEN DATE(`Snapshot Date`) = DATE_ADD(CURDATE(), interval -1 day) THEN `Row Count` ELSE 0 END))
/
SUM(CASE WHEN DATE(`Snapshot Date`) = DATE_ADD(CURDATE(), interval -1 day) THEN `Row Count` ELSE 0 END)
McSQL