Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How to create graphs using budgeted vs actual data from two different columns?

Our team has recently moved our data collection over to Asana to help with collection and organization. I am much happier with this change but am struggling to figure out how to create our graphs comparing target values vs actual values like we have in the past. Our data structure currently looks like this when exported out of Asana 

I've researched this question in the forums and it seems everyone says to use unpivot to fix the problem, but I don't see a way to unpivot this to make that work. It is not an option to change the format in Asana, our team worked on multiple ways to store that data and this was the best option. Other options would have had even more problems. 

 

Here is an example of the type of graphs we usually would make with this kind of data. 

Here is an example of how our data used to be stored. In this format, we stored each department in their own sheet and all numbers were in the same column with a column that stored if it was a budget or actual to filter on.

 

Does anyone have any advice on how to deal with this problem?

  • Hi Anonymous 

    In fact, the best way I can see is pivot columns Target Value and Actual Value. You can load the data from ASANA and use the Unpivot Columns in Power Query. See the images bellow.


     

     

     

1 Reply

  • Hi Anonymous 

    In fact, the best way I can see is pivot columns Target Value and Actual Value. You can load the data from ASANA and use the Unpivot Columns in Power Query. See the images bellow.