Forum Discussion
Objectives / Production
Hi lbendlin
PBIX file and Xlsx/CSV are not supported so the first table with Productin of different workers in different teams.
| WORKER | Accompanying Date | Duration | TEAM |
| A | 01/01/2023 | 3 | BLUE |
| A | 05/02/2023 | 4 | BLUE |
| A | 06/05/2023 | 2 | BLUE |
| A | 07/07/2023 | 0,5 | BLUE |
| B | 01/01/2023 | 3 | BLUE |
| B | 05/03/2023 | 4 | BLUE |
| B | 06/05/2023 | 2 | BLUE |
| B | 07/07/2023 | 0,5 | BLUE |
| C | 01/01/2023 | 4 | GREEN |
| C | 02/01/2023 | 4 | GREEN |
| C | 03/05/2023 | 2 | GREEN |
| C | 07/07/2023 | 0,5 | GREEN |
| D | 01/01/2023 | 3 | GREEN |
| D | 05/02/2023 | 4 | GREEN |
| D | 06/05/2023 | 2 | GREEN |
| D | 07/07/2023 | 0,5 | GREEN |
2nd Table with the objectivs with working days :
| Date | Objectiv Team1 | Objectiv Team2 | Working days Teams 1 | Working days Teams 2 |
| 01/01/2023 | 0,6 | 0,8 | ||
| 02/01/2023 | 0,6 | 0,8 | 0,6 | 0,8 |
| 03/01/2023 | 0,6 | 0,8 | 0,6 | 0,8 |
| 04/01/2023 | 0,6 | 0,8 | 0,6 | 0,8 |
| 05/01/2023 | 0,6 | 0,8 | 0,6 | 0,8 |
| 06/01/2023 | 0,6 | 0,8 | 0,6 | 0,8 |
| 07/01/2023 | 0,6 | 0,8 | ||
| 08/01/2023 | 0,6 | 0,8 | ||
| 09/01/2023 | 0,6 | 0,8 | 0,6 | 0,8 |
| 10/01/2023 | 0,6 | 0,8 | 0,6 | 0,8 |
| 11/01/2023 | 0,6 | 0,8 | 0,6 | 0,8 |
| 12/01/2023 | 0,6 | 0,8 | 0,6 | 0,8 |
| 13/01/2023 | 0,6 | 0,8 | 0,6 | 0,8 |
| 14/01/2023 | 0,6 | 0,8 | ||
| 15/01/2023 | 0,6 | 0,8 | ||
| 16/01/2023 | 0,6 | 0,8 | 0,6 | 0,8 |
| 17/01/2023 | 0,6 | 0,8 | 0,6 | 0,8 |
| 18/01/2023 | 0,6 | 0,8 | 0,6 | 0,8 |
| 19/01/2023 | 0,6 | 0,8 | 0,6 | 0,8 |
| 20/01/2023 | 0,6 | 0,8 | 0,6 | 0,8 |
| 21/01/2023 | 0,6 | 0,8 | ||
| 22/01/2023 | 0,6 | 0,8 | ||
| 23/01/2023 | 0,6 | 0,8 | 0,6 | 0,8 |
| 24/01/2023 | 0,6 | 0,8 | 0,6 | 0,8 |
| 25/01/2023 | 0,6 | 0,8 | 0,6 | 0,8 |
| 26/01/2023 | 0,6 | 0,8 | 0,6 | 0,8 |
| 27/01/2023 | 0,6 | 0,8 | 0,6 | 0,8 |
| 28/01/2023 | 0,6 | 0,8 | ||
| 29/01/2023 | 0,6 | 0,8 | ||
| 30/01/2023 | 0,6 | 0,8 | 0,6 | 0,8 |
| 31/01/2023 | 0,6 | 0,8 | 0,6 | 0,8 |
| 01/02/2023 | 0,6 | 0,8 | ||
| 02/02/2023 | 0,6 | 0,8 | ||
| 03/02/2023 | 0,6 | 0,8 | ||
| 04/02/2023 | 0,6 | 0,8 | ||
| 05/02/2023 | 0,6 | 0,8 | ||
| 06/02/2023 | 0,6 | 0,8 | ||
| 07/02/2023 | 0,6 | 0,8 | ||
| 08/02/2023 | 0,6 | 0,8 | ||
| 09/02/2023 | 0,6 | 0,8 | ||
| 10/02/2023 | 0,6 | 0,8 | ||
| 12/02/2023 | 0,6 | 0,8 | ||
| 13/02/2023 | 0,6 | 0,8 |
I would like a table or matrix visual with all the years/months/week ( with and without production) with columns Objectivs and production of each teams/workers. I don't know if i can add hierarchy date at the same time in the visual. Maybe date filters are better.
One more problem, objectivs are not multiplicated by the number of workers on the periode. In january the objectiv is 13,80 * NB of workers
Thanks
Your Objectives table is not in a usable format. The columns are grouped, the column names are inconsistent, and some values have leading spaces. Here is the transform required to bring it into usable format:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("jdRRCoUgFIThrVx8Fq7OKau1RPvfRtqLIhz8ocjgA3GG432HlP/1UZKFGH4plvpJ8Ww/3/vEajSYkfT1x4yxzdtxcjt0BboDnPQE5mL75QSd28DkBJ1B5/bQz5rdDgYD889u/pNzO5gc7EGwB4FJkNvBYGD+gnMgOAeCPQj2IDALcjvoxmD+Bueg3VgCN9bSGDAbMDswBZgDmBOYa23a3bQ0IMO8yvB5AQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t, #" Objectiv Team1" = _t, #"Objectiv Team2" = _t, #"Working days Teams 1" = _t, #"Working days Teams 2" = _t]),
#"Renamed Columns" = Table.RenameColumns(Source,{{"Working days Teams 1", "Working days Team1"}, {"Working days Teams 2", "Working days Team2"}}),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Renamed Columns", {"Date"}, "Attribute", "Value"),
#"Trimmed Text" = Table.TransformColumns(#"Unpivoted Other Columns",{{"Attribute", Text.Trim, type text}}),
#"Split Column by Character Transition" = Table.SplitColumn(#"Trimmed Text", "Attribute", Splitter.SplitTextByCharacterTransition((c) => not List.Contains({"0".."9"}, c), {"0".."9"}), {"Attribute.1", "Team"}),
#"Pivoted Column" = Table.Pivot(#"Split Column by Character Transition", List.Distinct(#"Split Column by Character Transition"[Attribute.1]), "Attribute.1", "Value"),
#"Changed Type" = Table.TransformColumnTypes(#"Pivoted Column",{{"Date", type date}, {"Objectiv Team", type number}, {"Working days Team", type number}},"nl")
in
#"Changed Type"
I don't understand where the duration value comes into play. Can you please elaborate? How do you correlate teams 1 and 2 with teams BLUE and GREEN ?