BlueRooster Domo Employee

So if you're joining on date, you'll need to do something to take care of the "last week" data that is reporting back every 10 minutes. If you remove the timestamp and then join on date, you'll end up with every date in the last week being matched to every other row with that day (so instead of a 1 to 1 join you end up…

Any chance you could provide some example values of the two datasets you're wanting to join as well as what you're wanting to happen? We should be able to provide more help with some more detail. Sincerely, ValiantSpur

For ease of use I broke this into 2 date filters. You can create each in a beastmode and set them as filters. Select all dates within the last 13 months: CASE WHEN `date` >= DATE_SUB(DATE_FORMAT(CURRENT_DATE, '%Y-%m-01'), INTERVAL 13 MONTH) THEN 1 ELSE 0 END (To use the above filter, set value = to 1) Select MTD up to end…

How are you wanting to use the date filters? If can provide a bit more info on usage, i'll see if I can't write up something to help. Sincerely, ValiantSpur

If you're wanting to remove rows where the product is computer or laptop and the value is between that range you could do something like this: CASE WHEN `Product Name` IN ('Computer','Laptop) AND `Amount` >= -100 AND `Amount` <= 100 THEN 1 ELSE 0 END If you use that beastmode as your filter value and set it = to 0 then you…

The quickest way to do that would be to apply one of your filters, then click the Wrench -> Save As and save a new version of the card. You can repeat the process for each of the 3 filters. Is that what you're looking for? Sincerely, ValiantSpur

If you go the report scheduler The go the elipsis and select Edit Schedule . You will then be able to remove yourself from the recipients list. Hopefully this helps, ValiantSpur **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the post that helped you.

Under the measure for your bar values, do you have any format set? See screenshot for reference:

Can you walk me through what you're trying to do with your code? As I'm reading it sounds like: When the sum of grossrevenue (From weeks prior to the current week) > 100 AND When the sum of grossrevenue (from 12 weeks ago) < 10 THEN Sum grossrevenue prior to current week Is there a reason you aren't just using sum(CASE…

You could do something like this: CASE WHEN WEEK(DATE_SUB(Current_Date(), INTERVAL 12 WEEK)) = WEEK(`DateField`) AND YEAR(DATE_SUB(Current_Date(), INTERVAL 12 WEEK)) = YEAR(`DateField`) THEN `Revenue` END That would compare the week # and year from 12 weeks ago to each date field's week # and year. If matching then it…

So that top row on the "What we want" image is actually a count of the blank or null values in your pivot. To get your second example to do the same behavior, you would need to do something like this to your data: SELECT `CustomerName`, `Date`, `SubmissionID` FROM CustomerSubmissions UNION ALL SELECT '' AS 'CustomerName',…

I'm not aware of a way to move the total from the top or bottom. Is it possible that you're looking at the Subtotal section as shown in the screenshot from this Pivot View section here? https://knowledge.domo.com/Welcome/Domo_User_Interface/12Sumo_Editor_Layout#Pivot_View Or is it the Grand Total row itself that you have…

So I haven't been able to reproduce this issue in my environment. Is there any chance you could include a small screenshot of the behavior? One other thing that might be worth checking is the "Hover Text Settings" and checking the "Use Scale Abbreviation" there. Maybe that will be what you're looking for? Sincerely,…

