Making a Field to Calculate 'Yes' or 'No' Sales for last quarter
I am attempting to build a beastmode that gives me a value of ‘Yes’ if there is a “sale” in last quarter or a "no' if there isn't. Here is my code so far: *‘End of Business Date’ acts as a current date function in our dataset. The issue with this is that it does count all the rows from last quarter as a ‘Yes’, but if there…
How to do a running sum of count from current month backwards with consecutive months
I am trying to make a beast mode calc where I calculate if there's a count in the current month, it's a 1, and if there isn't, it's a 0. However many months it goes back consecutively it will add to the total count. I.E. if there's a count (or sale) in Feb, Jan, Dec then that will be a count of 3. Currently I am trying to…
Column Width in Domo Dashboard
I have a card/dashboard that has quite a few columns in it. I want to be able to display the full values of some of the columns and limit the spacing of others. Is there a feature in DOMO that allows me to do that?
DOMO Rank System
I have this card that I'm trying to rank by each month. It seems like it's ranking the numbers with both months, but I want them ranked individually by month.I.E. between 9 and 10 #9 is under Jan but #10 is under Feb. This is the beastmode so far. Rank() Over(order by COUNT(`Certificate#`) desc) Also is there a way to…
Grouping into one Row
I want to be able to group the parent_wID field so that it is one row per entry. As you can see, the Retail/Wholesale columns are build from beast modes from a separate field. This is the syntax i used to separate those. "Retail" (CASE when `Loan_Originator_Type` = 'Retail' THEN 'Yes' else 0 end) "Wholesale" (CASE when…
GoToWebinar API Custom Connector
My organization needs to build a custom API connector from GoToWebinar so we can connect the survey data and integrate it into DOMO. I don't believe this connector exists and I have never built a custom connector before. Could anyone please assist on how we can start this process and what can be done to make this an…
Hi all, I was wondering if anyone knows how to connect all accounts in an organization to one GoToMeeting dataset and have it update everyday? We want to access all the survey data from the meetings and have them be automated and integrated into DOMO. Any help would be great!