Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Attached is spreadsheet of sample data called “Ticket Data.” I really need someone’s help to learn how to write the code to fill this table based “Opened” date and Employee. For EVERY day I need to have a total number of tickets opened by each employee. As you can see from the sample data, an employee may not open a ticket every day but I still need to have every employee represented for each day even if their total is ZERO. I am thinking I need a separate table of active employees, which I have attached as well called “Employees.” However, I have no idea where to start in order to get the data I need. Once I have this then I will produce a bar/line chart combo where the bars represent tickets opened by each employee by date with the line above the bars representing total tickets opened by date. Can anyone please assist me in what is needed to fill this table with the data I need?
You may try Show items with no data and take a look at the posts below.
Sorry but your suggeestions did not work. As a matter of fact, the first link to the first post you provided produces the same combo graph I have now. BUMMER. I hope someone out there has other suggestions.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |