Adding Budget Rows to Actual

dylang91 · 2022-01-31T20:16:11+00:00

There was an error rendering this rich post.

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"

Find more posts tagged with

Append

Magic ETL

Accepted answers

GrantSmith

@dylang91

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

All comments

MarkSnodgrass

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

dylang91

I have a question that would like to be answered

GrantSmith

@dylang91

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

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.