-
Dayforce Connector
Hello Has anyone used this connector and did you have any problems with the credentials? We had someone with Admin role try to use her credentials to connect but it says invalid. We are trying to work with Dayforce to figure out the issue, but thought I'd ask Thanks
-
Zip2Fips - map card issues
When I try using a United States map card or a State map card, I get the result in the screen shot I've attached. In this example, I've narrowed it down to 2 donors from Illinois (shown in the data table below the card). I am using the column "zip2fips.donor_state_tz" column for the "select county fips code" for US state…
-
Dayforce Connector
Hello, Curious if anyone has used the Dayforce Connector and what kind of credentials they needed to insert. For username and password, would that be the username and password of someone in the company with an admin level Dayforce account that they use when logging onto Dayforce?
-
Text message when domo workbench job fails
Hello, Does anyone have any ideas on if its possible to receive a text message on my phone when a workbench job fails? I get emails when jobs fail, but I don't keep Outlook notifications on my phone because my phone would just ding all day long. Too many times on a Monday morning I've discovered a job has been failing…
-
Dayforce Connector
Hello, Does anyone know if the Dayforce Connector still exists? When I Google "Dayforce Connector Domo" it takes me to a page for Ceridian Dayforce Connector (shown in screen shot). But since I accessed it through Google, it asks me to sign in. So I click to sign in, but it then just becomes a blank page. On the other…
-
Creating buckets for unique ids to fall into, based on the sum of donations of those unique ids
Capturing donor frequency: We want to count the number of donations a donor has given per procedure. The amount of donations is the bucket I want donors to fall into. So, if we had 100 donors give 4 donations, we want those donors to fall into the bucket '4', and then we would count the unique donor ids. The part I am…
-
Magic ETL Formula Editor Tile - Minor glitch
I am just wondering if anyone else has been experiencing this. I couldn't find any related posts. In the formula editor tile, I will literally click on the column name from the list below. When I am done with the formula and click "validate" I get an error regarding the column I selected and it says "table doesn't exist"…
-
Original, historical dataset of recursive dataset still needed after 1st run?
Sometimes when we bring in a new data table into DOMO, we'll want, for example 5 year rolling history. And instead of pulling 5 years of data every day, we pull it once, feed it into an ETL output, then change the input of this ETL from the original 5 year dataset to the new output. then append a 1 day update. My question…
-
Scatter Chart - Drilling Down
Good morning, I've attached an image of a card a user has built using a scatter chart. The X Axis represents the day of the week, the Y Axis is the amount of hours it takes for blood products to go from collected to labeled, and the bubble size is the count of products that land in that hour time period. When we want to…
-
Improving Dataset performance by removing unused columns
Hi there, I have a dataset that has become sluggish and increasingly gives people problems when viewing cards or dashboards created with this dataset in terms of taking very long to load (or load at all), and is sluggish in analyzer as well. To attempt to improve performance of this dataset, I am going to remove a lot of…
-
Converting UTC to Central - Daylight Savings
Good morning, One of the databases I pull data from into DOMO uses UTC, so, to get it to Central time (my time), in the ETL I just do CONVERT_TZ((`HC_store_orders.created`), 'UTC','America/Chicago') However, the tricky part is that it seems to convert to Chicago time based on what Chicago time is today, versus what it was…
-
Appending an update set to itself
Hi, I have a MySQL dataflow that is built from API reports from a vendors application. The idea is that we did a one time historical pull of the API as dataset 1. Then, the same API that only pulls 1 day of data and appends to the historical dataset as dataset 2. But, every once and a while it seems as if data is dropping…
-
Line plus grouped chart - getting Y axis and 1st series on left scale, 2nd series on right scale
Hi there, On the attached image, the Y axis value and the first series value are counts. Y axis = count of all orders (the blue line) First series column = count of delayed orders (the green bars) The second series column = (count of all orders - count of delayed orders)/count of all orders. Or, in other words, the percent…
-
ETL setup - duplication breaking calculations
Hi, I'm making a dataset where the concept is to take staff's login and logout times and figure their logged in hours per day. Then, we want to know certain measures based on their hours logged in. So, in ETL, I've gotten their total logged in hours per day to one row, grouped by the date and the staff member. Then, group…
-
Card setup
Hi, I am not sure if this is possible. In my attached image, the bars in the Y axis are a beastmode calculation for a percentage Below, in the highlighted section, a user is wondering if, instead of the %, it could instead show the denominator of the percentage It does not seem so as the "data table" section in chart…
-
SQL - join where a column is between a number range
Hello, I cannot for the life of me figure out why this "where" clause is giving me troubles, I have used this logic a thousand times with no problems. The problem is coming on my join of c to a. Specifically, it seems to happen with my "where c.result_code is greater or equal to 9.5 and c.result_code is less than or equal…
-
Table Card - Total to be % calculation rather than SUM, rows by week
Hello, I've attached an excel workbook showing a sample bit in its raw form, what I want to get out of that, and what I am getting. I'm primarily having two issues: Getting everything on 1 row by fiscal week. I can accomplish this until I add a percentage beastmode, then the rows will no longer be condensed to 1 row per…
-
Pivot Help
Hi, I have a situation where a column my have different rows of the same values, but the values are in different orders and therefore they are different buckets in cards, when they're actually the "same" thing. And example of this is in A1:B3 of my attached image, where both rows under the BH_TAT.Antigens column have the…
-
ETL Pivot Help
Good morning, I have something I'm struggling with. In my screen shot attachment, the top table is how the data currently is. The bottom table is how I want it. This example is just 1 drive ID (157624 far left column) and it has 2 shift id's (257650 and 257651). For every different drive id, the shift id's will be…
-
distinct count of concat (column) , row_number over partition by (column) - Why isn't this working?
Good morning I'm curious if anyone has any insight into why this beastmode doesn't work, because if I could get this to work, it would solve a lot of work for me. The beastmode that doesn't work for me is: COUNT(DISTINCT ( CONCAT(`hs_rpt_drivemaster.driveid`,'',row_number() over (partition by…
-
Domo Governance - Finding out which columns are not being used at all in datasets
Good afternoon, I was wondering if anyone has any current strategies for having a card that tells which columns in all of your datasets are not being used at all, or the frequency at which columns are being used. I see a drop down list of reports to choose from in the Domo Governance Connector. In one report from Domo…
-
Change color of the data label values
I have attached an imagine of the card I'm trying to modify. I have a line + grouped bar chart. In the image, the red line is the budget numbers, and the green bars are the actual numbers. I'm trying to get the value numbers for each metric (budget and actual) to be different colors. So for example, I'd want all the number…
-
Partition in Beastmode
I'm hoping someone may be able to help me understand what I am doing wrong with my beastmode logic, or if what I am trying to do is just not possible in beast mode. I have done rank and windows in ETL before, but I am trying to avoid creating a separate dataset. I'm wanting to filter my card to locations, by day, that had…
-
character in saved beastmode some how replaced with exclamation point - !
Good morning Has anyone ever experienced a character in a beastmode syntax being replaced by an exclamation point? I created a beastmode probably about a year ago and validated it against the data, and at the time, it worked properly. We've since updated to a different dataset and copied all the beastmodes from the old…
-
Filtering based on distinct count values
Hello, The discussions I've found that are similar to this seem to suggest using ETL, which I think I might end up having to do, but just wanted to see if there are any beastmode ideas out there. I'll refer to the column headers as Date, Collection Code, Donor, Donation ID, Data Entered?, Distinct Count of Data Entered,…
-
Multi-Period Projection by Week
Hi everyone, I have a scenario that is stumping me. I'm trying to use the Multi-Period Projection in chart properties to project the next 3 periods. Projection Period Count: 3 Project Using: Linear Regression Recent Periods Projection Controls: Show The calendar is set to current year. When I set to graph by day, it will…
-
Assigning a profile picture to a group
Good morning I am just curious if it is possible to assign a profile picture to a group. I haven't been able to figure out a way. We have created an internal group called "Support" for our company's employees to tag for assistance. We don't want our users to mistakenly tag domo support instead of our internal support, so…
-
Converting a beastmode text field into a number field
Hello, I am struggling to get the values my beastmode returns to display in the correct format. To summarize, I'm looking at blood draw times for donors. The data comes into Domo as phlebotomy start time, and phlebotomy end time (which are both date fields). So, I made the…
-
Beastmode Trouble - Getting a unique count of 2 based on 2 columns in 1 row
Hello, In this scenario, each donation id is a unique value and is 1 row. Each donation id has 2 columns: HGB and HGB2. If HGB is not null, that means the donation id received an HGB stick. If HGB2 is not null, that means the donation id received a second stick. If the fields are null, the donation id recieved 0 sticks. In…
-
trouble with str_to_date in beastmode
I'm having complications formating an existing date column to my liking with the beastmode function. The existing date column is currently formatted dd mmm yyyy hh:mm:ss AM or PM. This is in a table chart, the chart calendar is using the date column I just referenced, and is graphed by none. Right off the bat, it is weird…
