Which Measure

[Anonymous]

Hey guys,

I'm a bit stuck.

I have a table in which there are some production values.

Day & Time	machine Number	pieces
22.01.2022 13:54	356874	12547
22.01.2022 22:01	658745	21587
20.01.2022 12:54	356874	5487
18.01.2022 00:10	356874	14785

Now i want to show those values in a line chart, which should look like: 

Showing pieces /day for each machine Number in a seperate line. x-Axis is in days/month y-Axis is in pieces

When i try to move the column into my line chart in only get the total sum of pieces and not the pieces of each day.

I assume i need a measure to get my data filterd correctly.

Would be great if some1 can help me.

Sincerely

Jonas

[serpiva64]

Hi,

try this way

(i have duplicated, changing only the month,the data you provided because they were in a single month)

You obtain something like this

If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !

[Anonymous]

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

[serpiva64]

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

[Anonymous]

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 

[serpiva64]

Hi,

sorry but i can't understand the content of columns so it is not easy to help

This is what i get