-
Switching a Dataset to a Workbench
Hi, I have a dataset that I update manually and use in multiple ETLS. What would be the easiest way to get that going through Workbench without having to create a new dataset. Unless that's the only way. Thank you
-
ETL Wont let me 'Edit' then 'Run'
Hi, I am wondering if this might be a glitch or what might be causing this problem. I have an ETL that I am trying to edit. The only dataset it uses is the calendar dataset. I am able to run it by going to the dataflow, clicking the three dots, then Run. (See attachment if confused) However when I click edit etl, and…
-
Multi Value columns Displaying wrong %
Hi, Am I missing something here? I have this card that compares last month % to this month %. However, It is not adding up correctly and I cant seem to figure out why. The 19% is the correct value for this month. Last month the value was 23%, I am not sure where 14% is coming from. If I switch it to a table view you can…
-
Multiple Values for Data science Chart
Hi, I am wondering if I could also display the low below the low Line in this chart as well. Thank you
-
Creating in app studio, posting in IOS/Google Play App store
Hi I read that its possible to post your app in IOS/Google Play store. How would you go about that? Thank you
-
Formatting Variables
Hi, I am using a variable and some values are %, others are $. However, I the formatting doesnt seem to change when I try to switch them to a string by using concat and adding a % or $. They just come out as 1000 instead of $1000 or 57 instead of 57%. Here is my beastmode. What might be causing this? CASE WHEN…
-
Disable the collapse option
Hi, Is there a way to disable the collapse option on a table so users cannot collapse a table. I want all rows to be visible. Thank you
-
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.