Help with Path/PathLevels

[RamEHG]

I have a table which has hierarchical data along with a date/id stamp. My table has the following columns (sample data outlined as well)

ID | Date Scored | Score | Type | SubType

P_1 | 1/2/2024 | 93.72 | null | Level1

P_1 | 1/2/2024 | 36.28 | Level1 | Level2a

P_1 | 1/2/2024 | 79.59 | Level1 | Level2b

P_1 | 1/2/2024 | 88.34 | Level2a | Level3a

P_1 | 1/2/2024 | 27.96 | Level2a | Level3b

P_1 | 1/2/2024 | 88.16 | Level2a | Level3c

P_1 | 1/2/2024 | 10.01 | Level2b | Level3d

P_1 | 6/2/2024 | 95.72 | null | Level1

P_1 | 6/2/2024 | 3.28 | Level1 | Level2a

P_1 | 6/2/2024 | 7.59 | Level1 | Level2b

P_1 | 6/2/2024 | 8.34 | Level2a | Level3a

P_1 | 6/2/2024 | 7.96 | Level2a | Level3b

P_1 | 6/2/2024 | 8.16 | Level2a | Level3c

P_1 | 6/2/2024 | 14.01 | Level2b | Level3d

P_2 | 1/2/2024 | 3.72 | null | Level1

P_2 | 1/2/2024 | 6.28 | Level1 | Level2a

P_2 | 1/2/2024 | 9.59 | Level1 | Level2b

P_2 | 1/2/2024 | 8.34 | Level2a | Level3a

P_2 | 1/2/2024 | 7.96 | Level2a | Level3b

P_2 | 1/2/2024 | 8.16 | Level2a | Level3c

P_2 | 1/2/2024 | 0.01 | Level2b | Level3d

I want to be able to show a visual of how the score decomposes into each level for a given ID & Date Scored combination - essentially a way to look at Level1 score which then shows Level2a and Level2b scores etc (sort of a sunburst chart - see example attached). I was able to use Path, PathLevel, etc to create a hierarchy however am struggling with getting the value for each level for each ID/Date Scored pair

Any help is appreciated.

+Ram

[Anonymous]

Hi @RamEHG 

Could you please explain to us the correlation between the scores at each level and what is the logic behind the calculation of these scores?

I was able to use Path, PathLevel, etc to create a hierarchy however am struggling with getting the value for each level for each ID/Date Scored pair

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Not sure what that visual is supposed to say but here's the cleaned up data