nmizzell Contributor

Could you send an example dataset with the desired output?

Try sum(case when Date is null then 1 else 0 end)

You need to use Magic ETL Rank and Window tile to get turnover rate. Here is how you do it: Take the cumulative sum of employees hired (can be by department, job title, or cost center, as needed). This will be done using the rank and window tile (settings = sum preceding unbounded to following zero) by counting employee…

You can create a pivot table with the rows field as created date, and a second rows field as the company name. This will give you all companies by creation date. You will need to put a dummy value into the values box so that the chart will render. you can just do a count of rows, it does not matter since its a dummy column.

Can I use the group names instead of group IDs? If not, where can I find the group IDs?

Awesome, Thanks Colemen!!!

@damen I think that the average date will give you an incomplete or inaccurate result for this application. I suggest you compute each security's Macauly and Modified duration . This is the traditional metric for determining the "Average date" / interest rate sensitivity of a bond portfolio.

Let's assume that the "Month" column has the first date of the month referenced. The Beast Mode you will want to use is the following: sum(case when `Month` = date_sub(`Month`, interval 1 month) then `Value` end) - sum(case when `Month` = date_sub(`Month`, interval 0 month) then `Value` end) if you want to return 0 instead…

Happy to help!

1. Define a variable for the number of days after client start date that you want to include. This variable can be added in the dashboard as a control and can be manipulated. I will refer to this variable as `Number of Days To Include` 2. Create a beastmode to calculate total client spend within the specified days:…

You need a few helper columns to acheive this. The first is the ID, the second is the revision number. assuming the revision number is in chronological order (highest number being the one you want to count) then you can add another column that finds the maximum revision number by ID. Lastly, create a function that reads…

We posted about this same issue a few weeks ago. The workaround is to use enter instead of tab. It would be nice if Domo reverted back to the old tab functionality though.

Yes, Enter works for me.

There is a way to make a single card link to another webpage, but I am not aware of a method to have each element in a table act as a hyperlink. If the number of links you are displaying is relatively small, I suggest making text cards in a dashboard, then changing the interaction through the dashboard editor to take you…

Min(1, `decimal value to be capped`) Then, on your formatting, display the number as a percentage.

What is the final goal of your analysis? Do you want to have a table that summaries all time goals by subcategory and question number? If so, do you want to add the all-time goals or average them? I suggest converting each goal into a common format first, if there will be an aggregation across months. However, if the…

Thanks Michelle. This method worked.

The summing is throwing things off. This will get you the intended result: Today count(case when `event_date` = current_date() then `records` end) Yesterday count(case when `event_date` = date_sub(current_date(), interval 1 day) then `records` end)

Custom formula.

Your Date format string is incorrect. You can view the list of valid strings here . The following beastmode would produce the desired effect: date_format(`Date`,'%Y-%m-%d')

I am open to using a DDX brick for this. I just need to know which one to use.

You need to restructure your dataset in ETL instead of using a Beastmode. I suggest you take the following steps: Create a 'Part Identifier' Column that is a combination of the A,B,C,D Columns. This column will represent the unique identifiers that you want to take the average over. You may use a CONCAT() function to…

Try lower(`email address`)

Try sum(case when Parent Expense Category Name= 'P-CARD' THEN Transaction Amount END) When working with pivot tables, I find it easier to re-structure the underlying dataset to get the desired pivot format. Beast modes can be a hit-or miss when the goal is to display a customized calculation in a pivot table.

Correction: I reversed the order of the nulls in the beastmode. The corrected beastmode is as follows: Case when `Campaign ID (dataset A)` is null and `Campaign Id (dataset B)` is not null then 'Found in B, Missing in A' when `Campaign ID (dataset B)` is null and `Campaign Id (dataset A)` is not null then 'Found in A,…

Hi Anna, I suggest you use a Full outer join on the campaign identifier within the ETL. Here is an example: When you perform a full outer join and retain both identifier columns, you can read the nulls to determine which rows are present in either dataset, or both datasets. See the included beastmode for reference. Case…

@learnDomo What does your dataset look like? To get the desired visual, you may need to change how your data is structured. If you can get your data into a table with this structure (see 1st image) then you can add the columns into the Analyzer for the pivot table chart type as follows (see second image).

Do you want the formula to return a date or the shipment dollars? What are the columns in your dataset?

Yes, it does, this makes it so much easier. I can just count ids by date added. Thanks Colemen!

Thanks, Colemen, Could you provide an example of what the dataflow would look like? I would like to have the calculation run on all months and keep the data in one dataset. It sounds like a recursive dataflow will only give me one month at a time.