Level 1 Model Building EMP02 Employee Expenses Module Dimensions

Hello,

 

I am currently in the process of going through the Level 1 Model Building course. In section 10, I was instructed to create a module with the dimensions: #E2 Employees, Active?, Time

 

The problem is that I don't see Active? anywhere in my model, except maybe as a line item in a separate list or module. Regardless, it isn't an option on the list when creating the module. Where would I find this, or how do I add it?

Tagged:

Best Answer

  • JaredDolich
    Answer ✓

    @ws696201 

    Very common question. Thanks for asking.

    What you are referring to is what's called a list subset.

    the benefits of a list subset is that you can narrow the list to a smaller set of list items. This reduces your overall module size as well as make it easier to work with.

     

    In the #E2 Employee List you can find the list subset.

    EMP02A.png

     

    When you build your module you'll drag this list subset into your pivot.

    EMP02B.png

Answers

  • 10.2.5 Activity Screenshot 2023-10-12 180510.png 10.2.6 Activity Screenshot 2023-10-12 180040.png 10.2.6 Activity Screenshot 2023-10-12 180406.png 10.2.6 Activity Screenshot 2023-10-12 180610.png

    I'm not sure why the formula isn't populating the data for those selections within activity 10.2.6. Any suggestions or will there be an additional input for this data in another lesson?