PodiumMason Contributor

Hey @user05739! This is a good question that goes back to how beast mode and the map charts work. Your beast mode looks correct on the graph type chart because it's utilizing the entire set of data, so while the numerator of the beastmode is using a subset of data, the denominator is counting the entire set. When you use…

Hey @user07803, At a glance, the issue with your beast mode is the initial CASE statement. CASE WHEN `Actual Revenue` = 0 THEN 0 Beast mode gets pretty disagreeable when you try to mix row level calcs (non aggregated) with set level calcs (aggregated). You could add the first beast mode as a component of each of the other…

Hey @user00530, You could do a beast mode: SUM(Case when `Group Name` = 'Income' then `Amount` else 0 END) - SUM(Case when `Group Name` = 'Expense' then `Amount` else 0 END) Best of luck!

@user03841, If you want to see data only based on dates, have you tried using dates as filters on the card vs. creating a beast mode? You could put multiple date filters on the card (and potentially use them as quick filters, disclaimer, I haven't tried this) and without using a beast mode at all potentially get the data…

Hi @user04536, You'll want to use the "Save As" feature instead of the "Copy" feature. Copying is just displaying the same card in two places. Save As actually duplicates the card and does not carry changes from one to another. Let me know if this works for you!

Hey @user06410, You recently joined the Domo partner program to be a Domo partner? I would contact domo support at https://support.domo.com. They can provide you additional info with regard to licensing and get you in touch with the correct parties. Best of luck!

Hey @user03841, You could do this with a beast mode (or multiple beast modes) and either hard code the date ranges you want to look at, or use the card date range to adjust the beast mode dynamically. (since you're using two different date columns, that probably wouldn't work thinking about it) In your example you could do…

Hey @Lara, Based on your description, this should be fairly easy to do especially if they are already living in their own columns. I would create a separate beast mode for each evolution you want to view and then put them all on a stacked or grouped bar chart. You can add all the columns as separate series on the graph and…

Hey @user02674, Not sure why this is occurring, I just attempted to replicate the problem and I wasn't able to. (My beast mode worked fine without any aggregation as a quick filter). Just curious is your column `CO_LOC_REF_I` numeric or text? I wonder if it has something to do with going from numeric to text. (if that is…

Hey @Randyb, I don't know that a solution exists in Magic ETL, but I have found a solution that seems to work fairly well in Beast Mode: FLOOR((DAYOFMONTH(`Date`) - 1) / 7) + 1 I know it's not the solution you asked for, but hopefully it will provide a workaround. Best of luck!

Hey @WHM, MySQL doesn't have a native row_number() function (I know that isn't what you're asking for) and to my knowledge it doesn't store row numbers in the metadata at all. (Could be wrong about this one). So the short answer is no, row numbers cannot be referenced at the beast mode level natively. I think the easiest…

Hey Isaiah, This has been a drawback to the Twitter connector for as long as the connector has been in operation. The problem, however, isn't a connector problem, but a Twitter problem. Twitter locks organic tweet metrics behind a paywall (Gnip), and they have their own separate proprietary API. To my knowledge, outside of…

Hey @debbie_a, In beast mode you can use the STR_TO_DATE() function to convert your string to date. However it sounds like you might have some bad data in your column if the CAST function is erroring out, you may want to check the distinct values of the date column for any odd characters or strange values. See…

Hi @user00667, Usually when this error comes up it's due to one of the calculations on the graph having a divide by zero error. Is it possible that with data refresh you might be seeing an instance where that could be happening? One thing to do would be to look at the data inside the analyzer/card builder so you can seee…

Hey @user09698, The answer to this question kinda depends on how your data is structured. Is your dataset wide? Structured something like Date, TotalRevenue, TotalCost? Or is it a tall structure something like this: Date, Measure Type, Value. If the data is wide, you might want to think about using Magic ETL to pivot your…

Hey Adam @user02674, From the looks of the nested beast mode, as you assessed, it doesn't like you putting aggregate functions into what it's seeing as a row level function. This is probably why the code isn't functional. Have you considered using ETL or Dataflow to hard code the values in these segments into their own…

Hey @JasonAltenburg, I tried recreating your issue in my Domo instance but I was unable to see the row number offset as specified. I wonder if you try a different browser if you'd have different results? You might want to reach out to Domo Support on buzz @DomoSupport or support@domo.com best of luck!

Hey @user02428, Out of the box Domo will allow you to combine metrics with different types on the same graph. YFrom your example, you could put both total impressions and average CTR metrics on a grouped bar and line or multi line graph and Domo will create a secondary axis based on the datatypes of the different metrics.…

@user00667, To my knowledge this is not possible yet with the current Domo feature set. I know that this idea has been presented and upvoted many times, so hopefully we'll see this in the future. For now "complex and hard to read" is unfortunately what these will look like. Best of luck!

Hey @AttuAk, One of the best solutions for automatic uploads of .CSV or Excel files is the Domo Workbench tool. It can be set to grab the file at a cadence so you have an updating dataset in Domo. It can be downloaded in the Admin menu in Domo under "Tool Downloads". Here is a place to start in the Help Center on getting…

@Gerry, Nice write up, it sounds like you're doing it right. One interesting way to take this a step further would be to examine social ROI, using google analytics data to track social referrals to websites and then revenue associated with those visits. When I was a Domo employee I helped put together a few apps for the…

@D-Rab At this point in time, labels are the workaround, but at Domopalooza, a feature which will allow column header name changes at the dataset level was announced. There wasn't an ETA on the feature, but this would be a potential workaround in the hopefully near future. Another possible workaround would be to use mysql…

Hey @user00426, I quickly glanced at the API documentation here: https://developers.facebook.com/docs/marketing-api/reference/ads-insights/ It looks like relevance score can be pulled at the Ad Level only, and will only show a value after your ad receives more than 500 impressions. Are you having trouble with finding the…

@jlazerus Great! Happy to help.

Hey @jlazerus, One way that might be easy would be to power up the calendar.csv dataset (A dataset containing date information) from the Domo Dimensions connector. You can then left join from the calendar to your dataset on the date column, this will fill in the gaps in your data with dates and show the values where they…

@mindbender Great! Happy to help.

Hey @mindbender What you'll want to do is create a filter beast mode for the card that limits the dates to not only greater than 13 months ago (what you've written) but also less than the last day of last month. Something like this, then filter it to 1. Case when `Start Date` <= LAST_DAY(DATE_ADD(`Start Date`, Interval -1…

@IVG looks good, glad you got a solution that worked for your dataset! My sample dataset that I was using was definitely simpler and easier to work with it seems like. 

@IVG based on what you told me about your data, the filter was to make sure that when we aligned the dates that you wouldn't have any that are after the current moment in time. For example if it was four o'clock you wouldn't see any yesterday results from five or six o'clock. (that don't have today's results yet).

@IVG So you'll want to create a dataflow in MySQL and do the following transform. When you have created the transform, output it with a Select * from transform_1 as a new dataset (name it whatever you like). Select Case when date(`datetime`) = Current_date() then `datetime` else Date_add(`Datetime`, Interval 1 Day) END as…