DavidChurchman Coach

So right now you have 4 groups in your series, let's say they're called: Line A Bar A Bar B Bar C Could create a single BeastMode that appends something like "projected" to the end of each of those. CASE WHEN LAST_DAY(date) >= LAST_DAY(CURRENT_DATE()) THEN CONCAT(seriesname, " projected") else seriesname END That should…

A BeastMode can "validate" but still be invalid for some reason the "validator" can't catch. That tends to be the reason I get that error.

Will we be able to embed an app studio app using Domo Everywhere the way we can share dashboards, or do apps only exist within Domo?

This isn't quite what you're asking for, but from a BeastMode, I think I'd do a date diff with the maximum completed date for a store and today's date. Then you could create viz for stores with the longest amount of time since their last audit, and filter for stores that have not had audit in at least __ days. To do what…

I reached out to Domo support on this over a year ago, and they said that card descriptions were not supported in pdf/ppt exports. I submitted this product idea, if you want to up-vote it and/or comment on it. https://community-forums.domo.com/main/discussion/56185/descriptions-in-ppt-and-pdf-outputs

I follow. Currently, your columns are something like: Order Number Schedule Date 1 Completed Date 1 Status 1 Schedule Date 2 Completed Date 2 Status 2 …. Schedule Date 10 Completed Date 10 Status 10 You want to unpivot so your columns are: Order Number Stage Number Schedule Date Completed Date Status If un-pivot is giving…

https://community-forums.domo.com/main/discussion/comment/90095#Comment_90095 Yes, I would create a column with this case statement in a formula tile: CASE WHEN `Product`='c' then `Column with values you want to add` else 0 END Then do a group-by tile that sums that column by ID. Looking at @ArborRose's solution, it looks…

Yes, you could use a Group-by tile, select ID as your group. If your data is structured like this, where ID 1 is all 1s for the Marker column, then you could use "Average" as your aggregating function. On the other hand, the way I'd approach this is I would create the marker column with a simple CASE WHEN Product = 'c'…

It's definitely an issue that gets a question in the community forum every couple weeks. +1 for this request for sure. Here's the first couple I found with a search: https://community-forums.domo.com/main/discussion/64257/filter-null-values-within-analyzer…

Yes, if you have 0 available days in the denominator, you will get NA values for that, which is why it would not show that category on the graph. You're adding percents by category, so even if your overall utilization rate was 86%, if your utilization of green was 97% and your utilization of orange was 93%, then the…

I'm noticing your formula should be !='' or >=1 to get the non-empty results. It's also possible in addition to an empty string, you could have a string comprised of white spaces, which would have a length greater than 0 and not be equal to '' '' vs. ' ' To account for that, I think wrapping your code in TRIM() should…

The Flex Table works a bit like a pivot table, and has options for bars by time period as the chart. I think that would be closer to what you're trying to build with no HTML required: https://domo-support.domo.com/s/article/360043429073?language=en_US

I would probably still create a column that is either the link to the image or a link to an image that represents the file type, and then use that as the image source in the HTML Beastmode. (To me, it's harder to get HTML code right, so I want to keep that part of the code as simple as possible). But if you want to do it…

You're using `stepAnswerUploadUrl` to point towards the image icon and that's working? Why don't you add the url for your PDF icon to that same column so you don't need a CASE statement? Like all IMAGES, could have this url as their <img src>: And all PDFs could have this url as their <img src>:

I can reproduce the error. Jones01 is not using "limit rows", they are using "Max items" in the general settings. I would agree this appears to be a bug in how the tooltip is aggregated for "other" bars. @Jones01 Until they resolve this bug, you could do something similar (but more manual) by creating a rank column in…

I think I found a solution (at least for rstatix), but hopefully this helps with others as well: A dependency of a lot of R packages is the 'nloptr' package (including rstatix), which in turn requires 'cmake'. I believe cmake should be available on the operating system already, but for some reason the Jupyter environment…

Unfortunately, I cannot update the version of R, since that's managed by Domo. I'm working through dependencies, but it's turtles all the way down. They get the same error. I'll play with 'try installing from source', but I'm curious if anyone has any actual experience with Jupyter and R? Most of the documentation and…

With a radial gauge, the implied target is the end of the range (the metaphor of a filed tank of gas). In your picture, that would be 100K. The "Filled" gauge has an option to add a target line that isn't the end of the range: https://domo-support.domo.com/s/article/360042924554?language=en_US Or the "Comparative Fill…

I think you want to fill down the Profit Center column, and once you've created a filled down Profit Center column, you could filter out the blank Service rows. Here's a good explanation from @MichelleH on filling down using Group-By and Coalesce in MagicETL:…

Good troubleshooting. Quick tip: since you're using IN, you could simplify it down to a list instead of a bunch of ORs: WHEN `model` IN ('%F 250%', '%F-250%', '%F250%', '%F-350%', '%F350%') THEN 110 When `Actual bid 2` > 2500 THEN 120 ELSE 110

@trafalger 's solution is really elegant. I was scratching my head trying to incorporate a variable. Probably want a COUNT(DISTINCT product), though, assuming you have more than one customer row per product. Also, note, this will only work with selecting exactly one product. If you want to be able to select more than one,…

You should be able to add your data and series variables as Sorts in analyzer. If you don't specify a sort, it will go in the order of the dataset. If + Sides comes first in the dataset, it will be the first part of the bar or vice versa.

I'm sorry, I misunderstood the question. You want to be able to filter for where the value is NULL in the pivot table. You can't filter for rows in your dataset that don't exist (which is why it's null in your pivot table). I think you want to adjust the data so that there is a row of data for every person for every date…

You could create a beast mode that counts by week (or whatever is defining your columns) and filter by that. Something like: SUM(COUNT(People) fixed(by Week)) Fixed function article:https://domo-support.domo.com/s/article/4408174643607?language=en_US

What would be functionally equivalent is to retroactively calculate what the projections would have been for your entire data set, so you can see historically how your actuals compare to your forecasts. If you're using linear regression, I played with an approach where I tool @marcel_luthi 's data set-up from this thread…

You need to give your "registered" vs. "not registered" column a way to aggregate, otherwise it doesn't know how to collapse the different values. I think this should work (it's basically just wrapping your beastmode in a SUM and another CASE statement) case when sum(case when Year like '%2024%' then 1 else 0 end) > 0 then…

It is not possible to add an x-axis to the Spark Bar (maybe suggest this in the idea exchange?). Alternative: You could add it as part of your data label. You could also use the Flex Table, which allows has the same change indicators, but gives more options for labeling the graph. You could achieve a similar summary number…

Search for the 'Dynamic Columns Brick' in the appstore. It's relatively easy to set-up and does what you're describing in your original post. Otherwise, I would use @michiko's suggestion. Or, if you want a filter that's 'Budget' vs. 'Actual', then after pivoting your data, you could add a column with a case statement like…

I think you want something like: CONCAT( DATEDIFF(QB-Closed-Date, QB-Created-Date), ' ', //days HOUR(TIMEDIFF( QB-Closed-Date, QB-Created-Date)), ':', //hours MINUTE(TIMEDIFF( QB-Closed-Date, QB-Created-Date)) //minutes ) (Adapted from @JaySethi in this discussion)…

It looks like you are limiting the data to 150 rows. When you move the Year | Month to your first sort, then it moves the most recent month to the top of the data, and you only get the most recent month. You should remove that limit to see all months. If you're limiting to 150 rows in order to get a more limited number of…