ST_Superman Domo Employee

One more bit of advice on this Case Statement. The case statement runs through the when statements until it finds one that is true and then it stops. You can simplify this statement a bit if you understand that: CASE WHEN DATEDIFF(`created_at`,`first_invoiced`) = 0 THEN 'Same Day' WHEN…

No worries @BV_Brandon. I was in your shoes a year ago, new to SQL. Take full advantage of the Dojo and don't be afraid to ask questions. The Domo support number was also a great resource while I was getting up to speed. 801.805.9505

no. You just missed a comma after `total_revenue_usd`

try flipping the values your are looking for to negatives DATEDIFF takes the first date minus the second date. If I created the account yesterday and bought today, 4/25/2018 - 4/26/2018 would give you -1; not 1. Either switch the sign, or change the order of the dates, or take an ABS() of the calculation

We had to set this up via a data flow. But we have accomplished a graph similar to this. We were looking at a rolling 6 month vs 6 month variance in our waterfall. Here are the steps we used to set up the graph: 1.) Create a table called current_6_months SELECT a.`Account Name` ,CASE WHEN `Salesforce Account ID` IS NULL…

I think this is kind of a work around for the upcoming "certified" card/dataset feature. We do not currently follow this practice, but will probably implement the certified feature when it is available

It sounds like you are looking for the Domo Excel plug in: https://knowledge.domo.com/Engage/Sharing_Content_in_Domo/Using_the_Domo_Excel_Plugin

I think you may need to calculate the number of orders per customer in a data flow using a windowed function (ETL or redshift). You can then use a beastmode to count the number of customers with more than one order. You will want to consider the timeframe here though. Once you build the number of orders per customer in the…

ETL機能を使用して、列の折りたたみまたは展開解除を行うこともできます。 ここにETLに関する知識記事があります。 You can also use the ETL function to Collapse or UnCollapse columns. Here is a knowledge article on the ETL. Edit Columns You'll want to look at the Collapse Column section and the Uncollapse Columns section. 「列の折りたたみ」セクションと「列を展開する」セクションを見てみましょう。

You may be able to make it work by graphing a beast mode rather than the value field: ifnull(`value field`,0) If that doesn't work than you will most likely need to include a calendar dimensions data set into your data flow so that you have a data point for each day.

Is that after selecting "allow text to wrap" also? Could you provide a screenshot to give us a sense of what you are trying to display?

So it looks like you want to first identify the latest date entry for each month and then show the metrics that were entered on that day. In that case, I'm not sure if this is possible in beast mode. My approach would be to add a field `max_date_for_month` in either mySQL or ETL. you could then filter with this beast mode:…

If I am understanding you, you have a table with different metrics for each manager. You want to know the max for each metric for each month by manager. I think this would work for that: MAX(`metric field`) OVER (PARTITION BY `Manager`,`Year`,`Month`) That should give you the max value for each manager/year/month…

This join should work. I know the preview when using ETL is not searching the entire data set, but I had assumed it was searching further than 100 rows of data. Do you get the same result when you save and run the entire data flow?

Thanks for sharing @DataJake Have we always been able to use windowed funtions with beastmodes or is that a recent addition? I don't remember that function being available in the past. At any rate, glad to hear that it is an option now!

There are pretty limited options when it comes to editing Domo reports. Domo seems to put more emphasis on viewing live data inside your instance. Have you considered using the Domo Embed feature to place cards on a customer facing page? I find that it is sometimes better to consider what is possible with Domo rather than…

I've run into a similar issue when dealing with max and min aggregates with date fields. Try changing the order a bit: Column 1 Rep Name Column 2 MIN(DateDiff(`Date of Sale`,Current Date)

Are you the owner of the card? Is the card owner still active in your instance? I have run into a case where I could not save a dataflow because the owner was no longer active.

In that case, since we are only looking at two values here couldn't you take the average of these two averages and then multiply by 2?

Don't give up until you contact Domo support. Those guys are awesome. Sorry I couldn't help

Agreed, but I haven't seen those features in production yet, and I don't know what their release schedule looks like. This can be done now.

If that works... I think I would recommend changing it to a rolling 30 day window. Something like this: CASE WHEN `Date Field` >= DATE_SUB(CURDATE(), INTERVAL 30 DAY) THEN AVG(CASE WHEN `Status` = 'Break' THEN `TotalDurationPerdayInMinutes` END) + AVG(CASE WHEN `Status` = 'Unscheduled Break' THEN…

Are you always wanting to look at the current month? I think that the date field is what is throwing off your summary number, because you want the summary number to only be the current month. try this: CASE WHEN YEAR(`Date Field`)=YEAR(CURDATE()) AND MONTH(`Date Field`) = MONTH(CURDATE()) THEN AVG(CASE WHEN `Status` =…

Have you tried using a stacked bar instead? I’ll have to think some more about the nested bar summary number, but I think that a stacked bar would work. 

Have you tried: AVG ( CASE WHEN `Status` IN('break','unscheduled break') THEN `TotalDurationPerdayInMinutes` END) 

I'm not sure this is something that can be accomplished within a beastmode. You could potentially create a summary number for the drill through page that would tell you how many for that day: COUNT(DISTINCT CASE WHEN COUNT(`2nd Item Number`)=1 THEN `Order Number` END) However, I don't think this beastmode would work when…

Color rules can only be applied based on the field name or the value of that field. They are not able to look at values from other fields. You could try displaying just the Variance. Created a beastmode `Current Amount`/`Target Amount` Then your graph would be a percentage of their target amount, the goal (or scale marker)…

You could create a beastmode to split out the current amount into an above target field and a below target field. then add those to your graph instead of the current amount field: Above Target case when `Current Amount`>=`Target Amount` then `Current Amount` end Below Target case when `Current Amount`<`Target Amount` then…

Can you provide an example along with the select statement you used in redshift?

I have done this in ETL for you: The first step is to Group your data - This will give you the following table - Then you will need to only select the "complete / not complete" part. As a side note, I am not very good at regex but I have written a regex that got the job done: ([^Not Completed|Completed]*)([Not…