Forum Discussion
Navemba
2 years agoRegular Visitor
Matrix rows with two headers
Hi, I have a table similar to the one bellow And I wanted to create a matrix similar to this one Basically, the takeoff and landing excluding the (blanks) and the "-1", but when I...
Ashish_Mathur
2 years agoSuper User
Hi,
In the Query Editor, right click on the first column and select "Unpivot Other Columns". To the matrix visual, drag Attribute and Value to the Row labels and Hour to the Column labels. Write this measure
Count = countrows(Data)
Hope this helps.