Forum Discussion
Which Measure
Hey,
yeah those datapoints are just some examples, for a huge database.
i tried doing it your way with my internal dataset but i still dont get the actual pieces number i get the quantity how often they appear.
I there a mistake i make?
which shows like this
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