Adding Budget Rows to Actual

dylang91
dylang91
edited January 2022 in Magic ETL

Hello, I have an original cases database in DOMO each row has a case submission and case start, and then I later replicate it all the columns and added the budget we have for the year. I had to unpivot this data in order to create graphs that will put both dates in the same axis.

I would like to show the budget as a third column and for the actual to dont add on the budget on it, since the budget info also has dates for submission and case start but they are fake.

The Budget info has an extra column "Constant" labeled as "Budget"

data.PNG
ETL.PNG
Conversion Rate.PNG


Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    @dylang91

    Can you just join your budget values to your pivoted dataset based on the date so you have the column for budget?

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach

    Did you have a question that you need answered? Or were you just sharing for the community?

    **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.
  • dylang91
    dylang91

    I have a question that would like to be answered

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    @dylang91

    Can you just join your budget values to your pivoted dataset based on the date so you have the column for budget?

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • dylang91
    dylang91

    @GrantSmith thank you I added the Budget as a new label and that did the trick! I kind of realized it when typing my question lol. thanks for bringing more clarification.

Categories