Beast mode calculations not showing in the magic ETL

user08570
user08570 Member
in Magic ETL

So we have this dataset with a lot calculations fields. I need to merge it to another dataset. But when I am doing magic ETL, I loss all the calculated fields. Any easy solution to this? The calculated fileds are showing when I am creating the cards but not on ETL. I don't want to add all the columns again. 

 

Thanks,

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    When you create a beast mode and click on the check box, "share calculation on dataset", it will only show up in the card analyzer when that dataset is selected. They don't ever show up in the Magic ETL. 

    You can, however, copy beast modes from one dataset to another by changing datasets for a card in a specific way. Here's how:

    1. View a card that has the dataset with all of your existing modes.

    2. Scroll down to the bottom where is shows the dataset that is powering the card and how long it is has been since it was last updated. Click on on the last updated link (i.e. Dataset was updated 5 hours ago).

    3. This brings up a pop up and lets you change datasets. Click on Change Dataset and choose the new dataset to use.

    4. Confirm everything and then it will copy all of the beast modes to that dataset.

    If the field names are exactly the same (including case sensitivity) the beast modes should work automatically. Once you have the beast modes copied over, you can move multiple cards at once to the new dataset through the data center by clicking on the old dataset and then the cards tab and choose "switch cards to a different dataset". 

     

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    When you create a beast mode and click on the check box, "share calculation on dataset", it will only show up in the card analyzer when that dataset is selected. They don't ever show up in the Magic ETL. 

    You can, however, copy beast modes from one dataset to another by changing datasets for a card in a specific way. Here's how:

    1. View a card that has the dataset with all of your existing modes.

    2. Scroll down to the bottom where is shows the dataset that is powering the card and how long it is has been since it was last updated. Click on on the last updated link (i.e. Dataset was updated 5 hours ago).

    3. This brings up a pop up and lets you change datasets. Click on Change Dataset and choose the new dataset to use.

    4. Confirm everything and then it will copy all of the beast modes to that dataset.

    If the field names are exactly the same (including case sensitivity) the beast modes should work automatically. Once you have the beast modes copied over, you can move multiple cards at once to the new dataset through the data center by clicking on the old dataset and then the cards tab and choose "switch cards to a different dataset". 

     

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • jaeW_at_Onyx
    jaeW_at_Onyx Coach

    @MarkSnodgrass  and @user08570 , the new Beast Mode Manager beta has a feature that allows you to bulk copy Beast Modes from one dataset to another.  

     

    If you don't have the BMM, talk to your CSM to get added to the Beta program.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Categories