Beast mode errors in dataset views

Jobur

Hi,

I am struggling to create a simple beasemode in a datasetview, grouped by quarter.

I am creating a new cost column, containing usd_cost for each account unless it is one of the 6 listed accounts and then use the marketing_cost.

I am unable to validate the beast mode ("Whoops error!!" is not helping)

The column names are correct, I am not clear whether it is the grouped dataset view that is causing the issue, or if as the accounts is a text field there is a format mismatch, or something else…

How do I troubleshoot this?

CASE 
    WHEN `account`IN ('5704','4941','4216','4194','4217','4213') THEN `Sum usd_marketing_cost`
    ELSE `Sum usd_cost`
END

All suggestions appreciated…

Thanks

John

MichelleH

@Jobur I'm glad you got it to work in the dataset. Yes, I've found that calculated columns don't always perform well in dataset views, especially when columns or removed or grouped.

MarkSnodgrass

It might actually be that your IN does not have a space before it so it is reading accountIN as one thing, when it isn't.

Jobur

Thanks Mark, that's not the issue, but it is a typo in what I wrote above. Are there differences between how beast modes work in dataset views to cards?

MichelleH

@Jobur Are all of the fields referenced in your formula in your final grouped output?

Jobur

Yes Michelle the account is a grouped column and the two cost columns are both summed.

MichelleH

@Jobur Just to confirm, are you adding this formula as a calculted field in the view or as a beast mode in the card? It may be worth trying the opposite method to whatever you did before.

Jobur

Hi Michel, I was using the beastmode to add a column to a dataset view which groups the data by quarter. I could not get the statement to work. I have just added this column to the base dataset instead, so I have a working solution now.

I would love to understand if it is the dataset view that was causing the error?

MichelleH

@Jobur I'm glad you got it to work in the dataset. Yes, I've found that calculated columns don't always perform well in dataset views, especially when columns or removed or grouped.