Actual vs Budget

[andyring]

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

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.

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

[Gazzer · Accepted solution]

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.