BlueRooster Domo Employee

You would need to do this at the ETL level. With the BeastMode Case statement, each line goes from the top down until it find a bucket to fall into. Once it's in a bucket, it doesn't go down any further. So since you have all of your months already broken up nothing is reaching your total line. Using an ETL before you get…

Looking over the new features it looks like the new map features didn't make it in with some of the others I've confirmed are there (ie, custom alert messages, DomoStats). I was hoping to play around with the Custom Chart type but when following the documentation I realized I don't have any options related to Custom…

If you make sure you're highlighting the DataSet Jobs itself: And then go to the Tools -> Export option: You're then presented with a checklist allowing you to select all of your jobs if you want, and export those. Hope this helps, ValiantSpur **Please mark "Accept as Solution" if this post solves your problem **Say…

As long as the data exists for the series, they should show up in your series list regardless of whether your Y values are 0 or NULL. If you're wanting to have it show the data labels even when 0 or NULL you can use the following Data Label settings: Let me know if this isn't what you're looking for. Sincerely, ValiantSpur…

Are you summarizing the number first and then multiplying by 1000? Can you show a screenshot of how you have the calculator tool setup? Sincerely, ValiantSpur

The visualizations are controlled by which columns from your Excel file you decide to drop into the X and Y axis. This allows you to setup whichever axis combination you want. Let me know if you have any other questions. Sincerely, ValiantSpur **Please mark "Accept as Solution" if this post solves your problem **Say…

You could try the Replace function in a beastmode. If you're replacing the semicolon with a line break it would look something like this: REPLACE(`String`,';','<br>') Give that a shot and let me know if you need anything else. Sincerely, ValiantSpur **Please mark "Accept as Solution" if this post solves your problem **Say…

Yes, I was actually able to use your test dataset, create a beastmode with the corr function and then it worked fine. It sounds like it may be worth reaching out to Domo Support at this point. There may be a quirk going on with your instance.

You may need to calculate the seconds column via a dataflow before attempting to use the Sec_To_TIME fucntion. Also, what's the exact error message you're getting and could you provide an example of your code?

You just need to use the SEC_TO_TIME() function for your seconds column. Check out this article: https://www.w3resource.com/mysql/date-and-time-functions/mysql-sec_to_time-function.php Let me know if you have any questions, ValiantSpur **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by…

I don't believe so, we aren't running any beta versions in our production environment and I was able to get it to work. Perhaps make sure both fields are integers?

Second option is to use the Corr function (which does a Pearson Correlation for you) corr(`Duration`,`Revenue`) You can use that as a beastmode but it doesn't let you put it in the summary number.

You can do it in a data transform, but couldn't in a beastmode as far as my testing. You'll need to create a data transform that calculates the Pearson R using the following logic: (Avg(`Revenue` * `Duration`) – (Avg(`Revenue`) * Avg(`Duration`))) / (STDDEV_POP(`Revenue`) * STDDEV_POP(`Duration`)) You have to break it into…

You're very welcome. Glad I could help

SUM(CASE WHEN `Date Type` = 'Acceptance' THEN 1 END) / SUM(CASE WHEN `Date Type` = 'Submission' THEN 1 END) What are you results with the above? 

Try this: SUM(CASE WHEN `Date Type` = 'Submission' AND `AcceptedDate` IS NOT NULL THEN 1 END) / SUM(CASE WHEN `Date Type` = 'Submission' THEN 1 END)

Is it still 0 if you multiply by 100? COUNT(CASE WHEN `Date Type` = 'Accepted' THEN `AcceptedDate` END) / COUNT(CASE WHEN `Date Type` = 'Submission' THEN `SubmissionDate` END) * 100

Put this in the SQL SELECT * FROM transform_data_1 And then give it an appropriate name. This will be the new dataset for your card

Replace table with consumer_dealer_appraisaldata

You would need to do a SQL transform in the Data Center. It should be next to the ETL option

So we encountered a similar issue with multiple dates as well. What we desided to do was create a 'Unified Date' column as your date range. Basically allowing you to set a date range and all dates (submissions and acceptance in your case) would be returned. You start with a data transform, the basic code goes like this:…

Using the table you provided, you'll first want to select the Line + Grouped Bar chart type. Then drag the columns into the chart like so: The first measure (green value) will be your line, while the other columns are separate bars. Hope this helps, ValiantSpur **Please mark "Accept as Solution" if this post solves your…

You can do this with the Dataset API here: https://developer.domo.com/docs/dataset/import-and-export-data#Import%20Data Hopefully that's what you're looking for. Sincerely, ValiantSpur **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the post that helped you.

Is it possible for you to provide a small example of the data? I'm unclear as to how many columns are actually in play for this issue.

Could you provide a generic sample of the data you're using? That would help me to know better what to tell you.

The only way that comes to mind initially would be to create Sumo pivot table. Have the date field as your columns, the locations as your rows and the event populating the cells. Anything else with the Table card would be static to my knoweldge and wouldn't be able to change with time. Sincerely, ValiantSpur

I like the possibilties with this, but having seen visual level filters at Domopalooza I'm a little hesitant to go down this road just yet. Might be more applicable in some other use cases from what I'm thinking though.

When setting up the initial date range on the Period-Over-Period card you could do "Last 12 Months" and compare it to 12 months ago. See below: Is that what you're looking for? Sincerely, ValiantSpur **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the post that…

There's currently not a way to use custom colors with RGB or HEX values. Feel free to throw your support behind this in the ideas exchange here: https://dojo.domo.com/t5/Ideas-Exchange/Custom-Color/idi-p/6325 Sincerely, ValiantSpur **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by…

Unfortunately there's not a way to change the legend labels on the Period-over-Period chart type. As a work around, I ended up manually doing the calculations with BeastModes and using a different chart type (ie, multiple line) to accomplish that. Obviously not ideal, but it'll get the job done. Hope that helps,…