Forum Discussion

ls784's avatar
ls784
Helper I
3 years ago
Solved

Target Totals

Hi, I'm new to this and thought this would be a simple one but I haven't been able to figure it out.

 

I have my data for tasks completed by workers, and a separate Target spreadsheet which shows the monthly target for each worker. I'm trying to create a table to compare monthly data to the target and as a percentage, however the targets aren't totalling if I choose to look at multiple months.

 

What I need is a table/matrix that shows the totals per month, but also shows me the totals dependant on the time period I've chosen to look at. Is there a way of doing this or do I need to store the target data differently? I was also wondering if it was possible to have it automatically default to only show you the previous 3 months of data based on todays date?

Targets for "Time associated" table:

Name Target per month
Worker 1 0
Worker 2 1000
Worker 3 500
Worker 4 0
Worker 5 0
Worker 6 0
Worker 7 0
Worker 8 1200
Worker 9 1000

 

Example of Data: 

Completed ByDate Time Associated
Worker 229/06/2023 0
Worker 629/06/2023 0
Worker 629/06/2023 15
Worker 929/06/2023 60
Worker 927/06/2023 10
Worker 227/06/2023 60
Worker 426/06/2023 0
Worker 825/06/2023 10
Worker 825/06/2023 20
Worker 825/06/2023 10
Worker 825/06/2023 20
Worker 825/06/2023 15
Worker 825/06/2023 15
Worker 825/06/2023 10
Worker 825/06/2023 25
Worker 825/06/2023 15
Worker 825/06/2023 20
Worker 825/06/2023 20
Worker 223/06/2023 30
Worker 223/06/2023 45
Worker 223/06/2023 180
Worker 123/06/2023 0
Worker 122/06/2023 0
Worker 121/06/2023 0
Worker 921/06/2023 0
Worker 920/06/2023 0
Worker 920/06/2023 0
Worker 119/06/2023 0

 

Any help would be really appreciated.

Need Help
  • mlsx4's avatar
    mlsx4
    3 years ago

    Hi ls784 

    For showing the value according to the month, I always use a kind of multiplicator, which later on multiply to the final result:

    var multiplicator= DISTINCTCOUNT('TABLA DE FECHAS'[Mes])
return result*multiplicator



3 Replies