-
Unusual error with console.log
Hello, I'm starting a project in Sugarforce and I can't console the query results. Both datasets are correctly defined in the manifest file Although, when looking in the Network tab of Chrome, I see the results I've restarted my browser and still nothing in my console. Has anyone dealt with this or a similar issue before?…
-
Phoenix error - unsure why
Hello all, I'm exploring Phoenix charts and I have my query like this: const ds = 'DS_Name'const select = ['dept_code_name', 'absval', 'trx_date'];const where = ['account = 8981', 'dept_code = 459', 'trx_date last 1 month'];const dategrain = ['trx_date by month'];const query =…
-
Beast Mode - forEach
Hello. So I have this dataset where I get item, work order and the quantities both planned and actual. This is to calculate manufacturing absorption %. Is it possible, via beast mode, to tell the function that for each distinct work order, it sums its quantity and displays it as the total of Actual production? If I do an…
-
Pivot Table card order
Is it possible to have the total column at the beginning of the table? In the example below, it would be the yellow part of the table... I didn't find any related property...
-
Pareto 80-20
As we know, a Pareto is used to display top offenders based on their impact in the analyzed data. How can I limit a Pareto chart to only display items that are below or equal to 80% of the total? There's no chart option for it, so I assume it's gonna take ETL or SQL to solve this, any ideas or guidance please? Also, this…
-
Round function
Hello, I have a beast mode that calculates a % and I need it to round to 2 decimals. I'm using the round function as described in the documentation: CONCAT(ROUND(1-(COUNT(DISTINCT `nc_list`) / COUNT(DISTINCT `lot_number`)),2)*100, '%') However, the result is being rounded to the whole number I need it to, using the example…
-
Domo CLI not working
Hello, any tech support advisor roaming here? I'm unable to domo init, dev or publish. I've recently configured my laptop for React.js development and I'm unsure if that screwed up my domo cli configuration I'e already tried the ryuu commands seen here https://developer.domo.com/docs/dev-studio/next-steps-2 I've also…
-
Hide Appendix in Dashboard
Hi guys, is there a way to collapse the appendix of a dashboard, like in normal view? If so, how can I do it? Thanks in advance.
-
Negative value as 0
Good day, I have a chart that based on the data, it can sometimes display a negative value in the percent trend line. I want this value when negative, to be set up as 0. Specifically, because of this week's situation in particular: Any ideas on how can I make the negative be reflected as 0? Thanks!
-
View last 2 weeks of data
Hello. I know there is an option to view Previous Week data. But how can I manage to display a week before the Previous, JUST AND ONLY the week prior. Example This week is 16 of the year Previous week was 15 Pior to that, it was 14 I want a chart to display only data for week 14, and ANOTHER chart to display only Previous…
-
Concat + Round
Hello, I need a text card that has a specific text concatenated to a beast mode, which is a percentage value. Currently I have the syntax as: Concat(TEXT, Round(BeastMode*100,2)) But it returns this And my scrap values is of 2.09% (0.02089 in the beast mode before multiplying by 100) Any help provided is appreciated.…
-
Pivot Table conditional format
Hello, I have a pivot table card where I need to compare if the value is greater than the goal, and paint that field in red. How is this possible? I can only compare it to a single value, but it is not the same over the timeframe I have. Thanks.
-
Conditional drill down
Good day, I have a card that I'd like it to do a conditional drill down. This is, when in the first view of the card, depending on the selection clicked, go to one of several cases. Let's say I have my overall plant data plus a breakdown by area, all that in the same first view. If I select to drill down to the overall…
-
AppDB Error Handling
Good day to all. Developing an app using the serverless technology, I've encountered a minor roadblock. My dataset needs to have an ID column to use it as TransactionID, that is, on every submit I make to the database, it will work as an auto increment index on those fields (1 to N). Next call to the DOM and eventual…
-
Display array values
Hi, I have been able to create a query that receives a parmeter so it filters the data on a given choice, and I'm able to send that into the console with a table view. How can I do so in HTML to display my data? I appreciate any help with this.
-
Inner Joins
Hello, are inner joins supported in SQL for AppDB? var queryJoinTest = "SELECT REC.nombrer, RED.nombreo FROM Reconocimientos REC " queryJoinTest += "INNER JOIN Redeem RED ON REC.empr=RED.empo AND REC.empr ='" + EmpN + "';" I've tried it in the same code line and sepparate, and it works both ways with a normal query. But it…
-
AppDB Null Date
Hello people, when creating a dataset via AppDB, is there a proper way to specify that a field can be null, in this case, a date field? I need it null so then I can select null dates and do other stuff with those records based on an ID filter. Hope I explained myself, thanks in advance!
-
APP DB Updating
Good day Domosapiens As previously explained in Dojo, I'm working with the APP DB technology, trying to emulate a website within Domo. I got my input form working with it's own dataset Additionally I'm trying to make an update form, where after querying my results, I want to be able to modify that same record by its…
-
Custom App / Dashboard Filter
Hello, is it possible to have page filters within a custom app? All my datasets have configured the same ORG field, and I want it to be set up to my organization, and whenever a card is loaded, get only the filtered data... View this snapshot of my custom app. I created button groups to select the card I want, but I'd like…
-
Chart with input form
Hello, is this case possible to achieve? I have a card, with drill downs. Bar chart, pie chart...I click on one of the sections and when reaching 2nd/3rd or N level of drilling, user can click into a section of the graphed data and open an input form (most likely created by APP DB technology) Did I explain myself clearly,…
-
Domo.Navigate
Hi, this is related to this other post https://dojo.domo.com/t5/Domo-Developer/Domo-Javascript-Navigation/m-p/43888#M1305 This is the structure of my app: My index.html is my main page, it has a button that when clicked I want it to navigate to second.html Code for my button is: <input type="button" value="Search"…
-
Domo Phoenix Aggregations
Hello, I'm new to Phoenix and reading the documentation I'm not able to find how can I aggreate a value. Let's say for example, I have an input form that generates an API Dataset which I can create charts with. An example of a simple bar chart looks like this: In this example, I'm using postBody to make a COUNT…
-
DP19 Advanced App Building
Hello, I'm starting to explore DP19's advanced app courses and trainings. In my testing app, I've made some changes to the original code shown by Jason Hodges, and I have some questions 1. For the attachment, how can I make it to open in a new window instead of downloading every time? I have this: As you can see, I already…
-
Background Image Custom App
Hello Dojo Community I created a custom app with HTML/CSS and uploaded to my Asset Library, but I have a problem The index.html is supposed to load a background image (path defined in the css file). It loads perfectly fine in the dev instance but it doesn't work when published to Domo Any ideas why? Thanks in advance.
-
Domo User Name
Hello, maybe a silly question domo.env.userId This line gets the id for a Domo User, but how can I get the User Name?I'm recreating DP19 Advanced App Building Exercise and I'd like my app to have the username instead of the id, this will be helpful for when I create custom apps for my company Thanks in advance
-
DQL Documentation
Hello Dojo Community, where can I find more documentation on the DQL stuff? I want to know how to tell the code to get all records which a given column string is like '%TEXT%' Thanks in advance.
-
Domo Javascript Navigation
Hello all. I have a custom app where I want it to open content in a new tab when clicking on an element. It is a table and each row I need it to have this behaviour. In Javascript there's the window.open command but it does not work with the Domo CLI and I don't know how to tell the code to do this behaviour in the…
-
Multiple orderby and groupby
Good day, I'm trying to get data where my Lot Numbers repeat and I want to consolidate them in 1 single record. This is the code I tried for retreiving the data: dataString='/data/v1/reserve?filter=Org='+ orgFilter + ', Planner='+ pcFilter + '';//'&groupby=LotNumber'; It does get the records and groups them, but instead of…
-
Multiple orderby
Hello, what's the best way (sintax) to have 2 or more order by in my query? Example: dataString='/data/v1/reserve?filter=Planner='+ pcFilter + '&orderby=PartNumber, LotNumber' I currently have it only with the PartNumber, but I want to do it with those 2 fields. Thanks in advance.
-
Pie Chart Conditional Drill Down
Hello, I have a chart with Open/Closed status and depending on the status that the user chooses, it's the custom table view they want as drill down. Example: if Closed is clicked, users want to see a Completion Date field. If Open is clicked, they want to see a Due Date Field. Is there any way to achieve this? Thanks in…