-
Merged: Dynamic Date Variable
This discussion has been merged.
-
ETL question
I want to implement a function that every time the dataset is updated, it will show me which row is new. What's the best solution, I am thinking about recursive dataflow but not sure how to create one.
-
Beast mode question
Hi all, I have a beast mode calculation created which I'm trying to find out the monthly average of open tickets between 5 boards for the past 15 months and this is what I have- SUM(COUNT(TicketNbr)) OVER (PARTITION BY Board_Name ORDER BY last_update)/ DAYOFMONTH( last_update ) But I think the calculations are off. Is…
-
Unable to Schedule Jobs
Hi everyone, I can manually run a job which works, however when I schedule a job, it says that it executes however the job does not run and I don't see it in the UI. When I look at the viewer, I see the following error: 'Could not fix consecutive blocks of CRON schedule' Does anyone know how to resolve?
-
form brick not available on app studio.
Hi, I have custom coded a form brick and saved it. the form brick had a default form. I have made the changes in HTML and customized it. However when trying to upload it to App studio it displays the default form instead of the customized form.
-
Dashboard Page Filter: Automatically set a default value based on the available values in the filter
When a PDP policy is implemented to a dashboard, I noticed that we cannot set the page filters (i.e. single select filter) to a default value for each PDP policy or have the page filter automatically set to a default value. This is because when there are mandatory dashboard filters in order for the dashboard to work…
-
Grouping Values into Ranges
Hello, I am trying to group values into ranges in DOMO, but can't seem to get my beast mode to work. Am I doing something wrong? I am trying 2 different methods: 1. case WHEN `Sale Liability` >= 50000000 AND <= 100000000 then '$50M-$100M' WHEN `Sale Liability` >= 100000000 AND <= 250000000 then '$100M-$250M' when `Sale…
-
Is it possible to make the multi-value guage dynamic?
I have the multi-value PoP gauge on my dashboard showing a comparison to the previous year. The default date period is set to previous month. But, altering the global date on the dashboard removes the previous year comparison. Is there a way to keep the previous year comparison while also allowing the user to change the…
-
LinkedIn Ads Connector - Upcoming update to the 'Ads Creative (versioned)' report
On Monday, July 29th 2024, Domo will update the version the API endpoint that is used to generate the 'Ads Creative (versioned)' report in the LinkedIn Ads connector. Datasets that are powered by this report at the time of the update will be affected as follows: (1) Columns that are populated by the older version of the…
-
Assigning red Font color in a beastmode - Single Value Card
I have a single value card and I'm using the following code to format the dollar value as I concatenate several values into one text value for the card to display. Do you know if there's a way to have the font color display red if the value is negative? Here's a snippet of the code: CONCAT( '$', CASE WHEN…
-
Domo alert question
I have a column called status which contains three values, null, inactive and active. What's the best way to set up an alarm that notify me when any row status change from active to inactive ?
-
DomoStats Alerts Subscribers
The DomoStats Alerts only shows rows and the owner of the alerts. There is not a DomoStats that shows all of the subscribers of the alerts. This would be very helpful to tie in with user use assessments and impact for this category. I know there is a separate DomoStats for Scheduled Reports Recipients, which is a similar…
-
Is it possible to public embed an App from App Studio with a form?
I currently use Squarespace forms to process appointment requests, which are then sent to Google Sheets and subsequently to DOMO 🤯. It seems more efficient to use an integrated DOMO form within an app for various reasons. However, when I embed the app, everything else appears except the form. Is this feature not currently…
-
New On-Demand App Studio Course Available
Domo University has just launched a new on-demand training course for Domo App Studio covering the following aspects of this powerful feature: App Studio Strategy and Value Apps Home Creating a New App Importing Dashboards Adjusting Page settings Tabs Page Drilling Persistent Filters (beta) Buttons and Forms App Navigation…
-
Collapsing Tabs in App View
We've got an App View that contains large datasets that are rendered in tables, with assets below it that we would like to be able to compare against the table, but then collapse the table when no longer needed. Ideally, it would allow us to dynamically shift elements on an app page as needed, in order to view the data in…
-
Budget to Actual - Multiple Dimensions & Different Datasets
I have a budget dataset with the following columns: _Account _Subsidiaries _Department _Doctor _Location (Not in Use) _Headcount Resources _Placeholder 4 _Year _Period _Scenario _Currency _Measure _value I have an actuals dataset with the following columns: Appointment Date Status Appointment Type Patient Account Number…
-
Why is my collection in domo brick not syncing with the dataset after enabling the sync?
I created a dataset and attached to the app, Enabled the sync from collection to dataset. Ensured that the data types in dataset matches to that of the schema. However, when I add the inputs, the data in the collections ( App DB) is not syncing with the datasets.
-
Buzz - Bulk Deleting Previous Content for Whole Organization
As our admin, I need to bulk delete all prior Buzz content for our entire organization. How is this accomplished? Alternatively, how can I turn off Buzz for my organization?
-
I have AWS ELB log files stored in S3 that I want to load into Domo
I have been unable to get the S3 Advanced connector to process the file. The connector has successfully connected to the correct bucket in S3. The logs are space-delimited text files that use double quotes around multi-word elements. The files do not contain headers. Since there are no headers, how do I name the columns in…
-
How to change the owner of a App in Domo
I am trying to change the owner of the app that was used in multiple cards, I was able to change the owner of the cards and dashboards but not the app itself. The reason I want to change the app is to learn what kind of app is it and how it was designed and configured so that I can make further changes to it and to…
-
Highlight pie chart slice by filtered selection
Hi All, I have a Supplier Performance dashboard where users will filter by first selecting one of several Suppliers. Most cards on the page would then filter to show only data for the selected supplier. I want to have a pie chart that doesn't get filtered as such, rather it would 'highlight' the selected Supplier as below.…
-
Identify a duplicate
Is there a way to create a column that can help identify a duplicate from another column? Below is a list of loan ids that we have and some of them have coborrowers but some dont. I dont need to remove the duplicates but I would like to create a new column that can identify quickly which one is a coborrower. Is there a…
-
Recurring Pagination - JSON No Code Connector
Hi, I'm retrieving data from Shopify's GraphQL using the JSON No Code Connector. I have a token in my request body and am using in in the native Pagination feature (screenshot below). However, it only iterates once (uses the token once then stops, instead of using the next token and so on until all data is parsed). How do…
-
ETL and Beastmode
Hello, hope someone can help me. ========= I have a card level beast mode and filter: Company Name NOT IN "AAA" Destination - AAA Filter NOT IN "Exclude" =========Here's the beast mode for Destination - AAA Filter:CASE WHEN Destination like '%AAA%' THEN 'include' WHEN Destination like '%Tipp City%' THEN 'include' WHEN…
-
Enable Drilling on Table View
If a card has a drill path the drilling capability goes away when it's in table view, if drilling can be enabled for both the default view and the table view of the card that would be extremely useful.
-
Rating Card
Anyone have any idea or work around to show ratings besides just table or bar chart? I have a survey where people rated items 1-5 stars. I would like to show that in a format like this based on responses.
-
Flex table
Hello! I need to build a flex table in which some variables should be green when the change indicator is increasing and some other should be red when increasing. Could you please tell me how that is possible? Because now you can reverse the direction of the color for the whole table, not each individual variable. Thank you…
-
Domo User Groups & Dashboard/Dataset Sharing
If we share a dashboard with, say, the Default group, all current and future people added to that group see the dashboard (as expected) However, the underlying dataset that powers the chart(s) on the dashboard only gets shared (individually) with the users who were part of the group when the dashboard was initially shared.…
-
STR to Digit
Hi, Can someone explain this to me? I have a column that have some values that contain '$' making it a string. I am running it through an etl and using str to digit while also trying to keep it a floating point value. My formula is LONG(STR_DIGITS(TRL_MISC3)) However its taking some values like this and outputting them…
-
Trying to connect my Marketo Smart list to DOMO
Hi Community I am trying to connect my Marketo smart list in domo to create a DOMO chart. But i am getting a error as " Failed to execute import successfully. " Can someone help me in fixing this issue . Will add the error screenshot and the setting page screenshot for more clarity.