Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
Based on requirement, I developed a vizlib pivot table. We used 4 dimensions. In those four used one dimension as expression by using only() and another dimension has converted into column as shown below. Here I am missing values in table.
Input data:
Type | Program | Level | status |
data | Development | Level 1 | Completed |
data | Development | Level 2 | Queue |
data | Development | Level 2 | Progress |
data | Development | Level 3 | Open |
data | Development | Level 3 | hold |
Current Table:
Type | Program | level 1 | level 2 | level 3 |
data | Development | Completed | - | - |
Expected result:
Type | Program | level 1 | level 2 | level 3 |
data | Development | Completed | Queue | Open |
data | Development | Progress | hold |
Thanks In Advance.
Try this:
Instead of using "data" as a measure, use it with an aggr function.
Replace the data field with aggr( Data, status). This might duplicate the rows and fill the fields with the correct values considering the rest of the table.