Forum Discussion

PBI5851's avatar
PBI5851
Icon for Helper V rankHelper V
5 years ago

Help on Per Day and Month Calculation

Hello folks ,  Please can you help me resolve the monthly count. The numbers are correct when i display the day, but if i remove the day, the monthly counts are incorrect. For the Data Model, the da...
Need Help
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago

Hi, PBI5851 , I'd create a dimentional table for different factors respective to all rep as follows,

Here's the data model 

and the result

You might want to refer to the attached file for details.

  • PBI5851's avatar
    PBI5851
    Icon for Helper V rankHelper V
    5 years ago

    CNENFRNL . The idea will work, but i dont think i can create a sub-table of drep, because the reps can change frequently and we can have new reps as its a moving list. Is there a way to populate the drep table dynamically.

    • PBI5851's avatar
      PBI5851
      Icon for Helper V rankHelper V
      5 years ago

      CNENFRNL I did try your solution too. But it doesnt work if there are multiple months. If its a single month, it works, but with multiple months, everything shows the same value.