GrantSmith Coach

You can use some window functions in a beast mode to do this. Specifically the LAG function. Here's a post on how to do this:

The only way to load just the page and not all of the navigation top and sidebars is to use Embed. If you don't want users to log in when doing the embed, you can use a Public embed, but that would give anyone with the URL access to the page.

To avoid the issue of comparing a Monday this year to a Sunday last year, for example, instead of subtracting a year from your date, you can subtract 364 days. I've done a write-up about restructuring your data for period over period type analysis that outlines what @ColemenWilson is talking about. You can read more about…

If you use the most recent value of the BOOKMARKETVALUEPERIODEND for your summary number you can then configure a card alert to detect a change for more or less than 5%.

You can use a beast mode and the lag window function to calculate the percentage difference: (`Login Value` - lag(`Login Value`,1) over(PARTITION BY `Member` ORDER BY `Login Date`) ) / lag(`Login Value`,1) over(PARTITION BY `Member` ORDER BY `Login Date`)

You can't embed just the dashboard that way as it'd load the entire page along with the navigation bar. If you want to embed just the page you can use a Private or Public embed option with Domo everywhere.

Currently this isn't possible, I'd recommend adding this to the idea exchange.

No, most cards don't support hyperlinks. Only table and HTML table cards support it.

Is the email the only field you're joining on? Have you used the formula tile to calculate the LENGTH of each of your emails to make sure they're the same length?

Is # Devices a beast mode? If it's a column you can select the column in the table and under aggregation select SUM. If it's a beast mode you can wrap it in a SUM value depending on how your beast mode is written.

You can group by your partition / bucket that you're wanting to sum across. If you want to do it over the entire dataset, use a formula tile to create a new field called "Join Column" with a value of 1 then group based on that new field. After the group by you can use a join tile to join your aggregated data back to each…

You can use the IN operand and give it a list of values you want to include in your filter. There's an example of this on the Domo developer website:

You can utilize Magic ETL and the Dynamic Unpivot tile to take your columns and convert it to rows. Here's more information:

You're sorting by the SUM first and then sorting by the year. Move the Year to be the first thing you sort on.

You cannot but I’d recommend adding a new idea to the idea exchange As a workaround I’d recommend writing your query in an actual database IDE and then paste it into workbench

I'd recommend logging a ticket with Domo Support as they were having API issues last night and this may be related

What I recommend is creating your own date dimension dataset with your defined periods (FY and NextFY). This will allow you to have a single date you can then use in your chart and conditionally use a beast mode to display either FY or Next FY. I've done a writeup in the past on this for period over period analysis you can…

This appears to be a system-wide issue. I'd recommend logging a ticket with Domo Support. I'm having the same issue as well.

There isn't a way to spread out the data labels currently as they're tied to the end of the lollipop. You can submit an idea to the Idea Exchange to improve label positioning and spacing. You can make the chart longer or display less data so it has more space to display the labels and lollipops.

What issue are you experiencing? How is it not working? Have you tried splitting out your conditions into separate beast modes and using a table card to see the values for each row of data?

You can use a Formula Tile and call your new field 'Completed' and use a CASE statement as your formula: CASE WHEN `Screening Date` IS NULL THEN 'No' ELSE 'Yes' END

You can use a beast mode to calculate the average AVERAGE(`Loan Amount Field`) Then you can use it as a summary number or put it into a tooltip field and reference the tooltip in either your data label stubs or hover text settings

@ArborRose The last column is showing 1 / count because it's the summary row on a table, it's not data within the dataset. I agree with @ST_-Superman-_ a Fixed function filter should work to have you only see sites with >= 3 tickets.

CASE WHEN DAYOFWEEK(CURRENT_DATE()) IN (1,7) THEN 'Weekend' ELSE 'Weekday' END

Are you attempting to utilize a single field in your recursive dataflow join for your key field? You should be able to select multiple key columns which uniquely identify each record. Just make sure you're joining on all of your key columns in the join

You're correct that it's doing it on a per-row basis. If you want the minimum across your entire dataset, you can use a window function: MIN(MIN(`Report_Date`)) OVER ()

Hi @alyssamanse ! Through the UI there isn't a way to bulk add a transform to each of the jobs. The command-line wb.exe also doesn't allow for updating jobs. It's a manual process currently.

Domo does have Beast Mode reference in the pipeline, where you can reference one beast mode from another beast mode. I don't know when it'll be released. However, they did tease it last Domopalooza, so maybe soon. You could then define your "function" as a beast mode and then reference it within your other beast modes on…

How are you setting the value of inputData? Are you querying your dataset? Is your column data an array or is it set to nothing?

You could do a replace method update on your S3 dataset and then feed it into a MagicETL dataflow, which outputs to another dataset, but you can set the output method to partition and define your partition key. This would get around the merge issue you're running into. As for the merge issue itself how many merge keys are…