-
Join Issue
Good afternoon! I am having a join issue where only my inner join is working, but I would like to either a left outer join or a full outer join. I am trying to join 417 rows of data to 15 rows of data. Thank you!
-
Scheduled Reports
Hi Guys! Is there a way to show more than three columns in the email body for scheduled reports. I know there is an option to include an attachment, but I wanted all the columns in my card to be shown in the emailed report. Thank you 😊
-
CMiC
Hi Guys! Has anyone worked on getting data into Domo from the CMiC ERP system? I am looking for ideas on how to get that data and possibly what connectors or APIs I should be looking to use. Thank you ^_^
-
Data Cleaning
Hi guys! I am trying to clean bunch of time codes and I have a first line code that's valid, but I am having trouble cleaning other codes such as 'hourly' and 'salary' lines of code without error. case when Right(`Entry Store`,5) = 'PTO"}' then 'PTO' end
-
Automated Feeds from Verizon to Domo
We are trying to automate the data feeds from Verizon to Domo. We tried to use the email connector, but all we get from Verizon is a link. Has anyone worked on something similar? Thank you!!!
-
Card Data
Hi Guys! I have a warning about not all data being shown in my card although i have selected all rows. Does anyone know how to fix this issue? Thank you!!!
-
Requests Older than 6 Days
Hi Guys! I am trying to capture dates that are older than 6 days, but this Beast Mode is showing me zero although I know I have some. SUM(case when DATEDIFF(`Effective Time`,CURRENT_DATE()) >=6 then 1 else 0 end) Thank you!!
-
Dashboard Filters
Hi Guys, When I filter the date range by week I am getting the week of 05/27/2022 to appear on my card, but I am not getting the June of 2022 or the year of 2022 when I try different ranges. CASE when MIN(`Period_End_Date`)=MAX(`Period_End_Date`) then DATE_FORMAT(`Period_End_Date`,'Week of %b %d, %Y','month of %b %d, %Y')…
-
How do I stop my tile from Aggregating
Hi Dojo! Could you help with this: I see that when I first expand my tile under Aggregation I can choose to not aggregate. however, in the bottom where it says Subtotal/Total under Calculation it is using sum and not giving me a no aggregate function. Thank you!
-
Beast Mode
Hello Dojo! Does anyone know what I am doing wrong here. Thank you!!! case when `Union_Class` = 'A1' then case when `Class` IN ('A1','A2','A3','A4','A5','A6','EO','TB','TA','J','SF','F','SGF','GF') then 'Normal' else 'Error' end else case when `Union_Class` = 'A2' then case when`Class` IN…
-
Card Drill
Hi guys! Do you know of a way to arrange the columns for the drill view? I know you can arrange the columns as a user and an admin within the drill view, but it does not save, so I am looking for a permanent solution. Thank you so much!
-
Beast Mode vs Formula Tile on Magic ETL 2
Happy Friday Dojo Community! Does anyone know why a Formula would be validated by Beast Mode but show as an error for the Formula tile on Magic ETL 2? Also, is there any online guide that could potentially be helpful? Thank you! 😊
-
Beast Mode
Hi Guys! How do I include the specific `job` selected by the user in the `you're filtering correctly' message? CASE when MIN(`Job`)=MAX(`Job`) then 'You Are Filtering Correctly' else 'Error: Select A Single Valid Job' End Thank you!!
-
Beast Mode (Card)
Hi guys! I have repeated names that I am looking to sum via beast mode but the sum function is not working. I am also looking to select certain department numbers from a department. Please help! Thank you ^_^
-
Join in Domo
Hi everyone! I am looking to get the below outputs for the for the following columns in Domo: Distinguished Name Column: CN=Janet Jackson,OU=Users,OU=Technology,OU=TheArtFactory,DC=artfactory,DC=priv Output needed: Janet Jackson Manager Column: CN=Joe Jackson,OU=Users,OU=Information…
-
Free Domo Upgrades
Can anyone tell me about cool free domo upgrades I can ask for such as Magic ETL 2?😁
-
ETL Value Mapper
Has anyone noticed that the value mapper tile has stopped working after one tile? Whereas it would perfectly work on the third tile in creating a new column for your new values and "if no match is found in row write no" and vice versa. It was working just fine last week