nmizzell Contributor

I am open to using a DDX brick for this. I just need to know which one to use.

You need to restructure your dataset in ETL instead of using a Beastmode. I suggest you take the following steps: Create a 'Part Identifier' Column that is a combination of the A,B,C,D Columns. This column will represent the unique identifiers that you want to take the average over. You may use a CONCAT() function to…

Try lower(`email address`)

Try sum(case when Parent Expense Category Name= 'P-CARD' THEN Transaction Amount END) When working with pivot tables, I find it easier to re-structure the underlying dataset to get the desired pivot format. Beast modes can be a hit-or miss when the goal is to display a customized calculation in a pivot table.

Correction: I reversed the order of the nulls in the beastmode. The corrected beastmode is as follows: Case when `Campaign ID (dataset A)` is null and `Campaign Id (dataset B)` is not null then 'Found in B, Missing in A' when `Campaign ID (dataset B)` is null and `Campaign Id (dataset A)` is not null then 'Found in A,…

Hi Anna, I suggest you use a Full outer join on the campaign identifier within the ETL. Here is an example: When you perform a full outer join and retain both identifier columns, you can read the nulls to determine which rows are present in either dataset, or both datasets. See the included beastmode for reference. Case…

@learnDomo What does your dataset look like? To get the desired visual, you may need to change how your data is structured. If you can get your data into a table with this structure (see 1st image) then you can add the columns into the Analyzer for the pivot table chart type as follows (see second image).

Do you want the formula to return a date or the shipment dollars? What are the columns in your dataset?

Yes, it does, this makes it so much easier. I can just count ids by date added. Thanks Colemen!

Thanks, Colemen, Could you provide an example of what the dataflow would look like? I would like to have the calculation run on all months and keep the data in one dataset. It sounds like a recursive dataflow will only give me one month at a time.

Thanks, Colmen.

Thanks @MichelleH ! I will do that instead.

This is the percentage of the total variance for the column. I am looking for the percentage change between This year and last year's revenue totals. For this example, it should be -15%, not 1.7%. The variance column that is displayed is only a placeholder.

Thank you! The Domostats dataset has the exact time I needed.

Thank you! This worked.