ColemenWilson Coach

You'll get the format you want with a pivot card if you set it up as shown below: Would these results work for you? If not you can use the table card and click "transpose" in General Chart Properties but I don't think that gets you the format you are looking for: But if so you can use the table card and click "transpose"…

Well, if it is an aggregate function - COUNT or MAX then yes you would see different values then if you just drill into the final data view because the final data view is an unaggregated view of the underlying data.

MEDIAN() It doesn't show up in the function list in beastmode editor but you can use it and it works.

Thanks @shreeyab. Some things to check/consider: 1. You can prevent drilling down to the final dataset view by selecting "Prevent drilling to final data grid view" 2. When editing the drill path, you will be in analyzer view with all data being displayed - this means that as you are creating the drill path, the data will…

There is a Domo Governance dataset called "Card Fields and Beast Modes" that shows all of the fields used in the cards in your instance. https://domo-support.domo.com/s/article/360056318074?language=en_US

Hi @shreeyab could you provide a bit more information?

I’m not at my computer to verify so someone please correct me if I am wrong, but the only way to do it would be in a beastmode and share the beastmode to the dataset or in the ETL. for beastmode it would be: DATE(yourDateField) in ETL it would be using the date tile or a formula tile with the above beastmode.

Welcome to Domo! Here are the steps to accomplish what you are hoping to do: 1. Click the + icon in the top right of Domo and select "Dashboard" 2. Over on the right side of the screen you'll see icons representing the various objects you can add to a dashboard, select the one that says "card" and click and drag into the…

The drill path will lead to a view with a filter applied for what has been selected. So if the bars are months and you click January, for example, then the drill path card will only show data for January. If your bars are days, when you click a day, January 3rd for example, then the drill path card will only show data for…

Remove the "AS trx_yr_week" from your beastmode Other date formatting: yyyy-mm-dd DATE_FORMAT(trx_date, '%Y-%m-%d') yyyy-mm DATE_FORMAT(trx_date, '%Y-%m') yyyy-ww (Where Monday is the first day of the week) DATE_FORMAT(trx_date, '%Y-%u') Other date formats: https://www.w3schools.com/sql/func_mysql_date_format.asp

I agree with @MichelleH , you would then use the new field as a filter on the card and select IN complete.

Here is what the beastmode would look like for column A % change between pre and post: (AVG(CASE WHEN Survey Type = 'post' THEN Score A END) - AVG(CASE WHEN Survey Type = 'pre' THEN Score A END)) / AVG(CASE WHEN Survey Type = 'pre' THEN Score A END) You can copy and paste this for Score B and C - just replace Score A with…

Do the services map to profit centers? For example, is XCS always in the ABC profit center? How many total services & profit centers are there? Are there any other fields that group profit centers together?

Ah sorry I missed that you want both the original and the duplicate row gone when a duplicate exists. Interested in your use case - why you want both records gone when there is a duplicate and not just the duplicate? Is it that the duplicate transaction is to zero out the previous? If that is the case, and `retail` is the…

You can select which columns identify the duplicates using the remove duplicates title and selecting Store, Line, Item, Change Qty Abs, and Retail Abs as the fields that identify the duplicate.

Could you explain how the two rows you screenshot above are duplicates? Is there some additional criteria beyond duplicate values in the data itself?

Short answer: you can't. Long answer: Projected values update in real time as new data becomes available. You could store the projected values in a beastmode or in a webform and join them back to your data, but at what point would you consider them locked in? 1 day out? 3 days out? It sounds like perhaps this is just a…

There is a tile called "Remove Duplicates" that you can use in Magic ETL to only keep unique rows. https://www.youtube.com/watch?v=TNY86GuHl4g

To put the text in a summary number you'd create a beastmode and then select it as the summary number value: CONCAT(`street`,' ',`city`,', ',`state`,' ',`zip`)

The problem you are going to run into is that when you select a date range as a filter, it will filter out the rows from the previous year because those rows are not within the date range you are selecting - making it impossible to compare to their values because those values have been filtered out. One solution would be…

Ahh gotcha! In my solution I was trying to get a card that would only display rows for the individuals who that meet the criteria and all rows for that individual. Glad you got something that works for you!

You can do aggregate value filters, but not on the total column - UNLESS the total column is a calculated field (beastmode) and then you can apply the filter to that field directly. Otherwise the filter will be applied to any aggregate value above your threshold.

Yes. I would recommend adding this to the ideas exchange: https://community-forums.domo.com/main/categories/ideas

Oh I see. No that is not possible.

Yes it is. More > Admin > Cards > Dashboards ⁝ > *type name of dashboard that contains cards you want to move* > single select cards (or click select all) > Edit > Add to Dashboards > *type the name of the dashboard that you would like to move the cards to the appendix of* > Add to Dashboards

Here's how to solve in Magic ETL: Group By: 2. Join Flags 3. Filter to desired flags

@ColinHaze You could kind of replicate this behavior on a dashboard though using pfilters and/or changing the card interaction on the page to direct to another dashboard.

@Priyanka check your sorting and date range. Incorrect sorting or graph by settings in the date range can cause data to not be aggregated as intended. As an exercise you can remove sorting fields and in graph by select "none"

Walked through how to do it here: https://www.loom.com/share/5abc1ddf7dfa4e39a39472d274240f64?sid=337d1499-14b3-4766-b18f-18d509408ba3 This is modified from what I previously suggested and doesn't require lag and lead functions. Big thanks to @AustinHarrison for the idea of a more simple way to do this using row numbers!

Hey @MayaU_01 , in Magic ETL you'll calculate the sum of the column in a group by tile. You'll then rejoin that back to the rest of the data on 1=1 so that it appears in every row of data. Here is a recording walking through it:…