ColemenWilson Coach

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.

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:

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.

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:

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: 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:

@Kailin Ah, yes with the full screenshot I see that that is a different chart type called Spark Bar as @ST_-Superman-_ pointed out. Chart Types > Other Charts > Spark Bar

If I am understanding your question correctly, you could use a single formula tile in Magic ETL with a series of case statements to create new fields. To recreate the logic you posted above would be: CASE WHEN `customField<0-N>_fieldName` = 'Member_Info_Verified' THEN `customField<0-N>_fieldValue` END You would name this…

Oh I see, this screenshot is not from something you've made. You are trying to recreate it. Here are the steps: 1. Chart Types > Gauges > Multi-value Columns 2. Set a gauge value 3. Set a comparison value 4. Properties > Change Value Options > Value > Percent Change 5. Properties > Change Value Options > Hover Text >…