ColemenWilson Coach

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

@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 >…

Do you mean can you make a summary number green? Or how do you create a summary number? The green part is showing already, do you want it to show somewhere else?

((Last Value - First Value) / First Value) * 100 I don't know the structure of your dataset or what represents your first and last values, but you'll need to create the above logic in a beastmode.

To show a % change in a summary number, you'll need to calculate the % change in a beastmode (calculated field). Once you have created the beastmode, you can select it as your summary number value.

Interested in this as well. With GA4 I've not seen a way to identify who in our org is taking and completing trainings. I know @Ashleigh has made some progress but still not successfully accomplished this.

Check your PDP policies to see how they affect those users.

And the "Manage all users" grant could be removed for the users you don't want to edit the department field as this grant is required to edit the Department field for all users.

This can be done using the ASCII() function in a SQL dataflow. Doesn't work in a beastmode or Magic ETL.

Gotcha, if you give the output a name and then run the dataflow it will appear as what you have selected in red in your screenshot.