Best Of
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
Re: Filtering null values on a card
@gbrown how are you filtering? are you filtering on each beast mode where equal to null? (I.e. 3 filters in the filter section?) Because that would filter out any rows where they are null even if the others all null and you'd only get rows where all three are not null.
mhouston