PodiumMason Contributor

Hey Andrew, You could try Date_add, I'm assuming you're doing this in MySQL? SELECT DATE_ADD(`Ending`, Interval -1 Year) as `Last Year` FROM ACCOUNTING_PERIODS Is there a specific error that's being thrown? That might be useful to better understand what you're seeing. Hope this is helpful!

Hey SEC, I don't see a way to do this currently, even the hover text macros don't seem to affect the last value projection. This is a great idea though, if you'd like you can submit it to the Dojo Ideas Exchange to have the community vote on it, and later on hopefully get something added to the product. Sorry this…

Also, the knowledge base has a lot of YoY and QoQ and MoM examples: http://knowledge.domo.com?cid=beastmodecomparison The Dojo also has some good questions and answers from the past that could be helpful as well, feel free to search past questions. 

Hey EJRM! I went ahead and put together some beast modes that I hope will be helpful for you. My test data is at the month granularity, but the principles should work regardless of what date grain your data is at. Date Alignment: (This is to align the dates from last year and this year, so if you filter the graph to only…

Hi there! There is a sharepoint connector that exists. I would talk to Domo Support or your Account Executive to get potentially get access to it to leverage that functionality. Good luck!

Hey there meadow_ryan, One thing that you can do here is to do a Bar+Line chart instead of a bar chart. You can add the threshold value as the line value and the bar will be the column value. The x-axis will remain the same (category). Let me know if you need any help setting this up!

Hey JYang, I did some testing to see if I could find a way to get around the row by row functionality of beast mode, and I definitely see the issue with what you're trying, and I unfortunately wasn't able to find a way to do what you need in a beast mode. This may not be what you want to hear, but I would create a dataset…

Hi there! So if you're referring to the range on the graph when you say "bar chart", which I believe you are, the decimal places in the numbers on the range are not displayiing that you have a decimal place location in any province. The cardbuilder is simply taking the range of locations in the data and creating color…

Yes, exactly. That or you'd have to remove any columns that aren't alike. 

So in order to roll the rows up into a single row for each order, each column that you have must contain the same data. Any differences in any of the columns and the data will not combine into single rows. This is because those rows of data are basally different rows of data. Let me know if you have any additional…

Ryan, The aggregation should have taken care of it. (See Screenshots). It's possible if the Order Number column has some hidden whitespace in one order number row but not the other, that could be causing the aggregation to not work. Also if you have any other columns on the table (Such as two different product names) the…

Hey Ryan! The cardbuilder is going to be smart enough to combine rows with the same order number when you to a SUM aggregation on the value column. You shouldn't have to do anything else in the graph to get the rows rolled up in your visualzation, whether it's a table card or a bar graph. To test this, create a table card…

Hey Curtis, How large is your QB file? I've seen that large files can cause long runtimes. Another avenue you could pursue is to talk to Domo support or your Consulting team (if applicable), they can better help you troubleshoot the issues you're having. Best of luck!

Hey there eizquierdo, I don't know of any workarounds that exist for this particular requirement for single value cards. One thing that would be helpful would be to submit this to the ideas exchange so the community can vote on it, that way the Domo product team will know this would be a helpful feature to add down the…

I don't currently know of a way to adjust dependencies so that an ETL/Dataflow only runs after all the input datasets are updated. It would be useful to suggest this in the ideas exchange so that it can be added to the product.

Dang. I'm thinking that the number of categories on the graph and the length of the categories is precluding showing the entire label. One thing that worked with long labels as I tested was to filter the graph down to just a few categories at a time, this would allow the graph to rotate the labels and display them in their…

Hi there joshneck, In the chart properties under the "Category Scale (X)" property, there should be an option titled "Max Rotated Label Length". If you adjust this to a large number (Greater than the character length of the longest category) it should display the full category label. I can't promise that this will be…

Hi there SGraham, In ETL/Dataflow dependencies, the setting is such that if any of the dependent datasets update successfully, any ETL flow that is tied to those datasets will update. In your case, because 2 of the 5 dependent datasets did successfully update, the ETL ran and updated. Let me know if you have any additional…

Hi Brandon! Welcome to Domo! So since you have multiple category series, you'll have to do a little wrangling to get a card to do what you'd like, but it is do-able. You can decide if it's aesthetically what you want. Example: So first you'll want your date on the x-axis. Make sure you're viewing it by month. You can leave…

Hi There! So what you're asking for isn't exactly possible. With a stacked bar and line, the line must also be a numerical value, so displaying the segment as a line wouldn't make much sense. You have a couple options. One thing you can do is put segment on the x-axis of the graph and use category as the series with the…

Hey Curtis! Are you querying a database in workbench to get data into Domo? If this is the case, you could do a "where" statement in your query that pulls dates between whatever beginning date you want and the current date. That way the data would always be pulled as of the current date the job is run. so it might look…

Amy, Check out the Twitter Ads connector in the datacenter, I know that you'll be able to find some of those specific metrics coming out of that connector. There are several different levels of data that can be accessed, including account, campaign and tweet level (for promoted tweets). There are more specifics than I can…

Hi Amy! Just curious as to what metrics you're looking for from Twitter and Facebook that you aren't finding? Thanks!

Hey D-Rab! There are a couple potential solutions here. One of them rests within the "Value Scale (Y)" chart properties (I'm using the single bar chart as an example). There is a check box titled "Include Zero". Make sure this is checked on your visual. However if there is no data at all (Column is null) another solution…

Sorry, User01683 I'm not sure exactly what you're referring to. You mentioned that the "Select All" isn't selecting all the columns, but then you mention that you have over 5000 rows and it only selects 261 when you select the all option. Few questions: - Are you talking about the "All" functionality in the page level…

Hey Matthew! Since you posted this in the Workbench forum, I'll talk to this from a workbench perspective first. Workbench doesn't currently support Upsert. I know this is something in the pipeline. One thing you can do in the meantime is use a dataflow to create a recursive dataset. MySQL supports the "Replace Into"…

Hi Nick! There is a transform options in Magic that allow you to do case statement functionalities. Under the "Edit Data" transform grouping you have the "Value Mapper" transform. This transform allows you to (much like a case statement) look at a specific column for a value, empty or null string, or text string, then…

Hi there! You can do this using two separate beast modes. For the date, you can use this: DATE_FORMAT(`Date`,'%Y-%m-%d') For the time you have a couple options: This will give you the 12 hour time with seconds, followed by AM or PM: DATE_FORMAT(`Date`,'%r') This one will just give you the 12 hour time without seconds with…

Hi Arav, Domo does have a Google Cloud connector that can be used to integrate DFP into Domo. This Google support article has additional detail of the process of creating a repository on the Cloud side to store DFP extracts. https://support.google.com/dfp_premium/answer/1733127?hl=en The way that I've seen this process get…

Hi there! It looks like the Facebook quickstart datasets that are powering the cards behind the scenes default to bringing in between 30-60 rolling days worth of data. So generally speaking you'd only be able to see data as far back as the dataset is pulling each time it refreshes. In order to change the range of data you…