MarkSnodgrass Coach

It looks like you have a parentheses issue again. I see two open parantheses after your first sum. There should only be one there. You also have one too many, just before the comma. Try removing those and see if it works. Sometimes I will move things to separate lines to make it easier to read and make sure I have the…

That formula won't validate as constructed. I would re-write it like this, assuming you have a due date field: SUM(case when `type` IS NULL and DATEDIFF(`duedate`,CURRENT_DATE()) <=14 then 1 else 0 end) This assumes type is actually null and not an empty string. I am using sum instead of count because we need to only count…

Yes, that will work in a card beast mode. Just keep a close eye on the parentheses. You had one too many in what you just sent.

In your screenshot, it looks as though you are missing an open parentheses ( at the beginning as you should have two open parentheses together. You currently have one open parentheses and two closed ones.

Hmm.... I just tried doing the same thing in the formula ETL tile and it worked. Here is what mine looks like using some sample data: POWER((`DaysPast` / `Lag`),.2)-1 Do your rev Yr 5 and rev Yr 1 fields have nulls? It won't be able calculate unless they both have values. Is your formula validating in the editor, but then…

@NathanDorsch I haven't seen a connector where I can choose which columns I want to import. However, I often build an ETL on top of my source dataset, so that I can select which columns I want and rename them as necessary using the select columns tile in Magic ETL. This also gives me the flexibility to swap out the source…

It looks as though you are wanting to count when something is done and due in the same month. In which case, I would do this: CASE WHEN Month(duedate) = Month(donedate) AND YEAR(duedate) = YEAR(donedate) THEN 1 ELSE 0 END You can then sum this beast mode to get the count.

@NathanDorsch Yep! That did it! Thanks!

I would change your beast mode to be like this: CASE WHEN DATE_SUB(`dt`, INTERVAL (DAYOFMONTH(`dt`) - 1) DAY) = DATE_SUB(CURRENT_DATE(), INTERVAL (DAYOFMONTH(CURRENT_DATE()) - 1) DAY) THEN 'Current Month' WHEN DATE_SUB(`dt`, INTERVAL (DAYOFMONTH(`dt`) - 1) DAY) = DATE_SUB(DATE_SUB(CURRENT_DATE(), INTERVAL…

If you do have a date field, you can normalize a couple different ways to get them to be grouped by month and year. The easiest is probably using the Last_Day() function, like this (replacing dt with your fieldname that has the date: LAST_DAY(`dt`) This will create a date field for you and have all the transactions in a…

The connector does seem to be geared towards past meeting information. If you can find the right API call in Zoom's API documentation here: https://marketplace.zoom.us/docs/api-reference/zoom-api/ You could look at bringing it by building your own API connector, or try using the JSON No-Code Connector. You can also send…

I would try and sort on a single date field. If you don't already have it, and you just have the individual month and year columns, you can construct a date field like this in a formula tile. DATE(CONCAT(`Month`,'/1/',`Year`)) Add this formula tile just before your rank and window tile and then sort on this date field…

@Fadem I have not had trouble saving my drill paths and the columns in my table card staying the way I designed them. Are you clicking on the wrench of the main card and choosing Edit Drill Path and then clicking Edit View and then designing your card (I assume a table card) the way you like and then choose Save and Close?…

Isaiah, I have not heard of a limitation of the number of input datasets (or seen it in the documentation), but you could probably ask your CSM to research that for you to get a firm answer. From a management standpoint, I would suggest breaking your ETLs into smaller ETLs, so it is easier to troubleshoot if something goes…

If I am understanding you correctly, I think you have two options: In your main card, use the beast mode that returns your desired date. In Analyzer, set the Date Range filter to use this date field and then set it to graph by week. This will display the week of year for you in the card. When you drill, it will still be…

@user027926 you can't use a lag function in a formula tile within Magic ETL. That is why I suggested doing a lag first with the rank & window tile to put the previous value next to your current value as a new column. Once you have the previous value in the same row as your current value, you could do the formula work that…

You can join the Domo Governance Beast Modes dataset with the Domo Governance Datasets dataset to get the dataset owner of the beast mode. They also have a Domo Governance Cards dataset that you can join to the Domo Governance Beast Modes dataset to get the card owner of a dataset.

You could utilize the Lag function in the rank & window tile get the previous row's flag next to the current row's flag as another column. Then use the formula tile to overwrite the unique id if the previous and current flag are the same. Finally, you could use the rank & window again and use the row number function and…

Unfortunately, color rules require a fixed number and can't be based off of another value. You could use a table card and then use HTML to color the text by creating a beast mode to look at another value, but it is certainly not the same visual as a line+bar chart.

@NathanDorsch glad I was able to help. If you can accept any answers that helped you, that will help others in the community.

@matty123Kn glad I was able to help. If you can accept any answers that helped you, that will help others in the community.

@NathanDorsch with your concatenation: Date(concat( case when Month(`Date`) > 1 then Year(`Date`) when Month(`Date`) = 1 then Year(Date) - 1 end, '1', case when Month(`Date`) > 1 then Month(`Date`) - 1 when Month(`Date`) = 1 then 12 end )) A date of today would return 202213. The date() function is going to have a hard…

You can use the DATE_SUB function to subtract different intervals at a time, such as month. DATE_SUB Subtracts date or datetime values (as intervals) to date values in a date column. DATE_SUB('DateCol', interval 1 month) In this example, if the value for DateCol was 2/27/2022, it would subtract 1 month and result in…

If you are using the Heatmap Table card under the Tables and Textboxes, you can set the heatmap to be on an individual column basis. Under Chart Properties, go to Scale and select Independent Column Ranges.

On the cards where you want to show only data from prior months you could create a beast mode that you would put in your filters. It might look like this: CASE WHEN `dt` < DATE_SUB(CURRENT_DATE(), INTERVAL (DAYOFMONTH(CURRENT_DATE()) - 1) DAY) THEN 'Prior' ELSE 'Current' END Replace dt with your fieldname that has the…

Domo calls combo charts Line + Bar charts. In a standard implementation, the value put in the y-axis becomes the line and then the series becomes the bar. You can have multiple lines by entering a value in the General chart properties "series on left scale". It will then use the y-axis and the first item in the series if…

Putting something in the series will allow you to drill down more specifically. In your case, it sounds like you would want the hours in there. It will cause a lot of color variation, so it may not result in the look you are going for. Hope this helps.

@Canioagain sorry I wasn't clear. You are applying PDP based on values in column, which will hide that entire row. I was suggesting creating a column called "ShowRevenue", for example and it would contain values Yes and No. In your ETL, duplicate the data, but in one set of the duplicate zero out the revenue column and…

I would suggest using Magic ETL to clean your data. You can use the Remove Duplicates tile to remove duplicates very easily. Here's the KB article: https://domohelp.domo.com/hc/en-us/articles/360044876614-New-Magic-ETL-Tiles-Filter#4. within a beast mode, you do have options like COUNT(DISTINCT fieldname) that may help…

@NathanDorsch in the Limit Rows box, set that to 1.