-
Weekly KPI Snapshot
I am trying to capture ticketing KPIs through the Zoho connector weekly. Since Zoho sends out the most updated data to DOMO every day, is there a way to store the previous weeks' KPIs? Any methods besides appending historical data? Thanks for the help guys :)
-
How do we keep the changes we make to the people's DOMO name?
Hello DOMO - Good Morning! Recently we have new people in our group that we have appended (Trainer) in their names. and we want to update their DOMO names as well. but in DOMO, after sometime, there are names that revert and goes back to just their names without (Trainer) appended. and there are some that don't. We just…
-
Tracking Changes
Hi Team, Is there a native solution to Domo to track changes made to Dashboards, Card, Datasets, etc.? I know that Dataflows have the "Version" commentary, so you can see who made what changes at what time. Is there a similar functionality for Dashboards and Cards? I want to monitor who is making changes to cards and…
-
html table conditional formatting
Hi, I have a table that I would like to format so that anything over 0 is red and less is green. I have created the beast mode below but I am not sure how to amend it so that the result is a percentage that also creates a total in the total row rather than a count CASE WHEN (sum(Visits last week) -sum(Visits 2 weeks ago))/…
-
Form using Webform as Export
Hi all, I am working on trying to create a form in App Studio. However, I am wanting to change the output of the Form from API to the Webform so that I have the ability to edit the dataset itself. Is this even possible?
-
Increase Bubble Chart Size
I'm using bubble chart now, to show Sales by Region. Some value of sales are in Billion unit while other also in Million. It really doesn't make sense when user choose Year A it show perfect bubble, then Year B size very small. How to adjust the size? Already consider to rescale the data but then it'll affect the data…
-
Remove tooltip in Sunburst
Hi all, when we use other chart i able to hide/remove tooltip. But how do i achieve this in Sunburst chart? I can't show this in my chart due to a requirement. Why i don't see option for tooltip in SunBurst? attached below are my sunburst chart. Last category was coloured as white, i dont want the tooltip like in this…
-
App Studio - Targeted Page Sharing
Hello, I currently have an AppStudio that has two pages, one page serves as support to the main one. The support page is supposed to be used by a select group of people responsible for feeding and driving the main one. The main one is to be used by all users with access to the app. It would be great if I could share the…
-
Microsoft Add-Ins Filter Selection
Pain point: When using Microsoft Add-ins, it takes multiple steps to change a filter selection Current Process: (In Document filters) Uncheck the current selection Mark the new selection Click Save Filters Click Update Existing Filter View Select the Filter Name Click Save Refresh the document The ask: Can we streamline…
-
How to delete filters on App Studio
Hey Community, We're updating our apps to work with the new global filters where it makes sense to do so, but I can't seem to delete filters that have been created. Is there any way to update / delete these filters?
-
Form builder and Form Viewer questions
I have created a few forms using the form builder and viewer: Currently, the form builder settings include an option to make questions optional. However, the form viewer does not allow me to submit the form without filling in the optional questions. I am unable to adjust the size of the 'labels' to our required size as it…
-
Why are card edit paths within a dashboard different
Typically when I edit a card within a dashboard, I've first used the wrench to select "edit dashboard". Then, when I hover over a card, it displays "edit content" and I use that utility to edit the card. However, on one of the dashboards that I inherited, the card only displays "remove" when I hover over in the same…
-
Different Date Formats When Exporting Dataset to CSV
When exporting data from a dataset to a CSV file using the menu, my date format is YYYY-MM-DD hh:mm:ss, while my colleague’s date format is DD-MMM-YY hh:mm:ss. He says he hasn’t changed anything in the CSV. Is it possible for the date format to differ when exporting a dataset to a CSV file depending on the user? If so, how…
-
Need role and warehouse details used in accounts in domostats
Hi can we have role and warehouse details used where creating account in domostats.
-
Why is the same record appearing multiple times with the wrong value
Hi gang! Happy Friday! I have two attributes with values from 1 to 9, then the SUM of the PlannedCost for each record determines a third value from 1 to 4. I then SUM these three numbers to get a "Project Score" Do you see anything wrong with this code to accomplish what I described above? ROUND(IFNULL(`Business Value…
-
Pop Out Text Boxes
We sometimes need to have more text than is probably desirable, so I need to get the text limits expanded. What would be a nice feature would be if we could have a text box that the user could click on and then the text box pops out and reveals more text. Just a thought.
-
Power Point Add In Visualization Issue
When attempting to load cards to Power Point with the Add-In I'm having an issue where the Card Visualization is not loading for some cards and dashboards. It will spin as if it is trying to load but never show the visual. If I switch this to the data table view, the data table will work show without an issue. The…
-
PDP For Dateset Columns
Hey Domo, PDP rules can be applied to a dataset to limit who can see what rows based on user attributes. Can the same restrictions be applied to columns of a dataset? I would like to avoid creating duplicated versions of the dataset with different columns for all the different roles that need varying level of access.…
-
Failed to convert value '(137.790)' from type string to type floating point
Any idea how to fix this error? It seems that my columns are a floating point, so not sure what the fix needs to be.
-
Links - tables only, or any other Card Types
I've started adding a hyperlink back to the records in my source system in table Cards with this: concat('<a href="https://abcdefghijklm.com/project/', `ProjectID`,'/Overview " target="_blank">',ProjectName,'</a>') Are there any other card types that it works in, and if so, is there a list somewhere of which? Thanks!
-
How can I make a historical/week over week chart without a provided date field?
Hi all, I want to make a new but related chart that shows the trend of the SUM of total value week over week. The problem is that I do not have an available Date field in my dataset/ETL except for Item Creation Date which does not seem useful. Also, this total value field is a calculated Beast Mode: (safety stock qty*item…
-
Company Turnover %
I am trying to calculate the company turn over %. We are pulling data from Salesforce into Domo. We have a custom object that lists all employees. These employee have an active/inactive status and a termination date. I am trying to figure out a way to calculate the total ACTIVE by INACTIVE YTD based on that term date.…
-
Is it possible to change the default chart type in Analyzer?
I almost never use the default bar chart in any case. So it's fairly annoying to open Analyzer, have to change the chart type and remove the randomly selected default columns. Especially if there is a large amount of data to be rendered. If it's not a option currently I think some settings should be added to allow for…
-
Change Default Chart Type and other default settings in Analyzer
I suggest an option be added to change the default chart type and column values for Analyzer. I almost never use the default bar chart in any case. So it's fairly annoying to open Analyzer, have to change the chart type and remove the randomly selected default columns. Especially if there is a large amount of data to be…
-
Beast Mode
How do i do a beast mode formula to get the response value of a record that was completed most recently? If this is my data i want to just take the bottom row. My groupings cant be changed in magic etl just need to take response value with highest or most recent time Name Location Time Response value Ben A 2:07PM 5 John A…
-
How to copy the cumulative number from previous day or 2day before or 3day before if no data.
I'd like to calculate the cumulative number from daily count and copy the cumulative number from previous day or 2day before or 3day before if no data. If there are no function on Magic ETL, it is OK to create SQL.
-
App Studio - Phone version won't turn to landscape view
I have created a handful of apps in App Studio that we are contemplating rolling out to our field teams (who primarily use DOMO on their cell phones). As I have been testing the apps I have been checking how they look on my cell phone (Google Pixel, Android phone for reference), and my phone will not show any content from…
-
Can I use the result of an aggregate beast mode as a filter for a dashboard/app page?
I have a beast mode that is comparing actual performance to a target (by categories) by taking the sum of actuals - sum of targets over an arbitrary date range, defined by user input into variables on the dashboard page. This works great as a quick filter control for an individual card, but when I make a filter card using…
-
Do new values get swept into an "all" card filter?
I can't find that this has been answered before. If I add a filter to a card and select "all," what happens if a new value is added to that field? For example, say my field is "color" and I initally only have red, orange, and yellow. I set the filter to select "all." Later on a row that has color = blue is added to my data…
-
Looking for steps to creating a historical dataset and setting up partitioning
About a year ago I set up partitioning. Since that time the platform we were importing data has sunsetted. I am now building a new dataset for Adobe Analytics. Adobe doesn't seem to like long timeframes for imports so I've imported all of the data dating back to the beginning of the year by importing month by month and…