-
How to transform from Excel Sumif formula to Domo ?
Hi, I have a data report with a template that looks like this in Excel: And I need to transform this into a card. So far I managed to make beast mode like this: Sum( CASE WHEN CONCAT( product_code, "_", account_id, account_name) = account THEN Value ELSE 0 END) AS 'Cost' But how do I take into account that the value for…
-
How to get Domo to recognize numbering as 1,2,3,... instead of 1,10, 100, 110,...?
Hi, I have a daset that I want to build a Sumo card on. But as I build the card, it's clear that Domo tried to sort the categories by itself, causing the view to be something I don't quite want. I tired adding numbers before each category, but instead of arranging the numbers by 1,2,3,... Domo somehow arranged it to be in…
-
How to update a Domo dataset linked to a Domo app from the app?
I have built a Domo app and successfully uploaded it into the App design, and linked it to a sample dataset uploaded using webform. Another app used CSV dataset. My question is, what is the code to add new data to the dataset from the app? Is there any JavaScript code or any advice that anyone can pinpoint me to? Thanks!
-
How to create a text card like in Tableau or Power BI?
Hi, I need to build a text card that looks like this in Power BI: or a similar summary number feature in Tableau. How can I do this in Domo? I am so far using Sumo card to show it, but even this doesn't show the whole value. It just showed the 2.1M instead of Total Sales: 2,124,650. Which is what I need to create. Any…
-
How to Connect and Save Data from a Domo App?
I have built a simple app and upoladed it to Domo. Put it simply it works like a calculator, although of course this is a very early prototype. So a user is prompted to input two values (x and y) and upon pressing "calculate", the calculator app will show the multiplication result of the two values (x*y). Now my question…
-
Error: 'Location' is undefined when trying to publish Domo app
Hi, I followed the instructions in Domo Developer app building to create a very simple app. I now have a basic app that I want to upload to Domo, but everytime I enter and click enter on domo publish in the CLI, the system sent an error message that shows a message like the attached file. 'Location' is undefined. Can…
-
Domo Developer: How to resize the card size to fit the screen?
Hi, so I have successfully uploaded a simple app to Domo using the guidelines in Domo Developer site and adjusted the css margin and padding. But when I uploaded the app to Domo, the result looks like this: Can anyone tell me how do I adjust the card size, making it full screen or utilize the space of the grey area? Thanks!
-
How to solve Microsoft JScript Runtime Error: location is undefined when publishing Domo app?
Hi, I have built a very simple app in my comp using the instructions in Domo Developer site: https://developer.domo.com/docs/dev-studio/dev-studio-quickstart I managed to get until the domo publishing step, but can't publish it due to this error message: So everytime I type domo publish in the command prompt the error…
-
ETL joining causes an output dataflow that is too big?
I am very new in using Domo, so hopefully I can explain my situation well. I have three datasets that have different column names and structures, even though each dataset has same columns too, like 'Employee Name' and 'Employee ID'. I tried to join them (using inner join) and run preview with 10k limit, but it showed the…
-
Any suggestion for building a similar chart like this from Tableau?
I have this chart created in Tableau, but now I need to recreate this chart in Domo. The chart will have two categories and two measure names, as well as an x-axis and two y-axes, like this: The chartMeasures I tried the line + grouped bar but it doesn't seem to completely recapture this card in Tableau. Any suggestions as…
-
How do I translate this Tableau code to Domo?
Hi, So I need to translate code from Tableau to Domo and since I am very new to Domo, I will need your help to translate this Tableau code that looks like this: { FIXED [Employee ID],[Area Code],[Supervisor Code],[Day of Date]: IF SUM([Commission A])>SUM([New Base Salary Current]) AND SUM([Commission A])<SUM([Second Base…
-
How to Translate Tableau's Fixed function in Domo?
Hi, I encounter a lot of Fixed function from Tableau when trying to translate it to Domo, but I can't seem to find any reference to such function here. One example is a measurement (let's call it 50-percentile Area) that looks like this in Tableau: { FIXED [Area group]: PERCENTILE( { FIXED [Building Code]:AVG([Number of…
-
How to only show the amount of monthly value only once instead of the sum over the whole period?
Hi, so I have a dataset that looks like this (fictive dataset): Employee Name Date Sales Monthly Quota Sally 11/3/2018 5,000 10,000 Andrew 11/3/2018 4,500 15,000 Michelle 11/4/2018 3,500 9,000 Sally 11/6/2018 1,000 10,000 Sally 11/7/2018 700 10,000 Andrew 11/8/2018 2,500 15,000 Andrew 11/9/2018 3,000 15,000 Sally 12/4/2018…
-
How to only show the amount of monthly value only once instead of the sum over the whole period?
Hi, so I have a dataset that looks like this (fictive dataset): Employee Name Date Sales Monthly Quota Sally 11/3/2018 5,000 10,000 Andrew 11/3/2018 4,500 15,000 Michelle 11/4/2018 3,500 9,000 Sally 11/6/2018 1,000 10,000 Sally 11/7/2018 700 10,000 Andrew 11/8/2018 2,500 15,000 Andrew 11/9/2018 3,000 15,000 Sally 12/4/2018…
