Property_Ninja Contributor

So what I was thinking was you only bring the new records into Domo. Basically the first step would be to create a dataflow with the current dataset of 8 million records. Now you have two datasets, the original with 8 million and the new history dataset with 8 million. Tomorrow when the data reloads from workbench it will…

Hello Catherin, Without seeing the structure of your dataset it is hard to tell but my assumption is when you are filtering, you are removing all of the rows where your target value exists leaving you with 0. I just completed a similar test knowing my data is formatted something like this ... Name Metric Goal BD 100 90 CS…

I don't know of a way to solve for this using CSV. If you do expect your schema to change, I might upload the csv as a replacement file in Domo and do the append using a MySQL Domo dataFlow where you can control your columns. Brian **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by…

Hello, What does your source query look like in workbench? You may have to actually name the fields in the source query. For example ... select null as id ,null as timestamp ,make ,model ,year from fake_table Hope this helps, Brian **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by…

You can create a dummy label name with BeastMode. I just created a beast mode with the syntax of current_date(). Then I put that new field in the label name and it will allow you to change the format. The Label Name basically acts as a group by. So if you have a value that is constant on every row of your data then you can…

Hello, I was just able to set up a column using average. I noticed the numbers looked a little off at first compared to the raw file so I removed the field in "Label Name" This solved the issue and now I am matching exactly what the raw file shows for an average. Hope this helps, Brian **Please mark "Accept as Solution" if…

Hi Gustavo, I think you can use a single value card, you would just need to do some beastmode manipulation. For example ... concat( 'Operations' ,'<br>' ,'$' ,round(SUM(`Amount`)/1000,2) ,'K<br>' ,'$' ,round(sum(`Amount`)/100/1000,2) ,'K<br>' ,round(round(sum(`Amount`)/100/1000,2)/round(SUM(`Amount`)/1000,2)*100,3) ,'%' )…

Ahh okay. The hover is intended to show the specific values of the data point you are hovering over. By design, it does not show the hover values for data points that are not being hovered over. If you want to show those values for all data points I suggest using the "Data Label Settings." Thanks, Brian **Please mark…

Hello, What you would want to do is set the "Data Label Settings" --> "Text" to %_VALUE. This will show all of data labels and when you hover you will be able to see all data labels for the hovered item. Please see attached. Thanks, Brian **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by…

Hi mfaas, I am getting the same issue with HTML and break. When you hover it actually shows the line break but in the calendar you actually see the <br> text. My only thought is to pull the data into R using the DomoR package and split the string on "/" then use sapply to split the names into separate rows. The end results…

Unfortunately, you won't be able to get something like that unless you do your aggregations within a MySQL DataFlow or Magic ETL. Something like ... select team ,department ,new_members ,old_members ,net_members from team_file union all select 'Subtotal' as team ,department ,sum(new_members) as new_members…

You have to make sure your sort is set to "No aggregation"

Hello, Yes, drag your series into the "sorting" section and to get rid of the unwanted value, drag your series in the "filters" section and choose "Not In" and then select the blank value. Hope this helps Brian **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the…

Have you considered using a heat map table? This way you can control the colors of the cells if they are negative or positive, keep them as numbers, and be able to do a subtotal/grandtotal. This option wouldn't even require you to write a beastmode with HTML. Brian **Please mark "Accept as Solution" if this post solves…

Using the concat in a beastmode with html will always turn your numbers to text. Why do you need to show them as numbers? Brian

What is the end result you are trying to achieve. Could you please provide an example? Brian

So I am assuming by your comment that you want to assign a letter grade to the average? So you could have this in a table format by writing another beastmode with a case statement for the letter grades. Something like ... case when avg(days) < 3 then A when avg(days) < 5 then B etc ... END Then your table would have…

Ah got it. There is currently not a way to show a stacked gauge in Domo. You could use a stacked bar chart to achieve your desired result. Brian **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the post that helped you.

Do you have a snapshot of when it shows enabled again? I am able to disable a report and it shows as disabled on reports you scheduled. I am also able to delete reports without any problems. What permission set does your user have? This may be the issue, as an admin I am able to disable and delete any scheduled reports.…

Is that $10MM static? If so, you can put the goal of $10MM in the value (see attachment) and then put the transactions in the series and that should give you what you want. Hope this helps, Brian **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the post that…

You can create a beastmode in a card that is simply AVG(`ship date minus release date`) then use the Warehouse Name as either the series or the x axis. This will give you the average of a given warehouse depending on the date range you choose. Thanks, Brian **Please mark "Accept as Solution" if this post solves your…

alternatively if you are more comfortable with excel charts create the chart in excel, attach a screenshot, and I can see if it is possible to recreate in Domo

I don't believe you can share cards but if you can attach a csv with how the data looks that would probably help.

Correct this would go in the "Series" or "Category" section of the chart depending on how you wanted to view the data

If there is no data and dates are showing you should change CHART PROPERTIES --> CATEGORY SCALE (X) --> NEVER USE TIME SCALE to 'True' This should remove dates without values Brian

So your date range says last 3 weeks and it's graphed by none but you are seeing more than three weeks? Can you send a screenshot of your example?

Hi Jeremy, You should just be able to change the "Graph by" to "None" and it should show your actual dates. Thanks, Brian **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the post that helped you.

The parentheses were in the wrong place, in this particular case there is no need for parentheses. Yes you would just filter to greater than 0 in this case since your options are just 0 and 1. You can make your 1 and 0 anything you would like, if you would rather use 'true' and 'false' you could do that too, whichever…

Hello, You should be able to build a beastmode calculation for this then use the beastmode to filter the card. Case when sfuser1 is not null or sfuser2 is not null or sfuser3 is not null then 1 else 0 end Hope this helps! Brian **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking…

Yes, that will also work for your question. Just be weary that if you are looking at the last 13 months and trying to remove the current month, you wouldn't want to just use a month match as that would be get rid of your August data in both 2018 and 2017. Brian