MarkSnodgrass Coach

If you have the batch_last_run date as a column in your dataset that stamps when Domo last ran it, you could use that field. You could also use MAX(`datefield`) OVER() , but this only works if you have the "window functions in beast modes" feature turned on. Your CSM can turn it on for you, if it isn't. You also might…

I think your easiest option is to join your data with the calendar dataset in the Domo Dimensions calendar. If you haven't used this dataset, it is very useful and contains information about every date for future and past dates. I would filter the calendar dataset to where dayofweek = 1 so that you get one entry per week…

If I understand you correctly, you want to always show the data where the date is between 8 and 16 days ago and not have to update any logic as your dataset gets new data. You can do this by creating a beast mode and use the datediff function to determine if the data is within your range. It would look like this: CASE WHEN…

Try moving the SUM to the outside of your CASE statement instead of being inside. I would also double-check your data to make sure you are matching exactly, such as case-sensitivity and extra spaces.

Do you want to sum them separately and then add them together? Or do you want them as 3 separate calculations? If you want them as 3 separate calculations, then you would create 3 different beast modes, one for each. It may be easiest if you explain what it is you are trying to achieve. What are you trying to display?

Try this: SUM(CASE WHEN `Data` in ('Goal','Pipeline','in P&L') THEN `Total` ELSE 0 END) This should get the total you want.

I would not be surprised if @Ellibot has done something like this.

Try this: sum(case when `lgract` = '4001' then IFNULL(`crdamt`,0) end ) - sum(case when `lgract` = '4001' then `dbtamt`end )

You need to make 8 different beast modes, 1 for each line you have in your screenshot. Then drag those 8 beast modes into your table card.

@ageibe You can do this with the Group By tile in Magic ETL. In section #1 (select what columns identify the grouping) put your name and patient Id columns in that section. In section #2 enter the name you want to give the most recent date column In section #3 choose the encounter date column and then choose maximum for…

I would suggest doing this in Magic ETL. You can do this with just a few tiles, the formula tile and the join tile. In the formula tile, create a field called LastYearDate and use the date_sub function to subtract one year from the date field in your datasest. You can then use the join tile to join the data back to itself…

@damen I have run into issues where I have a lot of historical data and if the date range filter is set to graph by year, it does not go all the way back. Support once told me that it has to do with their calendar system behind the scenes. I was able to get around it by creating a beast mode that extracts the year from the…

@WorldWarHulk My bad. I missed that you are looking at 2 different dates to determine the quarter. It will involve a case statement, it can still be dynamic. This should work for you: CASE /*check to see if the end date is in the previous quarter of the same year */ WHEN QUARTER(`TC: Created Date`) - QUARTER(`TC: End…

@mroker LOL! I wish you could hit awesome 10 times! Glad it helped you and will hopefully help others.

You are going to want to utilize the Domo Dimensions Connector and the Calendar dataset to build out your months that are in between your start and end dates to create new rows. You would do this in Magic ETL. I've created a video that shows you how to do it. This is what your ETL would look like. Hope this helps.

Put the start date beast mode I gave you in the x-axis and put either the service field or the account field in the y-axis and then choose the aggregation type of count if it doesn't automatically do it for you. That would give you a line chart by start date.

Depending on how your data is structured, it seems like you could dress up a table card or pivot table card to get the columns you want.

The STR_TO_DATE function is going to be your friend in this case. Try this for your beast modes. Start STR_TO_DATE( CONCAT( REPLACE( REPLACE( REPLACE( REPLACE(`Start`,'th','') ,'st','') ,'nd','') ,'rd','') ,' ',YEAR(CURRENT_DATE()) ),'%b %d %Y') Stop STR_TO_DATE( CONCAT( REPLACE( REPLACE( REPLACE( REPLACE(`Stop`,'th','')…

Replace my dt field (which was my sample field from my dataset with your actual field name, which looks like it is TC Created Date. Your dates for your quarters follow the built-in logic for the quarter function, which is how it will correctly determine Q1, Q2, Q3, Q4. The Year function will extract the year from your TC…

What are you using for your date range filter? Do you have set to this month? Or do you have it set to All-time? If it is set to this month, then it will always show the current month regardless of any beast mode you create. I would probably set it to the last 2 months and then use a beast mode to do the toggling between…

There are various ways to dynamically do this. I made a video about using dates to control what is visible on a card. You can watch it here and see if it applies to your use case.

It would be best to use the LEFT and SUBSTRING functions to look for those characters since they are always in the same spot. I would write the statement like this: CASE WHEN LEFT(`shipmenttariffid`,2) = 'AP' AND SUBSTRING(`shipmentariffid`,5,2) = 'MA' THEN `shipmenttariffid` ELSE '#' END In my case statement, I am looking…

You can use the QUARTER function and the YEAR function eliminate all of your case statement. You could do this: CONCAT('Q',QUARTER(`dt`),' ',YEAR(`dt`))

@Jones01 I don't have a good dashboard to test this with, but you can try using the Date Ouput Format field in the General properties of this card and format it to month-year by using this format: MMM-yyyy Try that and see if it will respond that way you want it to. You'll likely have to do a week number format to get it…

Have you looked at the trellis chart option? That might work for you. Here are a couple resources. https://domohelp.domo.com/hc/en-us/articles/360043428713-Applying-DataSet-Columns-to-Your-Chart#6. https://youtu.be/hfIUQqeRVkM

A couple things you can try, depending on what your data looks like. Try the Grouped and Stacked Bar Chart. KB article here: https://domohelp.domo.com/hc/en-us/articles/360042924574 Another option is to change the chart property that is called "Series on Left Scale", which is found on most bar charts. Changing this option…

@jhester yes, the formula tile in magic ETL gives you beast mode functionality within the ETL. You can overwrite existing columns or create new columns. You can find the formula tile under the utility section on the left side. I have created a video that walks you through using the tile that you may want to watch.…

I would first try using the formula tile in Magic ETL and wrap the DATE() function around your field. Domo will convert them to the same format and make your field a date field which you can then use in Analyzer. DATE(`Start Date`)

Your differing values is because you likely have a client id in multiple locations. For example, if your data looks like this: Your distinct client id count is 3. However, when broken out by location, your counts look like this: Denver - 2 Boston - 1 Austin - 1 Adding those totals up equals 4 because client ID A is in two…

@Sam_Donabedian The list of functions in the beast mode editors are inconsistent in the different areas of Domo, even though you can use almost all of them in each area. I have posted in the Idea Exchange to get these consistent to make it clearer for users to know which functions are actually available.