-
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…
