Forum Discussion
Which Measure
If you try to post some more data (not too many) and scecify what you should want to get from them i think the can get the result
Hey serpiva64
sorry for anwsering now,
I wasn't working the last days.
Here is some more data:
I cutted out some data between the month, so you have data from different month and not only data from one month.
As you can see for every WZNummer individuals WZLfD Numbers
| WZNummer | Erstellt | WZLfD | WZAktHubzahl | WZGesamtHubzahl |
| 32568266 | 31-Jan-22 | 1 | 22484 | 22484 |
| 32568266 | 31-Jan-22 | 2 | 22484 | 22484 |
| 32568266 | 31-Jan-22 | 1 | 68955 | 68955 |
| 32568266 | 31-Jan-22 | 3 | 82524 | 82524 |
| 32568255 | 31-Jan-22 | 1 | 22484 | 55147 |
| 32568255 | 31-Jan-22 | 1 | 0 | 55147 |
| 32568255 | 31-Jan-22 | 2 | 22484 | 55147 |
| 32568255 | 31-Jan-22 | 2 | 0 | 55147 |
| 32568288 | 28-Jan-22 | 1 | 0 | 29976 |
| 32568266 | 28-Jan-22 | 2 | 15527 | 15527 |
| 32568266 | 28-Jan-22 | 3 | 35306 | 35306 |
| 32568288 | 28-Jan-22 | 1 | 15527 | 29976 |
| 32568288 | 28-Jan-22 | 2 | 15527 | 29976 |
| 32568288 | 28-Jan-22 | 2 | 0 | 29976 |
| 32568266 | 26-Jan-22 | 4 | 11291 | 11291 |
| 32568266 | 26-Jan-22 | 3 | 13531 | 46521 |
| 32568266 | 26-Jan-22 | 1 | 12391 | 12391 |
| 32568288 | 26-Jan-22 | 2 | 0 | 29976 |
| 32568288 | 26-Jan-22 | 2 | 12391 | 29976 |
| 32568288 | 26-Jan-22 | 1 | 0 | 29976 |
| 32568288 | 26-Jan-22 | 1 | 12391 | 29976 |
| 32568266 | 26-Jan-22 | 4 | 13531 | 28780 |
| 32568266 | 25-Jan-22 | 3 | 400 | 400 |
| 32568263 | 25-Jan-22 | 4 | 55995 | 55995 |
| 32568266 | 25-Jan-22 | 2 | 60040 | 60040 |
| 32568266 | 25-Jan-22 | 4 | 68961 | 68961 |
| 32568255 | 25-Jan-22 | 2 | 0 | 55147 |
| 32568255 | 25-Jan-22 | 2 | 24313 | 55147 |
| 32568255 | 25-Jan-22 | 1 | 24313 | 55147 |
| 32568255 | 25-Jan-22 | 1 | 0 | 55147 |
| 32568266 | 24-Jan-22 | 1 | 2240 | 35230 |
| 32568266 | 24-Jan-22 | 3 | 23225 | 23225 |
| 32568266 | 24-Jan-22 | 1 | 10616 | 10616 |
| 32568266 | 24-Jan-22 | 2 | 12502 | 61002 |
| 32568266 | 24-Jan-22 | 1 | 12502 | 58209 |
| 32568266 | 24-Jan-22 | 4 | 19742 | 19742 |
| 32568266 | 24-Jan-22 | 2 | 19742 | 19742 |
| 32568255 | 24-Jan-22 | 2 | 12502 | 90796 |
| 32568255 | 24-Jan-22 | 1 | 12502 | 90796 |
| 32568288 | 21-Jan-22 | 2 | 2058 | 29976 |
| 32568288 | 21-Jan-22 | 1 | 0 | 29976 |
| 32568288 | 21-Jan-22 | 1 | 2058 | 29976 |
| 32568288 | 21-Jan-22 | 2 | 0 | 29976 |
| 32568266 | 21-Jan-22 | 2 | 1140 | 16389 |
| 32568288 | 21-Jan-22 | 1 | 0 | 72744 |
| 32568266 | 21-Jan-22 | 3 | 37260 | 37260 |
| 32568288 | 21-Jan-22 | 1 | 5423 | 72744 |
| 32568288 | 21-Jan-22 | 2 | 0 | 72744 |
| 32568288 | 21-Jan-22 | 2 | 5423 | 72744 |
| 32568288 | 09-Dez-21 | 2 | 0 | 157311 |
| 32568288 | 09-Dez-21 | 1 | 10136 | 157311 |
| 32568288 | 09-Dez-21 | 2 | 10136 | 157311 |
| 32568266 | 09-Dez-21 | 1 | 10136 | 10136 |
| 32568266 | 09-Dez-21 | 2 | 10136 | 10136 |
| 32568266 | 09-Dez-21 | 3 | 10136 | 10136 |
| 32568288 | 09-Dez-21 | 1 | 0 | 157311 |
| 32568266 | 09-Dez-21 | 4 | 10136 | 10136 |
| 32568255 | 09-Dez-21 | 1 | 1200 | 55147 |
| 32568255 | 09-Dez-21 | 2 | 1200 | 55147 |
| 32568255 | 08-Dez-21 | 1 | 650 | 55147 |
| 32568255 | 08-Dez-21 | 2 | 0 | 55147 |
| 32568255 | 08-Dez-21 | 1 | 0 | 55147 |
| 32568255 | 08-Dez-21 | 2 | 650 | 55147 |
| 32568288 | 08-Dez-21 | 1 | 21000 | 157311 |
| 32568288 | 08-Dez-21 | 2 | 21000 | 157311 |
| 32568288 | 08-Dez-21 | 2 | 0 | 157311 |
| 32568266 | 08-Dez-21 | 5 | 21000 | 21000 |
| 32568266 | 08-Dez-21 | 2 | 43591 | 64115 |
| 32568288 | 08-Dez-21 | 1 | 0 | 157311 |
| 32568266 | 08-Dez-21 | 2 | 29961 | 36418 |
| 32568266 | 08-Dez-21 | 4 | 29961 | 36418 |
| 32568288 | 01-Dez-21 | 1 | 0 | 157311 |
| 32568288 | 01-Dez-21 | 2 | 8800 | 157311 |
| 32568288 | 01-Dez-21 | 2 | 0 | 157311 |
| 32568266 | 30-Nov-21 | 3 | 7360 | 20240 |
| 32568266 | 30-Nov-21 | 4 | 7360 | 20240 |
| 32568255 | 30-Nov-21 | 2 | 0 | 82291 |
| 32568255 | 30-Nov-21 | 1 | 0 | 82291 |
| 32568255 | 30-Nov-21 | 1 | 2700 | 82291 |
| 32568255 | 30-Nov-21 | 2 | 2700 | 82291 |
| 32568288 | 30-Nov-21 | 1 | 7500 | 157311 |
| 32568288 | 30-Nov-21 | 2 | 0 | 157311 |
| 32568288 | 30-Nov-21 | 2 | 7500 | 157311 |
| 32568288 | 30-Nov-21 | 1 | 0 | 157311 |
| 32568255 | 30-Nov-21 | 1 | 0 | 82291 |
| 32568255 | 30-Nov-21 | 1 | 4660 | 82291 |
| 32568255 | 30-Nov-21 | 2 | 4660 | 82291 |
| 32568255 | 30-Nov-21 | 2 | 0 | 82291 |
| 32568288 | 29-Nov-21 | 2 | 9346 | 157311 |
| 32568288 | 29-Nov-21 | 1 | 9346 | 157311 |
| 32568288 | 29-Nov-21 | 1 | 0 | 157311 |
| 32568288 | 29-Nov-21 | 2 | 0 | 157311 |
| 32568255 | 29-Nov-21 | 1 | 14200 | 82291 |
| 32568255 | 29-Nov-21 | 1 | 0 | 82291 |
| 32568255 | 29-Nov-21 | 2 | 0 | 82291 |
| 32568266 | 29-Nov-21 | 2 | 14200 | 45287 |
| 32568255 | 29-Nov-21 | 2 | 14200 | 82291 |
| 32568266 | 29-Nov-21 | 1 | 14200 | 45287 |
Now i want to create two visuals.
First Line Chart
Show me the "AktHubzahl" for each "WZNummer" over time ("Erstellt")
and the second Line chart
Show me the "GesamtHubzahl" for each "WZNummer" over time ("Erstellt").
On my Visual page i added a slicer where i can Select the different "WZNummer" and the "WZLfD" so i can filter my visuals if any1 wants to see jsut some specific machine parts.
Maybe u can have a look at it and tell me what im doing wrong.
Thank You
Hi,
sorry but i can't understand the content of columns so it is not easy to help
This is what i get