ArborRose Coach

I would suggest capturing your data using recursion or some other method…as a snapshot. This would let you compare it with the current data. You can use the contract date to see if the order expired, even if its no longer in your dataset. You can join the current with the historical snapshots to compare and identify which…

You could try to "debug" the issue by simplifying and testing aggregation separately SUM(OrderGrandTotal) FIXED (BY MpowerOrder) And testing the logic without the aggregation: CASE WHEN Coop Event = 'Aug 2024 Moto Coop 2' THEN CASE WHEN OrderGrandTotal >= 963 THEN OrderGrandTotal - 963 ELSE 0 END WHEN Coop Event = 'Aug…

Sounds like you might try creating a Magic ETL with beast mode formulas to distribute the data across the desired time period. To join your aggregated data by ad type with a calendar table based on the date range that matches your aggregated period. If the ad type data is aggregated for a month, distribute the value across…

It appears you may be having trouble because of the nested aggregation (SUM within a SUM). Try this: CASE WHEN Coop Event = 'Aug 2024 Moto Coop 2' THEN SUM(CASE WHEN OrderGrandTotal >= 963 THEN OrderGrandTotal - 963 ELSE 0 END) FIXED (BY MpowerOrder) WHEN Coop Event = 'Aug 2024 Moto Coop 1' THEN SUM(CASE WHEN…

What @MarkSnodgrass said above. His trick with the svg shape naming is brilliant.

I don't believe there is any built-in way to configure log retention. They are stored locally and accumulate over time. But you could create a script (PowerShell or batch file) that checks the date and deletes anything older than your desired retention time. And schedule the script in Task Manager.

Have you tried using Magic ETL with Text tile, Split Column to split on the pipe symbol?

You need someone smarter than me to answer that.

I'm not sure about creating 21 charts using Domo charts on an App. That's what I would try first. And I haven't tried it. But…as an answer to how I might do it more efficiently - you could do it in a blank brick. const widgetData = [ { type: 'Small', color: 'Red', data: [12, 19, 3, 5, 2, 3] }, { type: 'Small', color:…

Are these all bar charts with the same column names (fields), created from a Magic ETL? The only difference being how they will filter?

Have you considered connecting using Jupyter Notebooks and a Python script? I don't believe it would cost any extra credits if it is done in the same script. In Domo, credits are typically tied to the DataFlows, Workflows, or API execution rather than each individual execution of a Python script. Executing a Python script…

The issue appears to be how the datatables library handles rendering. It applies the styles after rendering the data, which appears to be causing it to skip the first column. You can try applying the formatting during the drawCallback. $(myTable).DataTable({ data: reorderedData, lengthMenu: itemsPerPageOptions, columns:…

I don't use the Adobe Analytics Connector, but you could try making more than one API request. Each with a different set of dimensions and then combine the results using Magic ETL. Or possibly do some of the processing in Adobe Analytics and then pull the metrics instead of the raw details.

The Beast Mode calculation appears to be causing a processing error, likely due to the combination of a window function and the dataset size. The calculation for repeat customer revenue may be leading to the error. To avoid the complexity of window functions and reduce processing load, the OVER (PARTITION BY), appears to…

Error: "Domo is ready, but you don't have access to the associated account. Please contact the account owner to have them share the account with you." Cause: Permissions Issue: The user does not have access to the NetSuite account linked to the Domo connector. This could happen if the account owner (the person who…

I'm still doing a bit of work. But my end goal is to create a blank brick that summarizes my API and Jupyter calls as a custom made Gantt chart. Basically because I couldn't figure out how to do it with a Domo chart. I want to visually see which tasks I have scheduled at specific times to ensure hand-offs and to…

The behavior you're encountering happens because Domo cards are designed to handle data and interactivity in the form of filters rather than custom JavaScript events like onclick. Custom HTML or JavaScript is often sanitized or blocked for security reasons. Bricks are your best bet for custom scripts, but if you want to…

I don't think there is any way to disable the '+Add Filter' option in the filter control on App Studio. But there are other ways you can limit the filtering options. Card Filters on specific columns, custom filters, permissions and roles to restrict datasets, etc.

@jlrosenlof - The API has the tag list as an array. In my code above, I'm only pulling based on the tag "Jupyter". But the API does show an array for the datasets that have more than one tag.

I assume last updated is when the code was last update, not the data. I need to know the code ran and data was populated via the API it was calling.

Thanks for the note. When I'm debugging code, I often use a temporary token with a quick expiration. One odd thing I found about the API, it doesn't contain information in the field dataLastUpdated.

No, you cannot directly copy just one tab of an app to another app. You would have to replicate the contents by exporting the cards and reimporting.

Thank you @MarkSnodgrass and @ggenovese. I had been searching different endpoints and couldn't find the correct one. @ggenovese , the endpoint you listed was what I needed for my search. After a bit of exhaustive code changes, the following will display a list of the datasets with tag "Your_Tag_Goes_Here". And all the…

The basic difference is probably the flexibility and customization in the user experience that an app provides. Dashboards are rigid in structure. With an app you can design a custom interface tailored to specific roles, tasks, or workflows. Dashboards aren't always mobile-friendly. Apps can be designed for mobile use.…

I'm not sure if you can do it with one of the existing chart types. But you could do it with a blank brick. In this example, I'm cheating and using a translation of longitude and latitude to plot the zip codes. To do it properly, you would need to append your data with long, lat or find a conversion method to plot them by…

Sounds like the Cloud Amp outputs may not be supported by Dataset Views. There may be a limitation, especially if the dataset originated from Cloud Amp integrations like Data Bricks. You could check if the Cloud Amp output could be exported or transformed into a Domo dataset through a dataflow or by saving it within Domo…

One of the biggest things I suggest to anyone is to try to make sure everything is dynamic and self processing. As the quarter moves, the year turns…I don't want to have to touch anything. Instead of labeling things with static values like 2024 and 2023, it's CY (Current Year) and PY (Previous Year) …and after that P2Y,…

I don't have much time to respond, but it ought to be something like this: Using Magic ETL Group By the data to remove duplicates for each ProjectId and get the unique Yearly Total Run Costs (CHF) for each project. • Add a Group By tile in Magic ETL. • Group by ProjectId. • Use the MAX (or MIN) aggregation on Yearly Total…

What Grant is suggesting you try…. SUM(1) OVER (PARTITION BY ProjectId ORDER BY BatchTimeStamp) This creates a running total (cumulative sum) of rows for each project id, ordered by the batch timestamp. The first row for each project id will have a total of 1, the second 2, etc. The case statement checks to see if the…