BlueRooster Domo Employee

Damien, One question on your situation, are you looking to remove the fields with non-numeric data completely (ie, make them NULL) or are you wanting to just strip out the specific offending characters or perhaps omit the row entirely if it has bad data? If you'll let me know how you're wanting to handle the bad data, I'll…

Adam, We do something similar here with a YoY % change in the summary number. What we ended up doing was just disabling the date filter for the users by checking the "Hide Date on Card Details" option when in the Analyzer. We thought about using a "Selector" date field, but when users change the time frame, say to Last 2…

Here you go, this should do the trick. SELECT *, CASE WHEN `Invoice Sales` > 0 THEN `Invoice Sales` WHEN `Invoice Sales` < 0 AND `J_QUOTE_` > 0 THEN `J_QUOTE_` ELSE `WP Price` END AS 'Total Job' FROM sales_wp_quote_summarized_by_job Sincerely, ValiantSpur **Please mark "Accept as Solution" if this post solves your problem…

Ahh... I went back to my exports and indeed, when you move the table as it appears there is a second hiding behind it, identical to the first. Good catch! It does appear to be reproducible.

I did some testing at both the card and page level and haven't been able to reproduce this issue on any of my table cards in our environment. It may be worth reaching to Domo Support if you haven't already to see if they can take a look.

Unless there is a specific date field that identifies "Most Recent Activity Date" or something like that, you would need to have something like that created via Data Transform. It would need to do a periodic compare of "new" data against a non-updated source, identify records where there is a mismatch, and update an…

Thanks @DaniBoy. I'm working with Domo Support on it now. I'll update here when we figure out what's going on.

You'll need to add a check for divide by 0 possibility. Try this: CASE WHEN `PayTargetWeek` = 0 THEN 1 ELSE case when (sum(`PayTotal`) / `PayTargetWeek`) <= -.05 then 'Under Target' when (sum(`PayTotal`) / `PayTargetWeek`) >= -.049 and <= .05 then 'On Target' when (sum(`PayTotal`) / `PayTargetWeek`) >= .051 then 'Above…

We normally will do what you're asking using a SQL transform. If i've got my original output (call it Transform1) I'll do something like this: After connecting to Transform1 in the SQL transform, I'll create a new transform step and add my change. Something like SELECT *, CAST(`employeeid` as CHAR(8)) AS 'employeeid_text'…

You should be able to do something like this: cast( "2.23333e+16" as decimal(65,30)) Let me know if you have any issues. **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the post that helped you.

Depending on the method of your join, you can remove the second instance of a column beforehand. One example is if you're using the DataFusion, in the Preview window at the bottom, you can click the dropdown arrow next to the column name and say 'Ignore Column'. This will remove the duplicate from your final dataset. If…

Another thing to check is to see if the date field you're wanting to use is actually seen as a Date type by Domo. I know we've had instances where I've had to go back in a dataflow and use something like STR_TO_DATE(`date`, '%Y-%m-%d') to convert the "string" to a "date". You'll know it's being seen as a date field if it…

OK, in that case what you'll need to do is to create a data transform on your data before trying to show it in the card. You'll want to connect to dataset you're using, Group By the date field while selecting the amount field as your aggregate field. This way it will sum up the values on for each date ahead of time. Once…

What card type are you trying to do this for? If it's a table card, then one thing you can do is to set the Amount field to AVG(Amount), that should break it down by Day/Bank/Amount for each instance of day and bank. You can then add a Subtotal or Total Row to see the total average. If you can provide some more info around…

Here you go. You can find an example here: https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/Adding_Graphics%2C_Links%2C_and_Images_to_Table_Cards_Using_Beast_Mode It's under the 'Adding Images to a Table' section. Hope this helps, Colt **Please mark "Accept as Solution"…

Steve, What I would do is first break the datetime into days using: DATE_SUB(DATE_FORMAT(`DateColumn`, '%Y-%m-%d'), INTERVAL 0 DAY) (I use the date_sub to subtract 0 days as sometimes beastmode doesn't recognize date_format as a date. Using that beastmode as your x axis, should let you count same column on your series to…

So the first thing you'll need to check is the format of your data as that will determine the best approach to creating the card you want. If for instance your data looked like this: Then the way to set this up would be to select your chart type (Line in this case), set your X-Axis to Date, your Y-Axis to Amount and the…

Great question, we've got the exact same issue and was just about to post it myself!

Unfortunately I don't believe you can. We ran into this yesterday in our environment where some cards were deleted without the Admin realizing they were in use. We spoke with Domo support and they have logged an enhancement request to have a delete warning that might show what pages a card is on before being deleted. I…

Gantt Charts are now found under the Horizontal Bar section, see below: Let me know if you have any other questions, Colt **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the post that helped you.

Went back through my testing and found I was using Excel previously. When I switched to CSV, I'm seeing the same issues you are. It does indeed look like something may be off with Workbench and how it processes the dates. If you end up finding a solution from Domo Support, please let us know. Best of luck!

It might be the slashes '/' now that I look at it. Maybe swap '-' for '/' ?

If both your months and days have leading 0's you'll need to use this format: dd/MM/yyyy dd/MM/yyyy hh:mm:ss tt Try one of those and let me know if it's still failing. Sincerely, Colt

In testing your scenario, I actually ran into the same error. If I use the following in the Custom Date Format, it then works: M/d/yyyy hh:mm:ss tt I'm unsure why it's wanting to convert to a datetime, but this works when I used it for your given date format.

Setting the field type is actually done in the Schema section of the workbench: Once in the Schema section, just hit the Data Type dropdown and select DATE: If you need to alter your date format in the upload, you can choose the "Custom Date Format Transform" and use the following knowledge base…

If you're using a BeastMode formulat for this, the format would be something like this: DATE_FORMAT(`Date Field`, '%m/%Y') Or if you're doing a transform, you can just add this into your select statement like this: SELECT DATE_FORMAT(`Date Field`, '%m/%Y') AS 'New Date' FROM Table If you're field is a text field and you…

Is it possible that you have either an ID or Person with either a leading or trailing space or some other character? Is it 1 additional count for every unique ID or for only 1 person?

VRIndy, To get a unique count based on the ID and Person, I believe the following should work for you. Here is the BeastMode I used in testing: COUNT(DISTINCT CONCAT(`ID`,`Person`)) And here is a screenshot of the setup/results: This seems to capture what you're looking for. If not, please let me know how I can help…

Max, The only way I've seen to do something like what you're asking is to go to the Value Scale (Y) and then set a scale just outside of your ranking range. (Ex, if your rank was showing 1-5, maybe set Min to 6 and Max to 0) I'll be interested to see if anyone else has an idea on how to do this, otherwise, it may be a nice…

Evan, This sounds like a good case for something to submit to the idea center. Having additional options added for time periods or even customizable ones, would be very helpful to many people. Sincerely, Colt