-
Sort Table based on What was first selected in Filter
Hi, I am trying to filter a table that I created using a DDX Brick based on what location was first selected. Using a very simple example, The user selects FL, then the user Selects Ga then the User selects LA. The way the table should be sorted should be GA, FL, LA instead of sorting alphabetically. How would I go about…
-
Prepopulate Filter
Hi hopefully this makes sense. I am trying to prepopulate a filter based on the users last input selected. The rows in my dataset have a staring city location and an ending city location to get possible routes. The first method I tried was to join every starting location on every ending location and then from there join…
-
Very Simple Question on how to get data
Hi, I am not familiar with how to retrieve data from a dataset. Ive tried taking premade bricks and trying to learn from that. The dataset I have is 1 row with 3 columns. I assume I would just create variable name and assign the value to the column. However, I have no idea how to get it to display. I am comfortable in HTML…
-
Date_Sub
Hi, I have two dates that are timestamps ex(dec 12, 2023 6:30:00 Am) I am trying to subtract the two dates to figure out how long a certain task took to complete. I am using date_sub and I am receiving this error, how would I fix this? "Calculation Error : Operator '-' cannot be applied to type 'Timestamp'."
-
Route map
Hi, Is there a way to have a route map create a triangle? The idea is to have 3 variables with different locations and to mix and match them and for them to create a triangle, however, I only see where you can put long and lat for 2 locations and not three. Is there a way to have three locations?
-
Drill Down Path
Hi, How can I get the drill path to not be affected by a certain day but instead display the whole month. For example I have a bar chart with dates as the X-axis and I am trying to enable a drill in place drilldown path that allows the user to click on it and go to another chart that has the same layout just a different…
-
Gauge Formating
Hi, I have this gauge that I am trying to add a target value to. The gauge I am using is Radical, however, it doesnt have an option for target value. I have tried to switch it to filled but I cant get it to look the same. Are there any settings or charts I am missing? Thank you in advance,
-
Trying to understand why a line Bar behaves the way it does
Hi, I am trying to understand why a line bar is behaving the way it does. I have a bar chart that is correct the field is summed. However, as soon as I add a line bar it seems to sum each column before it. The aggregation for the bar is the same (sum) and for the line ive tried every aggregation to try and get it to look…
-
Creating a running SUM
Hi, I am trying to figure out what the best way to create a running sum would be. I know there's an option on a table, however, I am trying to create a line bar. Would the best way to go about this in an etl or a beastmode? For example 1-30-24 should be the sum of 47780 + 42874 instead of just the 1-30-24 revenue.
-
Displaying a Blank chart
Hi, Is there a way to have a Chart display blank data until filtered. For example I have two charts one with products x,y,z and then the other being a blank chart. When I click on product X, I want the blank chart to display every customer. When no product is selected I want the chart to be blank. Hopefully that makes…
-
DDX Form Brick Only Updates If I put in two request.
Hi, I am using the DDX form Brick and modified it using Ellibot video on Youtube. It only runs when I fill out the form twice. Is there a reason for that? If I fill it out once it will not collect the data. If I fill it out twice it then runs and collects both sets of data. I am afraid that some responses will be lost…
-
Using URLS on Card Title
Hi, Is it possible to make the card title a hyperlink to another dashboard?
-
2 questions about DOMO everywhere.
Hi, Does the link ever change? I want to just have a Gmail sent every day with the link to the dashboard (that I assume changes due to the Etl Running) so I plan on doing that by scheduling an email with the link. Dependent on # 1, is it possible to have the link name change so for example "Report for 1/25/2024" and…
-
Common Practice Joining
Hi, I am running into an issue where I am trying to join two datasets. Joining on a Unique ID is not an option as whoever set up this dataset decided not to include one. My next thought process was to join on date and name. Here is the issue I am running into. Dataset one has the full name for example Fredrick. Dataset 2…
-
DDX Brick Link opening New google Tab
Hi, I am wondering how can I get my nav bar to open a new google tab when clicked instead of it opening in the DDX Brick. I thought it would be the target="_blank" but when I add that it no longer opens anything. <nav> <ul> <li><a href="https://trimble-tt-16502962.domo.com/page/402244837" target="_blank">Return…
-
How to call a column in JS DDX bricks
Hi, I wrote this script to switch the sentence on a landing page to switch every 5 seconds. It currently does that. However, as soon as I insert the column data it no longer reads the first sentence and doesn't switch sentences. What might I be doing wrong? Still learning JS so I appreciate the help. The script works but…
-
Copy and Paste HTML Bricks
Is it possible to copy and paste HTML Bricks using 'Save As.' I have tried multiple times to copy and paste my Nav bar to different Dashboards but it doesnt seem to work.
-
Changing Dataset Name using Forms
Hi, I know this question is going to seem silly. I have a little bit of python knowledge from my college about a year ago. I am just playing around with the form ddx brick(Havent changed any code in it yet as I am just learning JS) . How do I change the name of the dataset? I've gone through the JS and I've tried changing…
-
DDX Bricks
I have a few questions about permissions for DDX bricks. Do I need these enabled to be able to edit bricks without getting an error message? Right now I am able to download them but as soon as I hit the wrench I get this message I brought up a week ago. Its on every single brick I download. The permissions I currently have…
-
Pfilters
Hi, I just watched Marks video about how to use pfilters so I thought id give it a shot with this beastmode. CONCAT('<a href="https://trimble-tt-16502962.domo.com/page/2050403531?pfilters=[', '{%22column%22:%22Lane%22,%22operand%22:%22IN%22,%22values%22:[%22', `Lane`, '%22]}', ']" target="_blank">', Lane,'</a>') The output…
-
Interactive Card
Hi, Is there a card like that would allow users to type an explanation on something and the card then updates. The users would be reveal participates. To the best of my knowledge I dont think this is possible. If not what are some workarounds. I was thinking creating a google sheet then using the google sheet connector.
-
Issue with DDX Bricks
Hi, Anyway to fix this error message? I've tried with three different DDX Bricks and keep getting the same issue.
-
Freight Connectors
Hi, Just out of curiosity, what are some good Freight Connectors.
-
Automate DOMO pulling an Excel File
Hi, I have several excel files that I upload to domo manually every week. I was wondering what would be the easiest way to have DOMO grab and update the file automatically. This would be my first time doing this so if you could provide the steps that would be super beneficial.
-
Getting x axis sorted correctly
Hi, Any idea on how to fix this so that its in the correct order? The last two columns just need to switch. Its sorted by year and week right now.
-
YTD Calculation
Hi, I am trying to calculate a YTD number. I have a card that is set to Current Month and im trying to add a column that includes a YTD number. However, I seem to just keep getting this months numbers in that column. I have tried a variety of beastmodes but none seem to work. Ive tried SUM(CASE WHEN Fiscal Months >=…
-
Hiding Drilldown Card Title
Hi, I am trying to hide the title of the card when you drill down. How would I do that. I tried leaving the title blank on the card but it would not allow that. I also tried to edit the appearance on the card and unselect title but that just hides the title on the card and not the drill path.
-
Concat Formatting
Hi, I am having a hard time removing the spaces at the end of one of my columns. The beastmode im using is CONCAT(Consignee Address,', ',CONSIGNEE_CITYNAME,', ',CONSIGNEE_STATE). Some rows have a lot of spaces behind the consignee address and ends up looking like this 3835 KNIGHT RD , Memphis, TN
-
HTML to color cell green or red
Hi, I am using a pivot table and I am trying to color the cell either red or green if its greater than the goal %. I just need help with the HTML on how I would do that. Would I write it in a beastmode? The following code I have is as followed. CONCAT(CASE WHEN ((SUM(Empty Miles) / SUM(Total Miles)) > AVG(Goal)) THEN…
-
Indicator in Pivot Table
Hi, Is there a way to add an indicator, like you can in excel, to a table in DOMO? (For example, Like the green and red dots in the excel picture below)
