Can we do unpivot functionality in ETL, in the beast mode?
I wanted to unpivot two value column, let's say, A & B, in which the first column gives A,B (row wise) and the second column gives its corresponding value. Thus, I can use the first column as filter and value column in the card. When we select either A or B, then the values in the card will change according to that. This is achievable through ETL, but Is there any way to make it through beast mode calculations.