RobSomers Coach

@JasonAltenburg You would need to make sure that the field you're using for your x-axis is a timestamp that contains minutes. Also make sure that your field is has both date and time:

@NathanDorsch You don't need your final "end". You only need an end when you're dealing with individual CASE WHEN statements.

@DataLawton For finding datasets that are no longer used, you can also click on Data in the toolbar at the top and then go to the Datasets section. From there you can use filters to find datasets that don't have any cards and flows.

@jmmc How may rows of input data does the flow have? I have an ETL flow with 1.4 million input rows that has multiple joins, some groupings, and a rank & window tile that runs in about 1m 30s. Do your inputs have a lot of columns? If you don't use all the columns, you might try selecting only the columns you need from each…

@aconway Are you wanting your date filter to be related to one of the columns or both?

You will need to use an ETL and the Rank & Window tile to do this using Dense Rank using the 'x' column in descending order. Then when you go to create your card with the new dataset, if you called the ranking column in the ETL 'Rank', you would just create a filter where 'Rank' is less than or equal to 3, to give you the…

@RajNadar There's no option to freeze the header on a pivot table, but it should be frozen by default with no need to do anything. I've gone through and looked at some of my pivot tables and all the headers are frozen automatically without having to do anything. It sounds like it's the same for @MarkSnodgrass.

@MattLynn You can also do this through and ETL if you don't care about filtering/drilling. You can just split your dataset and create a separate 'table' for each metric, and do the 2021 and 2022 values, and % Change for each one, and then append them all and create your card off the new dataset.

The not should be purple. It's hard to tell what's going on with just the small section of code. Could just be a bug and you can see if the beast mode still works and is valid. Also check if all the other syntax is correct and that you're not missing any and's, when's, etc.

When you want to exclude something that contains a certain string, you need to use NOT LIKE. So your beast mode would look like this: case when `EVENT_NAME` like '%Add-To-Cart%' and `EVENT_PARAMS_PAGE_LOCATION` not like '%/shop/%' then 'Add to Cart from XXX' end

@WillClark My company has a card that does something similar with YTD, MTD, last week, etc. You'll need to write a beast mode for each time period you want to calculate, and use the current date to determine what gets included. A YTD beast mode would look something like this: case when YEAR('date') = YEAR((date(CONVERT_TZ(…

@MarkSnodgrass is correct. I wasn't paying attention to my pivot tables and was just looking for chart properties! The pivot table header should be frozen automatically.

@Musetti, Since you're looking to make a percentage, try removing the 100* from your beast mode and then change the format of your value to be a percentage.

@RajNadar There is currently no way to freeze a the header in a pivot table. This would be good to post in the idea exchange as a suggestion.

The image can only be a certain size, and Domo will automatically crop the image to fit. It doesn't appear that there's an option for gradients, so that may be something to post on the idea exchange.

Doing this depends a lot on how your data is organized and what data you have available. If your employee data has id's for an employee's manager, then you could use an ETL to join the employee's immediate manager to the table and then join the table again on the manager's manager, etc. Alternatively, you could possibly do…

Hi @willrnt, what is the end goal of your filtering? Is it so that only certain users can see data by default? If that is the case you will probably want to look into PDP's.

@NathanDorsch , if your first filter is removing all data prior to 6/30/22, then you might not have any data greater than 6/30/21 available after that first filter is applied.

Whenever you want to do an aggregation you need to put your function on the outside of your case when statement. If you do case when 'x' then max(date), the beast mode just does the calculation for each individual line, so it will just take the max date of each row in your dataset. If you instead do MAX(case when 'x' then…

The key is that your SUM(Implementing) is a multiple of your Implementing column. Whenever you have one column that is not an aggregate and another that is an aggregate, Domo will group the non-aggregated column. So for example, in your data it looks like there is one row with 13 hours, two rows with 42 hours, 3 rows with…

Could you post the COUNT(DISTINCT) beast mode you're using and maybe one or two other examples of beast mode that don't work as expected? This will help us have a better idea of the problem you're running into.

It looks like your last sum function is missing a closing parentheses after 'else 0'

I would put ELSE 'Unknown' right before the end to more easily identify cases where none of your rows meet them conditions and see if there's anything that should have a value but doesn't. Then you can see if that has anything to do with what's missing.

Could you post it with the columns and values used replaced with other names and values, so we can just see what the formula looks like? What the actual columns/values are shouldn't matter.

I agree with @mhouston. Your original beast mode with the sum inside the case when statements just does the calculation on a line by line basis in your base table. If you want to do a sum or any calculation based on your table as a whole, then you have to put your case when inside the SUM function.

Could you post your beast mode that you're using as a filter?

@EWold , do you have anyone in your organization who knows SQL? The Magic ETL is just a visual representation of SQl, so if there's somebody who's knowledgeable with SQL, they should be able to use the ETL to write an equivalent query.

@alexk, how large is your dataset? Sometimes with pivot tables if the dataset is huge, it won't display all the data in each category row.

I don't believe there's a role that just automatically adds someone to every card. This probably isn't ideal and might be time consuming, but if you haven't created one yet, I would suggest creating a 'View All' group and add it to all the cards/dashboards/PDP's. Then you can add your boss, or anyone else in the future, to…

@Sandis, you can try clicking on your profile picture and click on the 'Settings' icon. From here you can look at daily alerts and see if there's are any alerts you're subscribed to under the Daily Alerts tab. You can also uncheck the 'Include updates about your favorite cards' and see if that stops the report from being…