Godiepi Coach

The Data Governance Dataset are great and Yes you can get to your answer by building a dataflow that joins the datasets... for example "Cards and Datasets" with "Dataflow Details" there are Cards link to a Dataset ID which it is present in the Dataflow Details as and Output Dataset and/or as an Input Dataset. so , I…

OK got it try this one then case when LENGTH(`Worksite`) = 0 then 'No Worksite Assigned' else `Worksite` end

Try this IFNULL(TRIM(`Worksite`),'No Worksite Assigned') There might be empty spaces that make the field be Not Null

199.68 - (-95.36) = 295.32 is mathematically correct if what you want is to subtract the absolute value of a column ... use ABS() depending of your case you can do this several different ways, depending of your need Beastmode 1 `field1` - ABS(`Field2`) Beastmode 2 ABS(`field1`) - ABS(`Field2`)

I went throught the same thing, deleting a Survey account in Domo that use to bring results. after deleting the account in Domo, previous downloaded records/datasets remained intact as well as the cards created. All I did was to make sure to set the update to Manual mode , that way I wouldn't get emails alerting me that…

This might be very silly but did you select "Table" when adding transformations in MySQL ? if you selected 'SQL' , it does not generate rows Your transformations should have an icon that looks like a table for the SQL to generate rows that you can then create an output dataset from , if they instead show with an icon with…

Oh ok , then you will be better using a flow to bring yesterday's sales into today. either as SuperMan suggested or doing a subquery like the screenshot below

Using SQL dataflows , since there is no ability to move up/down transformation to re order them. the way I do it is by creating new transformations above or below and copy/paste the code , then delete the original one if using magic ETL it is simple just by point the arrows of the flow, disconnecting and reconnecting

The easiest way for me was using illustrator , pretty much you can convert any image into an svg and/or build your own from scratch ... it is very cool, I have built few custom charts and the outcome is great. you'll need an adobe illustrator license of course. here an example

You could also use a Period Over Period that compares day over day if you dont want to build a dataflow to achieve the same result see screenshot

That is weird, I have a calculation like that sor sorting and it works fine. all I can think of is , make sure 1) your beastmode is the first in the sorting box and it is set to no aggregation and 2) take a look at what else you are sorting the table (second, third ect level of sorting) and 3) make sure your dates are all…

your x-axis field has some null values, if it is a beastmode then just do ifnull(("YourBeastmode"),0) if is not a beastmode then create one with ifnull(`yourfield`,0)

Hi , can you post the actual beastmode formula you are using as well as what type of chart it is and the fields you are including and time period selected. a screenshot would help , of course you can hide numbers and sensitive data before posting it.

That is not available. The best you can do is to prevent the drill down to the final data grid view completelty from the card options "Edit Drill Path" or "add a view" to the drill path that takes you to a card you can create

Hi, in the Dojo home page click on the upper right coner where it shows you Dojo Picture Once in your profile section, scroll down until you see the label 'My Latest Posts" and click on it

Yes you can make the name of the agent show only once in a table card by adding subtotal rows in the Chart properties and telling Domo to only "Show Group Name Once" See screenshot below

これはDomoでは利用できませんが、タイトルにページ名を追加することができます。 それが働くことができる唯一の方法です

I thought the same thing but it could be a full Dashboard embeded in a website using the Domo Everywhere capability 

こんにちは、私は私のお気に入りにこのカードがあります。カードのタイトルをクリックすると、カードのあるページが表示されます。

Hi, a beastmode calculation would be Sum(`Sold Price`) / Count(Distinct `SKU`) but, the problem with it would be at the moment of displaying the data , can be tricking since you will have to group by date ... the moment you add by SKU , the calculation will give you the same value as the sum of Sold Price. If I undestand…

Great, Let me know if you run into any issue. as far as what method is better between ETL and MySQL, it all comes down to which one you feel more comfortable with... Personally , I prefer MySQL while other team mates like ETL more.

Hi , based on the 3 fields you provided , the following code will get you the same 3 fields plus 2 more fields for Revenue running total and Reimbursables running total. both reset every year and start the sum in running total. here it is the MySql code that I normally use Select `Month` ,`Revenue` ,`Reimbursables`…

A work around would be doing the calculations in a dataflow, so that each calculation creates a new column in your final dataset that can be easily use as a filter.

In you example that is actually the whole point of drilling down to a filtered view. if your users wish to look at a specific month or any time period then they can use the date grain drop down next to the title of the card. now if what they want is to filter the card for an specific let say department, without getting rid…

I'm not sure of what type of vizualization you are trying to get but if it was a table card for example, the fixed function should not be a problem since you would be adding columns (Fixed fields) and the last would contain your beastmode that will automatically calculate and do the cuts depending on your columns…

You might want to try something like this instead CASE WHEN `Commission A ` > `New Base Salary Current` AND `Commission A` < `Second Base Salary Current` THEN (`First Achievement` + `Original Premium`) * (`Commission A - `New Base Salary Current`) WHEN `Commission A` > `Second Base Salary Current` AND `Commission A` <…

Hi, You might want to try this and make sure the name columns have unique values, otherwise the results will repeat as many times as there are possible combinations

If the desire of the user is to avoid duplicates , instead of a "select Distinct" , a "Where" case can be added to the second query .... tha'll do the job. this way : SELECT * FROM t1 LEFT JOIN t2 ON t1.id = t2.id UNION ALL SELECT * FROM t1 RIGHT JOIN t2 ON t1.id = t2.id WHERE t1.id IS NULL

Hi Mylee, Merry Christmas to you too. The Line + Bar chart is a good option but to make it work you should group Dollars with Dollars and Counts with Counts. Now you can have Total Cost in Dollars spend being more than 100 Thousand dollars while cost per install being 20 dollars per se. in order for the chart to display…

True , There are no pyramid charts but you can turn a single bar chart into a pyramid chart doing a calculation around the series percent of men vs women for example, you can say , case when genre = men then percent of men value - 1 case when genre = wome then percent of women value this will force the percent value for…