Forum Discussion

Helper I

2 years ago

Objectives / Production

Hello, I need to carry out a production comparison with the objectives. I have the 2 tables in joint. Problem, when I reread the "DAY" column to the "accompanying date" column, I only have 0.6 to ...

Need Help

Tutorial Requests

lbendlin

Super User

2 years ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

psorel

Helper I

2 years ago

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

lbendlin

Super User

2 years ago

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 ?

psorel
Helper I
2 years ago
The duration values in accompanying date is the production, i have to sum for each week/month/year the production of each worker.
Sorry for the mistake TEAM BLUE and Green are sub-teams of team 1. I just need an exemple of my need for team 1 ( sub team Blue and green)
I don't know which visual is more appropriated for my need a graph with Date hierarchy and a column objectivs / Realised for each worker or a table because i can have more than 50 workers on each team. Maybe i have to separate Teams or sub teams in different visuals. Or juste date hierarchy and use a filter for each worker/team.

I hope you will understand my need. Thank you
- lbendlin
  Super User
  2 years ago
  Please provide sample data that fully covers your issue.
  Please show the expected outcome based on the sample data you provided.

Forum Discussion

Objectives / Production

Related content

Production Lessons

Filters issues in visual objects

Error - Object reference not set to an instance of an object

On-Object interation

Lock Objects