nmizzell Contributor

If you want to exclude weekdays from the calculation, simply create a column to do so: case when day(`date_entered`) in (1,7) then 'Exclude' else 'Include' end Then, in the filters section of analyzer, select only 'Include.' Domo pivot tables will take care of the rest for ya.

Hey @Abe, try this: count(distinct `Ticket ID`) / 30 The only issue with this formula is that it assumes all the months have 30 days. If that won't work for you, then you can go with a slightly more complicated but more accurate solution (it can be further refined if you want to account for leap years, but i left that off…

Hey Abe, Could you share an example dataset and/or list the columns you have available? Also, an example of the desired output? Thanks,

Here is an example dataset with the custom week grouping: Feel free to change the week group from 1,2,3,… to whatever you want to be displayed on your bar chart.

Hey Raj Simply create an excel sheet with two columns: every day sequentially that you want to include in your data. The grouping for each of the days. Add this excel sheet to your domo dataset and join your other data onto it to get values for the days and weeks with your custom grouping

To add on to @ColemenWilson 's suggestion, you can multiply a value by another value using a conditional statement. For example: Case when demographic = 'male' then score * 2 when demographic = 'female' then score * 1.5 else score * 1.0 end

Got it. To do clustering, you will want to use a Domo Jupyter notebook. The notebook is fairly straightforward to set up. You can load in your dataset, execute your python code clustering function, and output the results to another dataset in domo, or even as a column in the same dataset. For your clustering function I…

@AdamC what is the desired output? What kind of visual do you want to create (pivot table, line chart, etc.)? Could you provide an example in excel or a screenshot / drawing of what the desired output would look like?

Hey Adam, Could you attach an excel spreadsheet with sample input and output data? It will be easier to explain what ETL / beast mode will need to be created if we have an example of what the inputs and desired outputs are. Thanks,

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')