-
Creating a beastmode that filters
Hi, I am having a hard time with this simple task. I have a column in my dataset called Lane, which is formatted as followed 'PointA>PointB.' I am trying to create a card on a dashboard that if PointB is selected it will filter all lanes that either start with PointB or end with PointB (exmple 'PointA>PointB' would show up…
-
Editing the 'Form and Dataset Brick'
Hi, I am trying to create a form to collect 3 fields from the User and have it write back to a dataset. I downloaded the 'Form and Dataset Brick' since it does most of the heavy lifting for you, but anytime I edit anything in the JS like delete the table function or the search function the entire app messes up and I cannot…
-
Is there a DOMOStat that shows what users have access to what Pages/apps?
Hi, I am wondering if there is a domostat connector that shows what users have access to what pages/apps? Thanks!
-
Why is the Searchable DDX brick not filtering the page?
Hi, This is driving me nuts (someone with very minimal JS). The only code ive changed in the DDX brick is as followed. How come when I select a report number from the DDX brick, no cards get filtered and the global filter doesnt update? However, if I use the control on the right side of app studio, and select a report…
-
Thinking about using searchable filter brick in app studio
Hi, I am trying to use the searchable filter app to allow the user to search an order number and once selected, they can click on the search icon(see image below). Once the User clicks on the search icon, it directs them to another page in the app with the cards filtered to only that Order Number. Is it possible to make…
-
Sum Distinct Not working Correctly in the Total
Hi, Am I overlooking something? I have a table and a beastmode using sum Distinct, however the total is not adding up Correctly. The total for Projected Loads should be 12,682 not 8596. I dont see any two numbers in the sub totals being the same. Thanks in advance
-
Where to find Documentation?
Hi, I am trying to split a string and I cannot find which method to Use. Ive tried the substring_index method and the split_string Method and both have failed. I am trying to extract the city name out of a string that looks like this "CARROLLTON,TX/" Thank you
-
Calculating True AVG of column with same value
Hi, Am I missing something or misusing something? I have this beastmode to calculate the True average of a column called Days_In_Service, however it just appears to be adding up the distinct values and not dividing them. If the Unit# is the same then the days_in_service will be the same. I am trying to avoid the situation…
-
Charting with a filled gauge.
Hi, 2 part question. For reference I am using 1 gauge and a variable to switch between revenue/ cost/ margin view. 1) I am using the gauge to compare to budget. I am wondering for the color of the gauge is it possible to have it be green when Margin/Revenue is above the target line but green when the Cost is below the…
-
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…
-
Alerts within DDX Bricks
Hi, I want to make sure I can accomplish this before actually spending the time to create the brick. I have an app with about 7-8 pages. I want to create a ddx brick on the main landing page that will display important information about certain order numbers. The part that I'm not sure is possible is can I have the brick…
-
Recreating a Line Bar chart
Hi, I saw this chart during a demo and I think its very cool and useful. If you look at June 2024, they have a stacked bar chart. How do they accomplish this? I know you have to project the Future value out but I'm having a hard time getting them to stack. Any Advice would be great (What I am going for) (What I have)
-
Using a Form DDX Brick.
Hi, Is it possible to collect user feedback using a DDX Form Brick while publicly embedding an app. I have this form that I created modifying the DDX form brick and I want to use domo everywhere and have it set to public to collect user feedback. It works when it is set to private but the whole goal is to collect our…
-
Back arrow on Drill Path
Hi, For some reason when I have a drill in place card on an app, I dont get the option to go back once I drill down(the arrow in the top left of the card once drilled down). Is this a feature that is possible in app studio. App studio card when I drill down. Dashboard card when I drill down.
-
Allow the last card in a drill path to filter the entire dashboard
I want to be able to drill down in place on a card while also allowing the last drill path to filter the entire dashboard. There's been multiple times I've been working on a project and wanted to implement this.
-
Drill in place to filter the Dashboard
Hi, I currently have a map card of the United States that allows the user to click on a state and it drill in place. (Works great) from there I want the user to be able to click on a customer within the state and whole dashboard gets filtered by that customer. Is that currently possible?
-
A preset Filter that has current Month
Hi, I am creating an App in App Studio and I am trying to allow the user to filter on the past 12 months. However, I want the preset filter to be the current month so that if they want to see previous months they'll have to filter for it. I tried using DOMOS date field option but when I select Current month then try to use…
-
Using Sum Distinct in Domobrick query
Hi, How would you go about fixing this error? When I remove Sum(Distinct) it works but I just want to add up the distinct values. Am I writing this wrong? The column name is called TotalProgress.
-
Filtering inside a DDX Brick
Hi, I am currently trying to filter on the date inside my DDX brick to only give me the current month data. The date Column I am using to filter is called Fiscal Months. How would I do that? Im assuming it has to do with the way im querying the dataset. I attached my JS below. One thing to Note is that date column is…
-
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'."
