Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Transform some rows into a new column

Hello,

I have a table with the following structure:

Year_MonthType  Value
2023.01Production    5
2023.01Production_Target   7
2023.01Compliance   8
2023.01Compliance_Target   8
2023.02Production   10
2023.02Production_Target   12
2023.02Compliance   4
2023.02Compliance_Target   6
2023.03Production  15
2023.03Production_Target   13
2023.03Compliance   11
2023.03Compliance_Target   12

 

Rows where the Type column has the value "_Target" indicate that they are rows with target values ​​for the respective Indicator Type (for example, the type "Production" is the actual production value for each month and the "Production-Target" is the expected value for each month). I want to create charts for each Type that show the actual value for each month and a goal line (which shows the "_Target" values ​​for each month), but I'm not able to turn this table into a better way.

My expected table result would be this:

Year_MonthTypeValueObjective
2023.01Production57
2023.02Production1012
2023.03Production1513
2023.01Compliance88
2023.02Compliance46
2023.03Compliance1112