I'm not sure if it's possible to do what you're wanting in the running total card. What I would do is use a SQL transform like so to SUM the values ahead of time. Here's a sample I tested using your numbers: SELECT a.`Time`, (SELECT SUM(b.`Amount1`) FROM testing as b WHERE b.`Time` <= a.`Time`) AS 'Sum1', (SELECT…

To my knowledge this wouldn't currently be possible. I think you would need a "Color" option under Column -> Format section. Sounds like a useful idea though. Unless someone else knows a workaround, perhaps log it as an idea: https://dojo.domo.com/t5/Ideas-Exchange/idb-p/Ideas

The magnifying glass up in the top right corner of the application will allow you to search title and description fields within your Domo cards. Just enter the text in the search box that comes up and then click on the "Cards" tab to look at the results for your card. Let me know if this isn't what you're looking for.…

Ahh, so my screenshot was from the Line + Stacked Bar, not the Line + 100% Stacked Bar. It looks like that feature hasn't made it into the product yet. Unless someone from the Domo side wants to chime in, I'd say go ahead and log a support ticket to make sure they're aware. Hopefully it might be something coming up soon. 

There is an option to show only labels for your lines. Under the Data Label Settings, there's a Show Datalabels On option. It sounds like the 'Lines Only' might be what you're looking for. Let me know if that's it or if you need something else. Sincerely, ValiantSpur **Please mark "Accept as Solution" if this post solves…

Cool, glad you got the fill gauge working. As for your Sumo card, I know currently this doesn't work for us either on mobile. However, my team has a meeting scheduled with the project manager over the Sumo functionality. This will be one of topics we have questions on, so I'll be sure to update here when we find out more.

I haven't been able to find any documentation regarding a feature list with the iOS app. Just curious, what chart type isn't working for you on the app? Sincerely, ValiantSpur **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the post that helped you.

As far as I know there is no way to duplicate your alerts. The Move/Copy function only create new references to the same card, hence why when you change the filter it changes for all references to that card. Copying alerts does sound like a valid feature, perhaps you could suggest that in the ideas section and see if we…

When you're in the analyzer of your card. Create a BeastMode and use the following formula: MONTHNAME(`Date`) Just replace Date with your date field. If you're showing more than one month, you'll also need a BeastMode to sort your months correctly. You can use this one: /* Since using monthnames only for X axis, this…

Here you go: Prior Year: SUM(CASE WHEN `Close Date` <= DATE_SUB(CURDATE(),INTERVAL 1 YEAR) AND `Close Date` >= DATE_FORMAT(DATE_SUB(CURDATE(),INTERVAL 1 YEAR), '%Y-01-01') THEN `Revenue` END) Current Year: SUM(CASE WHEN `Close Date` >= DATE_FORMAT(CURDATE(), '%Y-01-01') THEN `Revenue` END) Variance: (SUM(CASE WHEN `Close…

So you're wanting to compare this year to date vs last year to date, is that correct? Also, was is the name of your date field? And are you going to be counting or summing your value field? If I know the names of those fields, I'll just write it up for you real quick

Forgot to add, the formula for % change is just a combination of the two year beastmodes. Something like this: (Current Year BeastMode / Previous Year BeastMode) - 1 And if you're only showing YTD, then just set the Date Range to Year to Date. Hope this helps

Here's a link where I explained how to do this for someone else (except instead of Cities, we used MonthNames as the X axis). You should be able to skip that part but the year over year beastmodes should still apply. https://dojo.domo.com/t5/Card-Building/Re-Period-over-Period-using-stacked-bars/m-p/30479#M3655 Let me know…

I'm it's probably possible with the Magic ETL, however I'm more accustomed to the SQL transform. If you did this SQL transform, you could limit your data to only last month. SELECT * FROM table WHERE `datefield` >= DATE_SUB(DATE_FORMAT(`datefield`, '%Y-%m-01'), INTERVAL 1 MONTH) AND `datefield` <=…

I'm not 100% sure if this is what you're looking for, but here goes. CASE WHEN `Owner` = 'Jane Doe' OR `Owner` = 'John Doe' THEN CASE WHEN SUM(`Settled`) = 0 THEN 0 ELSE (SUM(`Completed`) / SUM(`Settled`)) END END This would prevent the divide by 0 error and would only run on rows that match your Owner column. Is that what…

To my knowledge this is not currently possible within the report scheduler. However this does sound like a promising idea. Perhaps you can post this as a new idea for the product here: https://dojo.domo.com/t5/Ideas-Exchange/idb-p/Ideas

Great job detailing how you were able to break your ETL process into managable pieces to reach your end goal. And kudos for including a video walkthrough for others. That's something I may take up myself if others users find it helpful.