Beast Mode

Beast Mode

a beast mode that calculate revenues from diff sources

Hi Everyone,

I have a data set that shows where our tickets are being created and revenue.

And I created 2 beast modes that separate where our tickets are being generated -

CASE WHEN Source= 'G360' THEN 0 ELSE 1 END

and

CASE WHEN Source= 'G360' AND (Board_Name='Field Services - MAC' or Board_Name='Field Services - Repair') THEN 1 ELSE 0 END

Now I want to add a revenue column to each of the beast mode that was created but i'm having issues creating a beast mode.

We have a calculation measurement that we show the total revenue for an account.

What beast mode function would I use to show the revenue for each of the beast mode?

Would I add on to the beast mode that was created by adding the calculation measurement?

Any assistance is greatly appreciated.

Tagged:

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Best Answers

  • Contributor
    Answer ✓

    I understand now.

    The data will need to be pivoted in magic ETL to achieve the desired effect.

    To confirm, do you want to see a table in the following format as your output?

  • Member
    Answer ✓

    @nmizzell . ohh, I have to create a new data set for this.

    Yes please, i would need to have this shown.

Answers

  • Hi @Abe, would you be able to share some sanitized sample data with an example of how you want the output to look?

  • Member
    edited August 2024

    Hi @MichelleH, please see below.

    Basically, I want the Revenue to show for each source- Non -G360, Non-360-FS, and G360-FS.

    These show how many tickets are created for each and the revenue total it produces for the # of tickets. We do have a measurement for the Total revenue but we want it separated from each source. Hopefully it makes sense. Thank you again for the assistance.

  • Member

    hi @MichelleH , any thoughts on what beast mode calc can be created to provide the data?

    Thank you again for the assistance.

  • Member

    hi @nmizzell , would you be be able to assist on this beast mode questions please?

  • Contributor

    Hey Abe,

    What is the meaning of the numbers in the Non-G360 column? Are those numbers an identifier?

    If those numbers are an ID, do you want to see the sum of revenue for each ID?

    Thanks,

  • Member

    hi @nmizzell, thank you for the assistance.

    So those numbers represent how many tickets have been opened. The columns- non-g360, non-g360- fs, and g360-fs are sources on where are tickets are being created.

    Non-G360 column shows 3 tickets have been created with a total revenue of $$$$ from those 3 tickets. And so forth with the other columns.

  • Contributor
    Answer ✓

    I understand now.

    The data will need to be pivoted in magic ETL to achieve the desired effect.

    To confirm, do you want to see a table in the following format as your output?

  • Member
    Answer ✓

    @nmizzell . ohh, I have to create a new data set for this.

    Yes please, i would need to have this shown.

  • Member

    @nmizzell

    Thank you for the assistance. Greatly appreciated!

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In