cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
andyring Frequent Visitor
Frequent Visitor

Actual vs Budget

Hi, I would like to compare actuals vs budget by using a visualisation. My problem comes with my data. Capture.PNG

As you can see, I have a versiojn column which has thousands of rows containing either ACT or BUD, which is tied to values column. I am wondering if it is possible to somehow create two additional columns: one for filtered ACT values and one for BUD. That way, when trying to use a visualisation such as gauge, I can try displaying the different values rather than what happens below.

Capture1.PNG

 Open to other suggestions of visualizations too. Thank you for the help

1 ACCEPTED SOLUTION

Accepted Solutions
Gazzer Member
Member

Re: Actual vs Budget

This should be relatively easy to do, and you have already pretty much explained it to yourself!

 

Just create two Conditional Columns (one for BUD, one for ACT). In the ACT one, if Version = ACT then [values column] else 0. Do the same thing for the BUD column, just checking for the value "BUD" this time. You should then have the columns you need to finish the job.

1 REPLY 1
Gazzer Member
Member

Re: Actual vs Budget

This should be relatively easy to do, and you have already pretty much explained it to yourself!

 

Just create two Conditional Columns (one for BUD, one for ACT). In the ACT one, if Version = ACT then [values column] else 0. Do the same thing for the BUD column, just checking for the value "BUD" this time. You should then have the columns you need to finish the job.