-
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…
-
Sorting data by success percentage
I have a card where we are looking at blood draw procedures year to date, graphed by month. So, we have the date of the blood draw as a column, we have the count of distinct needle sticks, and then one column that categorizes each blood draw as successful or unsuccessful. We are not so much worried about the actual counts,…
-
Hover Text Settings: %_of_Category not working correctly
I have a card where it is the last 14 months, graphed by month, and the X axis is the date. The Y Axis is the count of deferral codes, and the series is deferral code descriptions. For the Data Label Settings, I have entered %_of_category, and it works just fine. The problem was that some of the series are so small that…
-
workbench logs filling C drive on workbench server
Good morning, Sometimes our log files take up a lot of disk space on our C drive on our Workbench server and it runs out of storage. Just wondering if anyone else experiences this and if they have any automation type methods or alternative methods to avoid this Thanks