Multiple "Detailed by" in Data view

Benedikt
Benedikt Customer
Name Dropper First Comment Level 100: Foundations of Building in Board
in Platform

Is it possible to use two ore more "detailed by" in an data view?

image.png

It would like to report not only the average revenue / gross add per month by tarifcluster but by tarifcluster and a second or third entity.

Tagged:

Accepted Answer

  • Benedikt
    Benedikt Customer
    Name Dropper First Comment Level 100: Foundations of Building in Board
    Answer ✓

    Thank you for your help. I changed the "Blocks alignment" option from "Vertically" to "Horizontally" and then it worked.

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary

    Hello @Benedikt ,

    there is only one entity possible to be used in a "Detail By". Depending on how many members you have in those additional entities it might prove helpful using those in the "by column".

    Another possibility would be the use of dedicated cubes where you pre-calculate the average values you'd like to display.

    Best,
    Helmut

  • Suman Das
    Suman Das Active Partner
    10 Comments Second Anniversary Level 300: Expanding Board in Your Organization Year 2 Community Captain

    Dear @Benedikt ,

    currently multiple detail by is not possible in Board. But you want to show the data on multiple column structure. you can use the other entities on the coumns and one in detailby.

  • Benedikt
    Benedikt Customer
    Name Dropper First Comment Level 100: Foundations of Building in Board

    Dear @Suman Das,

    thanks for your comment. I tried it out:

    image.png

    and got this error message:

    image.png

  • Benedikt
    Benedikt Customer
    Name Dropper First Comment Level 100: Foundations of Building in Board

    I would like to describe my task a little more clearly. Thank you very much for your help:

    image.png

  • Suman Das
    Suman Das Active Partner
    10 Comments Second Anniversary Level 300: Expanding Board in Your Organization Year 2 Community Captain

    Hi @Benedikt ,

    Could you please update your instance to Version 14 and try the process again? Meanwhile, to achieve the desired data view, you can follow these steps:

    1. Place channel and tariff_plan in rows.
    2. Use the gross_ads cube with details organized by month.
    3. Apply the other cube in the filter.

    Once you have tried these two approaches, please let me know the outcome. I’ll be happy to assist further if needed.

    Looking forward to your update.

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary

    Hi @Benedikt ,

    I'm assuming "Hardware" is your "Channel" and "Tarifcluster" is your "Tariff_plan". If so, since both your cubes use the dimensions "Tariff_plan" and "Channel" just put those dimensions by row and "Month" by column—you won't need any detail by.

    Best,
    Helmut

Categories