Adding Budget Rows to Actual

dylang91
dylang91 ⚪️
edited January 31 in Dataflows

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"


Tagged:

Best Answer

  • GrantSmith
    GrantSmith Indiana 🥷
    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 Portland, Oregon 🥷

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

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • I have a question that would like to be answered

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