brycec Contributor

CASE statements are exclusive, so once it finds an option that is true, it exits and doesn't evaluate other options. Not sure really how to explain it better, but I do have the solution. This is what variables are for! :) They are wonderful honestly. Create a variable that has your options of YTD and MTD, then create a…

@MrDeanoB Any chance you figured this out? I am looking to achieve the same thing and have had no luck so far.

If it is pulling the same date for every row, it sounds like you aren't grouping on the correct columns. What columns are you grouping on? You'll want to group in a way that identifies the unique row that you want the date aggregated for.

First thing I noticed, you don't want to have DAYOFMONTH in the check for Last Year, because comparing less than or equal to would mean you skip 05-2023 through 12-2023. Second, I would suggest splitting out your calculation into different formulas or even different tiles. So, I would first calculate your max date in a…

This should be achievable. What is your Beast Mode formula right now?

Are you saying your date is stored as a string/text column and not of date data type? If so, you'll need to use the function STR_TO_DATE() to convert the column to a date first, then you can use the other Beast Mode I sent.

You'll want to use the data repair feature. Add this exact string to the end of the URL of the DataSet: ?_f=dataRepair Then, you'll now have a new tab on the DataSet called Data Repair. Navigate to it. Now, you should have all the tools and options to do what you need. It'll let you delete updates, replace updates with a…

You can use Domo's undocumented public API for this. To authenticate to it, create an access token from these instructions: Use that token as the value for the header X-DOMO-Developer-Token when sending your API request. To find the right endpoint, required parameters, etc. just open up the network developer console in…

This is supported by Domo Everywhere. Under the Private Embed section of this page should provide what you're looking for.

Is the problem you're running into that it's aggregated on the card but you don't want it aggregated on the drill? If so, you can create a DataSet using a DataFlow that aggregates the values for the card, then use a different DataSet that's not aggregated for the drill. I'm probably not understanding the problem well. Feel…

I don't think so, but maybe someone else knows better than I do. Domo only allows one aggregation level, and two when using FIXED. You can try to change the options for that column at the top (where you normally format the value), and see if you can change the total option to SUM. But, I'd assume that would cause three…

Sounds like the Domo connector was probably built poorly and doesn't include it. I'd suggest using the JSON No Code OAuth connector and just using AirTable's API to build a request yourself. You can test the API in Domo or in a tool like Postman first to see if the URL field returns correctly.

Are you trying to drill from the table you shared? If so, it should be pretty simple. Just create a drill on that card, build out the view your looking for, then to drill click on the program in the table. Bonus, you can actually stay on the drill level but just x out the filter for program shown in blue, and it will…

You could use a YoY chart to show them like this on the same chart. Or, you can use a Beast Mode to filter to that date only, like: `(CASE WHEN DATE_FORMAT(Date, '%Y-%m) = DATE_FORMAT(DATE_SUB(CURRENT_DATE(), INTERVAL 13 MONTH), '%Y-%m') THEN 'Yes' ELSE 'No' END)

You could divide the number in the Beast Mode such that it is represented in millions or billions, then append in the concat a label like mil. or in billions.

Have you tried using the performance tiles that are provided in Magic? They should work perfectly for this. Here's the documentation for them:

Have you tried saving as and seeing if a new card would save correctly or trying to create the card from scratch? You're right, it should allow you to save the card with the subtotals collapsed or expanded. But sometimes cards get messed up and restarting from scratch fixes it.

Make sure you submit an idea in the ideas exchange, because this discussion board isn't for feature requests. I'm commenting here to remove this from the unanswered questions.

You should be able to achieve this using FIXED functions in the Beast Mode. Here is the documentation for them: You'd want to use the FILTER option of the FIXED function to make sure your monthly NPS isn't affected by the fields you specify.

This might be able to be achieved using a FIXED function in your Beast Mode. Here's the documentation for FIXED functions in Beast Modes: It would probably look something like this: AVG((sum(Sales in Jan 2023) FIXED (BY Shop) - sum(Sales in Jan 2022) FIXED (BY Shop)) / sum(Sales in Jan 2022) FIXED (BY Shop)) I haven't…

I find that Beast Modes often fail if the top-most level of the calculation is not an aggregation, but aggregation functions are used elsewhere in the Beast Mode. What I mean is, in your calculation, you are using SUM several times, but the top-level of the Beast Mode is a CASE statement and a divide operation. This may…

I have confirmed that this functionality is working as expected in my instance. Not to say that in your instance it isn't a bug, but hopefully not. You need to have the option "Show Subtotal Rows" checked under the Subtotals section in the card options for this to work. Do you have that checked already?

I believe the landing page is whichever page comes first in the navigation. Go to pages and navigation settings by clicking the copy icon in the left sidebar (looks like two rectangles on top of each other). Then, hover over the page you want to be the landing page, and using the 8 dots icon that appears left, drag and…

I've created a custom connector before, for Brex and Pleo, and published them to the Domo Appstore. Honestly not bad at all, only moderate JavaScript knowledge required. Domo has developer documentation for building custom connectors: https://developer.domo.com/portal/5d8f965eb3469-overview. To actually build the…

After creating the template, did you run npm install to install all the necessary dependencies contained in the package.json file?

You can disable filtering entirely on a card by card basis on design/story dashboards. Edit the dashboard > edit content on a card > change filter exceptions > uncheck allow filtering. This unfortunately disables any kind of filtering for that card, not just your slicer. There is no way to allow filtering from one filter…

Currently, filtering in webform edit mode is not supported. You can create a new idea in the ideas exchange if one does not already exist.

You could call the API to get all the PDP policies on the DataSet via this URL: https://api.domo.com/v1/datasets/{dataset_id}/policies Then you could loop through those policies and delete them via this URL: https://api.domo.com/v1/datasets/{dataset_id}/policies/{pdp_id} More information here:

This is a duplicate idea:

I've achieved this by calling the Domo API. Request URL: https://<company>.domo.com/api/query/v1/functions/search Authentication: Header called X-DOMO-Developer-Token with a value of an access token from Admin > Access Tokens. You can then view a Beast Modes dependencies in the activeLinks column, which can be aggregated…