Best Of
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
Compare two peer groups
Hi, I'm not sure if this is possible using DOMO native toolset. I would love to be able to compare two peers groups performance against each other. A super simple select and compare of two things dynamically.
For example if this is my data:
Campaign | Money Made
A | $5
B | $10
C | $20
D | $5
How can I create a card where I can mix/match compare on one chart? Something like the screenshot below.
Basically what I'd like to do is create a filter that's called 'Campaign Group 1' and be able to select A and B. Then have another filter celled 'Campaign Group 2' and select C and D. Then have the chart show two bars -- one showing how Campaign Group 1 performed and one showing how Campaign Group 2 performs.
I know I can make variables that allow selection of specific hard coded strings, but I don't really see a dynamic variable option where I can have two selections based on string values that are in the dataset and it's not feasible to input tons of list items (campaigns) manually.
Hoping there's an easy solution! Thanks all.
G_Grey