a beast mode that calculate revenues from diff sources

Abe
Abe Member
in Beast Mode

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:

Best Answers

  • nmizzell
    nmizzell 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?

    image.png

  • Abe
    Abe Member
    Answer ✓

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

    Yes please, i would need to have this shown.

Answers

  • MichelleH
    MichelleH Coach

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

  • Abe
    Abe Member
    edited August 7

    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.

    image.png

  • Abe
    Abe Member

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

    Thank you again for the assistance.

  • Abe
    Abe Member

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

  • nmizzell
    nmizzell 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,

  • Abe
    Abe 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.

  • nmizzell
    nmizzell 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?

    image.png

  • Abe
    Abe Member
    Answer ✓

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

    Yes please, i would need to have this shown.

  • Abe
    Abe Member

    @nmizzell

    Thank you for the assistance. Greatly appreciated!

Categories