I am trying to get a graphs counting values, my dimension is dates, each date is repeted a lot of time, en the value to count is Qty Pickeadores. After count values, I need divided the days of the month (but using my calendar no the regular calendar). I am using a networkdays to count the days.
Sure, I want to do a graph with the below values, these values are getting from the data contain the the excel file KPI almacén Arieli2 tab picks per day.
If I created a pivot table in excel I got below result that it is the result that I need graph, but I am not sure with I am getting the values included in the graph attached. I guess it is because I have field with the same (Creation date for kitting time and for picks per day), so I created I new field called New Creation date but I still have the same issue. I am not sure how can I solved?