Group By and Drill down

Jez

Hi, I am new user of DOMO and need help building this report:

I have a data with columns: Name, Age, Birthday, Position, Email, Salary.

For initial screen I want a filter channel by Name, Age and birthday.

Then allow user to drill down into each Name for Position, Email, Salary details.

Thank you!

ColemenWilson

Gothca! Here are the steps:
1. Create a table card and add the fields Name, Age, and Birthday
2. Save and exit the card
3. Click the wrench on the card:

4. Click "Edit Drill Path"

5. Click "Add a view"

6. Repeat step 1 but with the fields you want displayed in the drill down view.

ColemenWilson

Hi Jez, could you share a bit more information? Who will be the audience for this report? What metric are you wanting to show? Salary by employee? Salary by position? Salary by age? Or something else?

Jez

Hi ColemenWilson,

Thanks for the response. This is like an information sheet, but with a filter function. So when the user sees the card, the only information that will be shown at first is Name, Age, and birthday. Then, we want to add a filter that allows the user to drill down into more details for each Name by showing additional information such as Position, Email, and Salary.

ColemenWilson

Gothca! Here are the steps:
1. Create a table card and add the fields Name, Age, and Birthday
2. Save and exit the card
3. Click the wrench on the card:

4. Click "Edit Drill Path"

5. Click "Add a view"

6. Repeat step 1 but with the fields you want displayed in the drill down view.

Jez

This works. Thanks a lot! :)