-
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
