Magic ETL

Magic ETL

Totaling Summary Numbers on Domo Page

Hey team! I'm not sure this is possible, but I wanted to reach out to the community just in case there's a workaround. We have a Domo page that tracks employee data errors when certain fields in our payroll provider are missed during new employee additions and/or position changes.

Based on the screenshot, you can see that we currently have 3 errors for salaried employees. I'd like to display something like 'Total Data Errors' with a card or dynamic text that states the total alerts and maybe even indicating the WoW increase in those errors.

I've included a screenshot for reference. Please let me know if this is possible.

Domo Community.PNG

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

  • Answer ✓

    Yes, you can. It all depends on your datasets.

    If those 3 cards are all built on the same dataset and are just looking at different fields, you can create a beast mode that looks at all 3 fields and sums them up.

    If those 3 cards are based off of 3 different datasets, you would need to use Magic ETL and append those 3 datasets into a single dataset and then sum up the error column to get your overall total.

    **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.
  • Contributor
    Answer ✓

    @Mwatson , you could evolve the card that you created based on Marks input and make it a period over period multi value chart. Shows your progress of reducing errors or the unfortunate case of increasing errors. :/

    image.png

    IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!

Answers

  • Answer ✓

    Yes, you can. It all depends on your datasets.

    If those 3 cards are all built on the same dataset and are just looking at different fields, you can create a beast mode that looks at all 3 fields and sums them up.

    If those 3 cards are based off of 3 different datasets, you would need to use Magic ETL and append those 3 datasets into a single dataset and then sum up the error column to get your overall total.

    **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.
  • Contributor
    Answer ✓

    @Mwatson , you could evolve the card that you created based on Marks input and make it a period over period multi value chart. Shows your progress of reducing errors or the unfortunate case of increasing errors. :/

    image.png

    IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!

  • Thank you both! That was very helpful.

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