DavidChurchman Coach

For the mod operation, you can't use %, you'll need the MOD() function. For example, for your hours: FLOOR( (MOD(record_age , 86400000) / 3600000)

The formula should work. I tested it on a similar dataset and was able to get both 'yes' and 'no' values in the control for a by-month bar chart. Two things to try: Maybe try adding that minimum report date as a tooltip to the bar chart? Double check you don't have a card-level filter applied

Yeah, that would be dope. You should suggest this to the idea exchange. I think the greyed out lines in the background would be helpful context. A less elegant way to get that context would be with the shaded upper/lower bounds using the XY line graph. You could plot the minimum and maximum values as the upper and lower…

Your cards seem to agree on an average punch score of 2.84-2.85. Eyeballing your table card, this appears to be correct, because most of your tickets are in the 2-3 range, with less than 500/9K over 4. That narrows the problem to the line graph. I think what Ashleigh was suggesting that If you replace Superintendent with…

You should suggest this in the idea exchange. To me, it sounds like what you're describing is one level of abstraction beyond what GrantSmith is talking about. Being able to reference a BeastMode in another function would be great, but being able to write a custom function that you can then input different columns (or…

100% agree the Domo style is very sparse. Even for dashboards that you're not planning to export to PPT or PDF, it's very difficult to create a page that doesn't require scrolling, where most dashboard guidelines recommend creating something that can fit on a single screen.

You're right. I played around and got CORR(`X`, Y) FIXED(BY Date) (with and average aggregation) to work, with some big caveats: If the standard deviation of either X or Y for a given date is 0, then you'll get a null value. So if you have flat values or vertical values on a given date, or only one value at a given date,…

I was definitely someone that saw the pop-up and then wanted to refer back to it, but couldn't find it. Thank you for posting it here. What's the graph view for Magic ETL? Or is there more information about it somewhere?

Maybe this is outdated, but I linked a discussion of how CORR() doesn't work in BeastMode, but gives the manual formula (credit to @Dean_Wangerin): I was able to test and confirm this BeastMode can roll up correctly by date and by week: (count(X) * sum(X * Y) - sum(X) * sum(Y)) / (sqrt(count(X) * sum(X * X) - sum(X) *…

Unfortunately, you can't hide a column in a pivot table. You could reformat your data before putting it in the table to use the hidden column feature (in a not-pivot table), or you could go even more manual and apply your color rules using HTML:…

Here's the article with all the different codes for date formats:https://domo-support.domo.com/s/article/360043429953?language=en_US DATE_FORMAT(`MyDateColumn`,'%m/%d/%Y %h:%i %p') lowercase %h for 1-12 and uppercase %H for 0-23

What's tricky about this is you have three completely different scales you're comparing, and it's difficult to visualize more then two different scales on the same 2-dimensional plane. I might suggest a faceted bar graph instead, which gives a more honest representation of three different scales than laying them on top of…

You could unlock the page and certify all the cards on the page. If someone inadvertently edits a card (instead of save-as), it loses the certification. It also warns the user of this when they try to save the card, which would help prevent inadvertent changes, if not absolutely block them. You could also save a duplicate…

This isn't quite what you're asking for, but on a slicer or checkbox filter, you could set the options to always show the search bar and header. That allows you to type a search term, which dynamically adjusts your filter to just those that contain that search term, and the header allows you to "select all".

I would start by standardizing the date variable. You could use str_to_date: CASE WHEN left(`Date`,1) = 'F' then str_to_date( concat(`Date`,2023), 'F%c%Y') ELSE str_to_date( Date, '%d-%b-%y') END Here's an article on different date transforms: https://domo-support.domo.com/s/article/360042925494?language=en_US And the…

Yes!

Whoops, I thought that's what I did

Hey, I also hate this about bullet charts in Domo. I would use them all the time if there were more control of the labels. Give my idea exchange an upvote if this is bothering you: https://community-forums.domo.com/main/discussion/61581/bullet-chart-additions-trellis-choose-which-data-labels

Since you're saying line graph, I'm assuming you want it not just fixed by category but also by date. If it's not fixed by date (or whatever your x variable is) it would be a bunch of horizontal lines. That would be something like this for your completion percentage: ( SUM(COMPLETED) FIXED(BY GROUP_1, DATE) ) / (…

Since you're saying line graph, I'm assuming you want it not just fixed by category but also by date. If it's not fixed by date (or whatever your x variable is) it would be a bunch of horizontal lines. That would be something like this for your completion percentage: ( SUM(COMPLETED) FIXED(BY GROUP_1, DATE) ) / (…

Not to disagree with the estimable GrantSmith, but the problem is not that you're missing data at the gaps of your graph, it's that you do have data at those gaps, and it is NULL. A line/bar can plot a continuous line with different missing date values, as long as there aren't NULLs at rows: Your BeastMode currently…

I'm not sure why this doesn't have more votes. This would add so much functionality! Maybe it could be implemented with something like the drill-path. There could a page-level control that let you switch all the cards at once to a different point on the drill path.

Is it possible to have two disconnects in a row for an ID or does it always alternate disconnect/reconnect? If it always alternates, you could rank by id/status, split the dataset into disconnects and reconnects, and then join on id and rank. So first disconnect joins with first reconnect. If the pattern breaks, that…

You just have to use a concat() to convert it to a string and wrap it in the appropriate HTML strings. To change it to red, this should work: CONCAT( '<a style="color: #f00">', [YOUR FORMULA], '</a>') To conditionally format it, you would just add that to a CASE: CASE WHEN [YOUR FORMULA]>=0 THEN [YOUR FORMULA] ELSE CONCAT(…

I recommend RobB's post here, too: https://community-forums.domo.com/main/discussion/comment/80160#Comment_80160

If you just want the average by group, you probably don't need a fixed function. You could just set the aggregation to average. In a table, for example, make the first column GROUP_1 and the second column your BeastMode. Or if that's not working, could you be more specific about what you mean by "average performer"?

How important is it to keep the special characters in the dataset? If ds_get() can't change its encoding (which it seems like maybe it can't?) you could do some ETL before going to pydomo to strip out all the characters that don't work with UTF-8 encoding. I think you could regex replace this with blanks to remove all…

I'm not experienced with workbench, so don't know how to fix the upload issue, but you could always add the leading zeros back in with LPAD() when you're joining it to the other file.

Clicking on the single value card won't filter the dashboard. If you have your three values together on a card, clicking on them should filter your charts. For example, if they were a single-row table, or a bar chart. Maybe a Treemap?

My BeastMode wasn't shared to the dataset before. I made some progress by sharing the BeastMode to the dataset. Not sure why that would make a difference, but I'm closer now. Thanks for helping, @MichelleH