-
How to exclude/filter out based on 2 dates
Hello Domo! I uploaded a file/table in DOMO, that has a wipe date and a forecast date. What I was hoping to do is, to use this table and join it in my dataset, so that I can use it to filter out everything within the wipe date and forecast date. Is this possible? I am having problems with joining it to my dataset.
-
how to exclude all last Wednesday of every quarter?
How can I create a beastmode that exclude these dates from showing up in a card» 3/29/23 6/28/23 9/27/23 12/27/23 but also make it dynamic so that I dont need to hardcode these dates but it will exclude all last Wednesday of every quarter? thanks!
-
Card that will show if a Dataset has been updated
Hello DOMO - Good Day! I would like to know if it is possible to create a card that will show if a dataset has been updated? also, if it has been updated automatically or manually basically, a card that shows the dataset name, the date it ran, and if it is automatic or Manually ran. Thanks
-
How can I know the departments that have access to cards/dashboards?
Hello DOMO - Good Day! Is there a way to get a DOMO card to show a report of people's departments which departments has access to card/dashboards? Thanks
-
Who has access to Cards and Dashboards
Hello DOMO - Just wanted to ask if there's a way to get the people or groups that have access to a page or dashboard? We created groups to use to provide access to cards and dashboards. and we wanted to create a card to know who are those that have access to cards individually, those that were added to the cards or…
-
Capture Duplicates in DOMO
Hi DOMO - Is there a way to do this excel formula in Beastmode? =COUNTIFS($A$2:$A$8, $A2, $B$2:$B$8, $B2) basically, it shows the duplicates based out of 2 columns. what we have is the Name and the Title and the location we want to see how many names have the same title for example: Peter Manager San Francisco Peter…
-
DOMO Display Name reverting back
Hi DOMO Team - Question regarding the DOMO Display Name. when we update the DOMO Display name, we notice that some changes gets reverted back. We updated around 79 names and there are about 12 of them that keeps reverting back. For example, we updated Jim Redfield to James Redfield, after a couple of days, it would revert…
-
DOMO Groups filter
Hi DOMO Team - Good Day! I just need some help with regard to groups. we created a list of new groups for all our people and created a card to show all the groups that they are in and it shows that including the new group that we put them in. we would like to create a Beastmode where, when this person is in their 'legacy'…
-
DOMO Groups
Hi DOMO Team - Good Day! I just need some help with regard to groups. we created a list of new groups for all our people and created a card to show all the groups that they are in and it shows that including the new group that we put them in. we would like to create a Beastmode where, when this person is in their 'legacy'…
-
SyntaxError: Invalid JSON when using the DOMO Governance Datasets Connector
Hi DOMO - I just want to know why I am getting this error when I try to create a dataset using the DOMO Governance Datasets Connector > SyntaxError: Invalid JSON: <json>:1:0 Expected json literal but found N No subject alternative DNS name matching five9.com.domo.com found. ^ at line number 24 Need help to know what I am…
-
How to Make a Weekly date range into a Daily Date?
Hello Domo Dojo Masters - Good Day! We have data from salesforce that only has a start of the week and end of the week date columns>>> How can I make it so that we can have a daily date?
-
How to make my BeastMode dynamic
Hello DOMO Dojo - I have a beast mode that deals with dates, I am wondering if there is a way to make the date dynamic Here's my formula>>>> (case when (`TC: Created Date` >= '10/1/2025'and`TC: Created Date` < '1/1/2026') and (`TC: End Date`>= '7/1/2025'and`TC: End Date`<= '9/30/2025') then 'Q4 2025' when (`TC: Created…
-
How to create a filter to capture the end of month
Hello Domo community - Good Day! Basically, we want to capture the data from the previous month on the current week. for example, the start of the week is 8/28 and the end of the week is 9/3. we want to capture all data up to 8/31 only. and then data for 9/1 to 9/3 using the start date 8/28 or end date 9/3. Thanks
-
how to break a week between months
Hi DOJO - Happy Weekend! Basically, we have a dataset with date columns based on the start of the week and end of the week only. on the example below, I just concatenated the start and end dates so it shows Aug 28 to Sep 03. if its not concatenated, I can put start date and it would show the start of the week which is…
-
Calendar Creation
Hello - Can I create a calendar table based of a start date and end date? I have the start date and end date that encompassed a week, and then the columns for sunday to saturday what I am trying to achieve is, to put dates as well to the columns for sunday to saturday for example: the start date is 9/4 and end date is 9/10…
-
Trying to create a nested Case statement with multiple conditions
basically, I need to first attest that it is in the current quarter, and then I need to look at the column for confidence whether it is A or B, if it is blank, I look at column trust whether it is A or B, if it is also blank, I look at the status column if it states committed then 'True' else 'false' I am able to do the…
-
how to capture the current quarter using beastmode
Hi Domo Masters - so, when we want to capture the current date what we do is we use>>> Case When 'Date'=Curdate() then 'True' else 'False' end is there a way we can capture the current quarter? Thanks!!!
-
How to create 2 Output Dataset in DOMO (unable to load this dataset issue)
Hello everyone - Good Day! I just need some inputs. I have a dataflow with 4 input dataset and 1 output dataset. When I add another output dataset and hit preview, it showed all green checks. However when I saved and ran it, that 2nd output dataset shows as "unable to load this dataset"? any reason why it is unable to load?
-
SNAPSHOT ETL DATAFLOW
Hi Beatiful People - I was able to learn how to create a snapshot etl dataflow, just a quick question, where in the dataflow can I add a column that shows the date for the historical data and the date column for the appended data?
-
Report to show how many cards use the same specific dimension
Hi Dojo - Good Day! Just wondering how I can create a report in DOMO to show how many cards use the same specific dimension in one dataset. for example, I have a Employee Information Dataset and I want to know how many cards use the dimension employee ID Thanks In Advance!
-
Beastmode Cleanup
Hello Beautiful People - Good Day! I am doing some Beastmode cleanup and I have a few questions. If I delete a Beastmode, will it be deleted in all cards it is in, regardless if it is being used or not? Also, What is the best way to find duplicate Beastmodes? Lastly, which is better? deleting an unused Beastmode or…
-
changing a name in ETL
I have an employee name in my raw data shown as >>> last_name, First_name middle_initial Doe, John H. or sometimes shown as >>> Doe, John Dorian H. How can I make it so it would appear as >>> John Doe or John Dorian Doe in DOMO using ETL or beastmode? Thanks
-
Drill Path from same Dataset returns zero value
Hello Dojo! Basically, I have a page that shows the most viewed pages, what we want to see in the drill path is when we drill down, the most viewed cards on those most viewed page. when I do it from separate cards, I can show them fine, one card has the most viewed page the other the most viewed card. they are using the…
-
how to show a duplicate in a table graph
Hello Dojo! basically, we have a dataset that shows the number of beast modes we have created along the years. what we have is one column for the beast mode name, who made it and when. what we do not have, and what we want is a column that identifies that this beast mode is a duplicate. It would either show "1" or…
-
I am trying to get the timecards created this quarter for last quarter
I am trying to get the timecards created this quarter (Q2) but for last quarter (Q1) the reference dates are created date(current quarter) and end date(previous quarter) so, I have this created in beastmode>>> (case When `TC: Created Date` >= '4/1/2021' and `TC: End Date`< '3/31/2021' then 1 else 0 end) how can I make the…
-
Workbench Jobs
Hello beautiful people! I have a new laptop since my old laptop crashed and died. how can I get the jobs that I had from my previous Domo Workbench into the new one I installed on my new laptop?
-
Comparison of data in Graph from different Dates
Hello Beautiful People! Need your input on how I can compare data from different dates basically, we have 3 columns, the acct numbers, sales and dates it is a basic daily upload of data, which means that we get the same acct number more or less, and new sales per day for the same acct numbers on different dates what I need…
-
how can I use salesforce with upsert to create a monthly historical data?
Hello Beautiful People - how can I use salesforce with upsert to create a monthly historical data? basically, we want to have a month end snapshot every month, while during the new month, data gets updated. Thanks!
-
distinct count not working
Hi all - I just want to know why the distinct count in beast mode is not working.. in the screenshot, I have a count distinct on the resource names, but there are still duplicates appearing and being recognized as distinct. I am using this formula COUNT(DISTINCT CONCAT(trim(`Test Taker: Resource Name`))) any thoughts?
-
chart data creation question
hi all - I would just like to know how to add the highlighted section in DOMO(column B) . I have the column C coming from a Dataset. Also, the first number in column B (1504) is a static number that will be built upon... how can I put that in there? also,
