Property_Ninja Contributor

ahhhhhh okay, try this to convert it in Beastmode. If it doesn't work in Beastmode you will have to cast it as a BIGINT in a dataflow transform. from_unixtime(yourDate/1000) -Brian

If this doesn't work, you should make sure your field is actually in UNIX time

Can you try it without formatting, so just from_unixtime(yourDate) I just tested and this worked for me. Thanks, Brian

So there are two ways to do this, the first way would be to add a subtotal to your table card. It would look something like the picture attached. The second way would be to create a new aggregate column. Something like ... select Campaign ,count(distinct id) as campaign_total from yourTable group by Campaign Then you would…

Hi, Instead of using the wrapper of DATE_FORMAT(), could you just use FROM_UNIXTIME(`yourDate`,'%Y-%m-%d')? Let me know if this helps. Thanks, Brian

Hi, I am not entirely sure what you are trying to accomplish here. Can you elaborate, maybe providing some examples with numbers? Thanks, Brian

Hi Stuart, I think in this situation you may want to create a new table and then join it to your pre-existing table in a dataflow. -- A transform called total_gift_quantity select sum(`Gift Quantity`) as total_quantity ,`Order ID` from your_table group by `Order ID` -- A new transform that joins total_gift_quantity to your…

Hello, There is no way to currently do this in Domo. What we did at Buildium, was create a review process for all new cards and beastmodes being created. We created a page only for developers and card creators, called "Development," where they could do all of their initial work. We then have them pass their cards to a page…

Hi John, You can actually do this one in beastmode. CONCAT(DATEDIFF('2018-10-31 14:31:26','2018-10-11 07:01:01'),' days, ',ROUND(TIME_TO_SEC(TIMEDIFF('2018-10-31 14:31:26','2018-10-11 07:01:01'))/3600,1),' hours') This formula will return the format of '20 days, 7.5 hours' Hope this helps, Brian

Hi Josh, It seems the way Domo designed this feature if you are actually certifying the card and not the underlying data. So the only way the certification will "break" is if the card is changed (ie: filters, columns, chart types, etc.). Domo has not implemented certifying dataflows or datasets yet. Hope this helps, Brian

Hello Mohan, I believe you can just do, AVG(NULLIF(`metric` ,0)). Let me know if this helps, Brian

Hi Nicola, If you choose Line+stacked bar chart go to Chart Properties --> General, you can then change the "Series on Left Scale" to whatever number you would like. So if two of your series are meant to be lines you would input 2. Let me know if this helps, Brian

sorry I had an extra parentheses. Try this ... CASE WHEN `Impact Rank` < `BDS Rank TW` THEN CONCAT('<span style="background-color: #00A86B">','OUTPERFORMING') WHEN Impact Rank` = `BDS Rank TW` THEN CONCAT('<span style="background-color: #00A86B">','PERFORMING') ELSE 'UNDERPERFORMING' END

Hello, Can you try something like this ... CASE( WHEN `Impact Rank` < `BDS Rank TW` THEN CONCAT('<span style="background-color: #00A86B">','OUTPERFORMING') WHEN Impact Rank` = `BDS Rank TW` THEN CONCAT('<span style="background-color: #00A86B">','PERFORMING') ELSE 'UNDERPERFORMING' END Let me know if this helps, Brian

Great thanks, and if you wanted to use the "Date Range" function to be more dynamic and allow users to change the week while viewing the card, you could write a beastmode like this ... STR_TO_DATE(CONCAT(`Actual Year`,' ',`Act Week`,' Sunday'),'%X %V %W') This will create a date based on the year and week, assuming your…

In this situation you would have to write a beastmode and filter on it. CASE WHEN `Actual Year` = YEAR(CURRENT_DATE) AND `Act Week` = WEEK(CURRENT_DATE,0) THEN 'True' ELSE 'False' END Then you would bring this into your filter and select 'True' Thanks, Brian

Hi SiGill1979, You should be able to accomplish this by choosing the "This Week" option in the "Date Range" section of your card. Please see the attachment. Hope this helps, Brian

Hello, Do you mind sharing what your beastmode looks like currently? Thanks, Brian

Hi Jerry, If you go to Chart Properties --> Value Scale (Y) and change "Max Gridlines" to 20, this should switch your axis to groups of 10 instead of 20. Thanks, Brian

Hello, The server name is your instance URL. https://[instance_name].domo.com (ie: https://abc.domo.com Thanks, Brian

There does not seem to be a way to complete these in ETL. Brian

Hello, I have a few questions to gain clarification about your ask. Are the fields called A and B or is that part of the string? In other words are you trying to join '(A) 47100-15000' = '(B) 47100-15000-A' OR '47100-15000' = '47100-15000-A' If it's the latter, you can do something like select a.A ,b.B from tablea a left…

Yes, that is correct

You will need to actually create a dim_date dataset in excel and upload it to Domo, then use that DataSet in your flow. I have attached an example file. Brian

Hello, You should be able to use substring_index function. SUBSTRING_INDEX(`description`, '------------------ Submitted from: ', -1) as url Basically this function looks at your field value (description), finds the string you want to locate, and then the negative 1 takes everything to the right. Hope this helps, Brian

Hi John, I am not sure you can actually get this result from a BeastMode. You will most likely have to do the transformation within a MySQL flow with something like ... timestampdiff(second, '2018-10-11 13:01:01', '2018-10-08 09:01:01') / (24 * 60 * 60) as day_dec_diff Hope this helps, Brian

Hi Prajwal, We have created a dim_date dataset that we can use in these situations with all dates from 1/1/2000 to 12/31/2030. When we want all dates even if data does not appear. Then, in your case we would do something like select a.`date` ,b.Item ,b.Location from dim_date a cross join your_table b where a.`date` <=…

This is why in one of my first posts I mentioned you may want to create an "All Corporate" department, which has the totals already calculated. You can then put together a table like the attached image using MAX(staffing_level) and MAX(no_employees) as your two fields. Hope this helps, Brian

The total row is just completing whichever calculation you give it on an aggregate level. So when you have sum(staffing_level) / count(distinct ifnull(empID,1)), your total row is doing 4+4+4+6+6+6+2 = 32 / 7 = 4.57.

Wait a second, Why are we trying to divide staffing level? Is it just supposed to be a sum of total employees needed? in this scenario, you can just do SUM(DISTINCT staffing_level) Thanks, Brian