Forum Discussion

SimonGrams's avatar
SimonGrams
Icon for Helper I rankHelper I
9 years ago

Data & hierarchy adaption

Hi guys,

 

I have some problems showing the correct data in a visual and simultaneously display Filters in a required hierachy. 

 

My data looks like this (on a weekly basis):

 

Data

YearWeekLevelsSessions
201714A0489
201714A1547
201714A2295
201714A3447
201714A4366
201714B0316
201714B1398
201714B2280
201714C0499
201714C1512
201714C2480
201714C3496
201714D0416
201714D1524
201714D2408
201714D3263
201714D4270

 

These levels are different product categories from an online shop.

These categories subdivide as in the LookUp table:

 

LookUp (hierarchy)

Level 1Level 2Level 3Level 4Level 5
A0----
A0A1---
A0A1A2--
A0A1A2A3-
A0A1A2A3A4
B0----
B0B1---
B0B1B2--
C0----
C0C1---
C0C1C2--
C0C1C2C3-
D0D1---
D0D1D2--
D0D1D2D3-
D0D1D2D3D4

 

Desired result:

5 Filters, which display the hierarchies / adapt to the chosen levels

 

 

Problem:

If I create a relationship between the data and the LookUp table and choose e.g. A0, the other Level-filters adapt to my choice beautifully, but the "Sessions"-Measure sums up all levels which "belong" to A0 (A1 to A4).

I just want the sessions of the chosen filter, here A0 (& the filter-adaption) - like I get by choice of "-" in level 2:

 

Is there any possibility to get the desired output & the filter hierarchy-adaption / do I have to create a new Session-Measure?

 

Thanks in advance...

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi SimonGrams,

    Do you display raw structure and data of your tables in the above screenshot? If so, which columns do you use to create relationship between  the two tables? Do you want to show 489 when selecting the A0  in Level 1 slicer and selecting - in Level 2 slicer?


    Thanks,
    Lydia Zhang