david_cunningham Coach

what exactly do you mean by dynamic? Are you saying that the goal will be dependent on changing aggregate chart values. Or that the goal is dependent on the particular series or date range? If you let me know, I can help walk you through a solution using either beast mode or ETL depending on your particular use-case.

If this is going to be a consistent, recurring use-case. I.e. you’re going to want other cards to replicate the same behavior. I’d recommend using the fiscal calendar option in Domo. When setting it up you’ll be able to specify your week start date. You can then either toggle that setting on/off to use your Monday start…

Thanks @BenSchein! This is perfect because I was on a work call when it popped up and accidentally closed it out. Thanks for sharing!

Something to keep in mind with this approach is that it's an all or nothing switch. Either all your scheduled reports will be .xlsx, or all will be .csv

The easier approach is to use Domo's built in chart type "Running total grouped bar". If you want to use the chart properties option, you'll need to use a line/bar combo chart. Then you can set the series on left scale to 0 and set number of running bars to 2. I don't see much advantage to this approach given your…

So this would require you to use an HTML table, which would mean restructuring your data because transpose isn't an option. But if you're really set on changing the font color instead of the cell color, you can achieve that by using this beast mode. CASE WHEN SUM(value) < 0 THEN CONCAT('<p…

@chetan_cricut if by first column, you mean the first column non-transposed, ie. Average daily projects. You could do something like this. CONCAT('<p style="text-align:left;">',SUM(value),'</p>') Keep in mind that concat removes the ability to use the native domo formatting. So you'll have to do the formatting in your…

The easiest way to achieve this is to set the negative numbers to show in red, and then use card color rules to set > 0 to show in green. The red negative number setting will override the green. However, this approach causes the cell to be filled in, just an FYI.

Hi @DWill978 - as far as I know there isn't a way to drill to a specific path dependent on which column is clicked using Domo's out of the box features. I'm curious to hear if any other community members know of a way to do this though. I'm guessing there might be a way with a brick or a custom-app, but that is a lot more…

@user04612 you could use the Domo provided running total line or bar chart cards. There is also a setting in Bar/Line charts to create running totals. You can find this in General > Number of Running Total Lines. If neither of these options work for you. Please let me know and I can help you create a beast mode.

@kim_barragan0126 If it’s always just the 2 columns, and you will have nulls. You could do (col1+col2)/2

@damen please post the code you are using.

@damen wrap it in CONCAT() and then adjust your year Concat(year(date issued), ‘-‘, year(date_add(date issued, interval 3 year)))

@Zofia here you go! The way this works is that we compare the month and year of the date to the month/year of the current date. We use date_add to add a month. This should work across year changes as well. CASE WHEN MONTH(CURRENT_DATE()) = MONTH(date) and YEAR(CURRENT_DATE()) = YEAR(date) then 'Show' WHEN…

@tmerchant I just tried your beast mode using some sample data, and didn't run into the same error. With that being said, one thing I would recommend is to break your beast mode into parts, and test those parts to figure out where the problem is originating from. For example, take SUM(CASE WHEN Category = 'Revenue' AND…

Thank you @ColemenWilson! I'm thrilled to join you, and the rest of the coaches - y'all are a talented group! 😁 Looking forward to continuing to learn and grow together!

Hey @RobRolek, thanks! 😁

Thanks @JasonAltenburg ! 😁

@TMonty0319 here is how you could do this in a beast mode. Lag will default to the last available date. For example you can see that this dataset skips days, but the beast mode still shows the data from the last available date. (LAG(SUM(day_tank_value),1) over (order by date asc) + LAG(SUM(oil_added_tank),1) over (order by…

Keep in mind this is not a fully fleshed out solution, but does work if you are just looking at general trends. Depends how exact you want/need to be in your weekly average. But one possible solution is to graph by month, and then have a beast mode like this. SUM(value)*12/52 This is likely better than just dividing by 4.…

@AngelaO415 sure, here you go. SUM(SUM(case when requests_state in ('granted','closed') then requests_amount_recommended end)) over (partition by organizations_name)

@AngelaO415 are you summing by both requests_amount_recommended and your new beast mode? The same beast mode will work in a table. I can't tell from your screenshot what's really going on. But in the below example, I'm using a table, and you can see that there is no repeat organization_name, and both fields are summed.…

@AngelaO415 - here you go. You would use this beast mode as the input to your y-axis if you are using a bar chart. case when requests_state in ('granted','closed') then requests_amount_recommended end

+1 to this. Would love the ability to exclude certain users from the result set.

@Chris_Wolman this is great to know! Thanks for sharing 😁

Yes - you can use the Rank and Window tile to create a rank based on your id. Then use the filter tile to return the rank you want. If you want the min id you can just sort ascending on your rank/window function and then filter to where rank=1. If you want the max id, you can sort descending and then filter to where…

@Caua_Soares you could achieve that in a table by creating a beast mode where you concat together your symbol and the amount. This does complicate things a bit though, because you would have to format the amount in your beast mode instead of relying on Domo's built in number formatter.

@jrtomici the answer provided by @ColemenWilson is the correct one, and I kindly ask that you please select his answer as the best response. I just wanted to provide you with a quick breakdown of how to achieve it. Example Data You'll use the dynamic unpivot tile, selecting "Name" to not be pivoted and then assigning…

If you have a lot of different combinations and don't want to do this manually, an option is to do it in ETL with REGEXP_REPLACE. REGEXP_REPLACE(string, '^.(\d).$', '$1')*1

@random_user_098765 here is an example of how I typically do it. You can swap out the font size to get different results. CONCAT('<font size="3">Medium Text ',SUM(Order Item),'</font>') For example Something to keep in mind is that this will only work in the web-app. Summary numbers in the mobile app won't change.