nmizzell Contributor

case when `Credit Type 2` is null then 'none' else `Credit Type 2` end enter this formula into a formula tile in magic etl. this can also be done in a beastmode.

You can also do this in a pivot table if magic etl is not an option.

Hey Agolla, I think that a beastmode is not the best suited tool for this task. Try the following in magic ETL: Group by Case number, count case status that equal "Yes" and count case status that equal "No" 2. Then, take the minimum of both these. This will give you the total number of reversals, assuming there are an even…

split asset column by delimiter comma. use 10 splits to be safe, since there is not an option to use as many splits as needed. unpivot the columns you created with the splits. This will turn the columns into rows, repeating the non-pivoted columns "Plant" and "Shutdown Reason" for each new row.

hey strostle, POP is very simple in domo using the case statement, date sub, and current_date() functions: sum(case when month(date) = month(date_sub(current_date(), interval 1 month)) then 'revenue' end) / sum(case when month(date) = month(current_date()) then 'revenue' end)

Specifically, having the ability to set the default value of a variable to a dynamic value such as current_date(), instead of having to choose one static date.

This feature would be very helpful

Hey HJ, I have encountered this issue before and solved it in the following way: Share content with groups instead of individual users. Sharing dashboards with the groups will share all the component cards as well. Add users to the groups to assign access to content. You can check which content each group has access to…

@Vinay_Jain_ this method works if you only have a few dashbaords. If you have thousands of dashboards, it becomes cost-prohibitive to use the drag method to sort alphabetically. I would still like to see this alphabetical dashboard sort method implemented.

Sbhatia, Domo provides a very good article on this topic: Sample Beast Mode Calculations: Period-over-Period Transforms (domo.com) Your formula will have to take the form of the following:

You can use a nested case statement: SUM (CASE WHEN DATE(`BatchTimestamp`) = DATE('2023-11-22') AND YEAR(`Month`)=2024 AND `FinancialCategoryName` LIKE '%CAPEX%' AND `Portfolio 2024_p`='Rejected' THEN (case when `PlannedCost` >=0 then `Planned Cost` * -1 else `Planned Cost` end ) ELSE 0 END)

Hey Atleh, You will need to use the 'Append Rows' magic etl tile to accomplish this. Before appending the rows of the two tables together, make sure that the column names are consistent. For example, rename the 'Time spent (sec)' column on table 1 to 'Spend'. This will tell domo to align the new combined table on the…

Hi Damen, To accomplish this task, you only need two columns: Bond Category Amount Using Magic ETL, perform the following steps: keep only the amount, name, taxable, and tax-exempt columns create a helper column that reads the name of each bond, and classifies it as 'bonds', 'MBS', 'Freddie', or 'other'. We will break out…

Hey PJG, Here is what you will need to do: this simple 2 step proccess will transform the input dataset provided into the output dataset. I truncated the column names to make it easier for me to put this together. Here are the truncated names that I used in my dataset:

sum(`Total Weight`) / sum(`Total Weight`) over ()

Grant's solution will work if you want to count the total full time. If you want a percentage, the following extension of Grant's formula will work: COUNT( CASE WHEN `Full-Time/Part-Time` = 'Full-Time' THEN 1 END)/ count(`Full-Time/Part-Time`)

I understand now. The data will need to be pivoted in magic ETL to achieve the desired effect. To confirm, do you want to see a table in the following format as your output?

Hey Abe, What is the meaning of the numbers in the Non-G360 column? Are those numbers an identifier? If those numbers are an ID, do you want to see the sum of revenue for each ID? Thanks,

Hey PJG, There is an issue with the inner join "Join Data 1" that is grayed out, preventing the ETL from running. Could you share the settings of this Join so that the error can be pinpointed?

Once your conditional column has been created, you can filter to only include the 'Yes' values, which will have only the most recent response for that category

Hey TMonty, You will need to create a conditional column: case when `timestamp` = max(`timestamp`) over() then 'Yes' else 'No' end However, this will require that you have a timestamp column. If you do not have a timestamp column, you can make one by appending the date and time columns and converting to timestamp format.

Yuhel, Great question. This article explains how to downfill values, to get the most recent value even if there is no data. How To Downfill Null Values In SQL | Towards Data Science You will need to make a slight modification to this logic, where instead of getting the most recent value in the series, you get the…

Hey PJG, Could you provide an example input and desired output? Thanks,

Hey Sean, Its best practice not to pivot on the dataset itself. Typically, we want to store the data in tabular, non-pivoted format so that we can easily feed it into the visuals such as the pivot table, where we can drop the months field of the dataset into the columns field of the pivot table to achieve the desired…

Dataset Backup - I haven't found a need to use this. Domo has version history where you can restore previous versions of datasets / etls. I guess you could get some use out of dataset backup if the version history isn't enough. PDP Automation - Very useful if you have PDP on your datasets. PDP can be used to create…

Could you provide an example in excel of what you want the final table to look like, and an example also in excel of your dataset?

Hey Deona, Break this calculation down into steps: Creation of ticket date First response date Days between creation and first response date Weekend days between creation and first response date Weekday days between creation and first response date. The column is given given datediff(`creation_date`,`first_response_date`)…

@damen, This can be accomplished with the rank and filter tiles. Simply rank the dataset by date descending and keep only rank #1 in your filter tile.

The color rules may not recognize the aggregated formulas in the pivot table. For example, if each point in your dataset ranks A or B, then the color rules will only show these options, even if the aggregation formula in the pivot table ranks some groups of data points as C and D, in addition to some groups that are ranked…

Hey W, Could you share a screenshot of your full analyzer page? If a filter is applied that excludes categories C and D, they will not appear as an option for color rules. Another thing that could cause this is if categories C and D are not present when the calculation runs. i.e. if none of your data points are less than…