-
Filtered date selection
Hi there Im trying to create two filter date selection to see sale difference between two period selection. Is there any way to do this?
-
prioritize recent data for input datasets in dataflows for preview
We all run into the situation where we have two tables with hundreds of million of rows and we drop them in the dataflow and know that our join transforms will never match up. Could we get the most recent 10k rows from the input datasets rather than something seemingly random? That would really boost our ability to…
-
Need help with Month Function in Beast Mode
I'm trying to set up a beast mode formula to calculate YTD Asset Yield. It doesn't seem to work because of the Month function. I also try to create a formula for Month(`Monthend Date`) within the ETL, and that did not work too. Do you know if there is a reason why this does not work and do you have any suggestion to make…
-
Reinstate embed options for app studio embeds
When embedding apps from app studio the display options have been removed as most aren't applicable. Some still are though and do work so I would like these added back in please. The dialog below shows how this would look. Interactions: this allows us to stop users interacting with the individual cards within an app Card…
-
Multi Line Graph with Different Time Zones
Hello, I have a dataset here where there are 4 time zones, EST, CST, MST, PST and the fields are this CST Created Date, MST Created Date, PST Created Date, Created Date Last one is EST by default. Example format: 2019-03-11 10:22:17 So, I have extracted the hour using HOUR (`MST Created Date`) and for others as well. But I…
-
Transpose a table
Hi, I need the day across the top of this table and the visits/ orders etc along the rows, how can I transpose this table ? any help appreciated!
-
How to create YTD, LYTD, LYLW, etc columns from a FISCAL CALENDAR
I have a dataset that has sales per item going by each week (yyyyww) for the last three years, only I can't use things like YEAR(CURDATE()) or YEARWEEK(CURDATE()) because the yearweek we're getting from the dataset is based on a fiscal calendar (Ex: The first full week of august is the first week of the year, so July 29,…
-
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 :)
-
Enable Table Card Row / Position Numbering
I would like to put forward a proposal for Domo team to enable row or position numbering in Table card. This is extremely helpful in group discussion where one can just refer to a particular row number in the table for which is being referenced. The numbering also needs to be dynamic and remain in the ascending order all…
-
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.…