Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Which Measure

Hey guys,

 

I'm a bit stuck.

 

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

Day & Timemachine Numberpieces
22.01.2022 13:5435687412547
22.01.2022 22:0165874521587
20.01.2022 12:543568745487
18.01.2022 00:1035687414785

 

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

Need Help

5 Replies

  • serpiva64's avatar
    serpiva64
    Solution Sage
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        serpiva64
        Solution Sage
        4 years ago

        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