Thanks - I had a lot of fun making that one. Hope it provides what you need for your analysis. I am beyond intrigued to see the visualization you spent an entire day on. Is this a new Charticulator visual you cooked up in the lab?
- Brian
Thanks - I had a lot of fun making that one. Hope it provides what you need for your analysis. I am beyond intrigued to see the visualization you spent an entire day on. Is this a new Charticulator visual you cooked up in the lab?
@BrianJ
I am just lost in creating own made custom visuals and have been going back and forth to get what I need and have successfully managed to pull off some cool visuals. The best thing that I like about Charticulator visuals is that you can disable the auto-size for axes, the option that I had been looking for in various challenges.
I have been trying to get the visuals similar to Tableau that allow parallel coordinates to design outstanding looking visuals. I hope the Power Bi will give the option to design your own visuals inside the service. Will have to wait till then.
Watching the amazing stuff that you and @datazoe are doing with this tool, it really does make me wonder why Microsoft hasn’t invested more in it, publicized it more, and integrated it with the desktop client? It seems the one area where Tableau still has a substantial advantage over Power BI is in visualizations, and this could really help close that gap.
Have you seen this paper below by the Charticulator developers?
https://www.microsoft.com/en-us/research/uploads/prod/2018/08/Charticulator-InfoVis2018.pdf
In it, they also have a really cool gallery of a dozen custom visuals they designed using Charticulator.
Can’t wait to see your submission for this challenge.
– Brian
@BrianJ
Yes, I did see the paper but still not many material around to learn from. So far what I have noticed is that there is some problem in re-using the custom made visual for a slightly different dataset. This can easily be fixed by Microsoft and I am also surprised why they didn’t invest more after rolling it out.
So far I have tried almost every visual shown in the Charticulator Gallery to see what will work out in the recent challenge.
I hope I can finish the challenge on time
I tried but couldn’t seem to make it work. Attaching the file if anyone can get the unique ranking to work.
Unique Rank.pbix (169.8 KB)
Thanks!
@AntrikshSharma
Wow what kind of a sorcery is this?
It works like a charm
In simple words, in the Bar Chart, A is at top so I want to show the line chart for A only, B for B, C for C etc.
Thanks a lot again for the solution.
@haroonali1000 (or anyone) - this is probably a dumb question - but the due date is 10/25 PST. I’m assuming this is by anytime on Sunday - California time, correct? I wasn’t sure if there was an exact time and just trying to plan accordingly. Thanks,
Tim
My submission for this new challenge, I missed the last one due to personal reasons.
So submitted little early this time. As always, looking for all your views and suggestions.
Link:
Working file attached, so please check and provide your constructive feedbacks.
So much to learn from you all.
EDNA challenge 8_Mohammed Ali.pbix (484.2 KB)
My submission for this new challenge, as always, looking for all your views and suggestions.
EDNA_CHALLENGE_8_JIRA_GIFTED.pbix (327.1 KB)
Hi All.
Here is my submission for eDNA C8.
(Edit: 1. added note after PTW link)
(Edit: 2. added screenshot of SLA supporting table)
Thanks to @datazoe who noticed and commented that the Python Ring Chart was not displaying properly when using PTW; apparently neither R nor Python visuals are supported when using PTW
Here are the notes I kept during development:
Here’s the code for the calculated column:
Status Category =
VAR _DoneList = { "Canceled", "Closed", "Completed", "Done", "Resolved" }
VAR _InProgressList = { "Awaiting Verifier", "In Progress", "Verified", "Waiting for customer", "Waiting for support", "Work in progress" }
VAR _ToDoList = { "Accepted by Assignee", "Awaiting IT Security Course Completion", "Open", "Opened", "Pending", "Waiting for approval" }
RETURN
SWITCH( TRUE(),
'Status'[Status] IN _ToDoList, "To Do",
'Status'[Status] IN _InProgressList, "In Progress",
'Status'[Status] IN _DoneList, "Done",
BLANK()
)
Here’s the code:
Priority =
SWITCH( TRUE(),
Priorities[Description] = "Highest", "P1",
Priorities[Description] = "High", "P2",
Priorities[Description] = "Medium", "P3",
Priorities[Description] = "Low", "P4",
Priorities[Description] = "Minor", "P5",
BLANK()
)
Here’s the code for the calculated column:
Priority Category =
VAR _HighList = { "Highest", "High" }
VAR _MediumList = { "Medium" }
VAR _LowList = { "Low", "Minor" }
RETURN
SWITCH( TRUE(),
Priorities[Description] IN _HighList, "High",
Priorities[Description] IN _MediumList, "Medium",
Priorities[Description] IN _LowList, "Low",
BLANK()
)
– I assigned the types into 3 type categories as and used a calculated column to implement this as follows:
Here’s the code:
Type Category =
VAR _BugList = { "Break/fix Response", "Corrective Action Plan" }
VAR _TrainingList = { "Internal Process", "New User Request" }
VAR _GeneralList = { "POA&M Milestone Subtask", "Service Request", "Service Request with Approvals", "Sub-task", "Task" }
RETURN
SWITCH( TRUE(),
Types[Type] IN _BugList, "Bug",
Types[Type] IN _TrainingList, "Training",
Types[Type] IN _GeneralList, "General",
BLANK()
)
Amazing!
Agreed. This is a phenomenal report – thoughtfully and beautifully designed, with a great depth of analysis. The ring chart really jumps out as a visual element, and as always there is just a treasure chest of techniques to unpack here thanks to your incredible write-up. Also, the analysis page and particularly the issues for follow-up demonstrates so well how the visual analysis drives actionable insight.
A few questions:
Amazing job.
Very impressive Greg. What a reporting app!
Thanks again @EnterpriseDNA for hosting these challenges!
Here is my submission so far:
Edit: I was inspired by @Greg’s circle bars!
Hello EveryOne,
Here is my submission for challenge 8 which I had a lot of fun working on.
Data Model : -
For this challenge I created a Data model which consists of 6 Dimension tables and one Fact table in Power Query. ( I guess I am getting comfortable using Power Query to create a Data
model instead of SQL Server as I did before ).
Dimension Tables : -
The five dimensions were created using distinct values of :-
Projects
Issue Types
Statuses
Assignee
Watchers ( I Unpivoted Watcher_4 , Watcher_5 , Watcher_6 and Watcher_7 and merged them with Watcher and removed duplicates ).
and
Dates ( Thanks @Melissa ) .
Fact Table:-
DAX Calculations:-
Once the Model was created, most of the calculations were not too difficult. But, some of the data needed to be modified in order to make it work.
To verify the validity of the Tickets, based on @haroonali1000 's instruction, I used the following Measure:-
Verifying Tickets = IF (
ISBLANK (
MAXX ( Jira_Tickets, Jira_Tickets[Due Date] ) ),
"Incomplete Ticket",
IF (
MAXX ( Jira_Tickets,
DATEDIFF ( Jira_Tickets[Created], Jira_Tickets[Due Date], DAY )
) < 0,
"Implementation Issues",
"in " & MAXX ( Jira_Tickets,
DATEDIFF ( Jira_Tickets[Created], Jira_Tickets[Due Date], DAY )
) & " Days"
)
)
Then I created a Calculation Group in Tabular Editor to classify each ticket based on the above measure.
E.g. For incomplete tickets, the following DAX calculation was used in Tabular Editor.
CALCULATE (
SELECTEDMEASURE (),
FILTER (
Jira_Tickets,
[Verifying Tickets] = "Incomplete Ticket"
)
)
and the same for Tickets with Implementation Issues and the rest of the Tickets were assumed as Valid Tickets.
I also used Calculation Groups for to merge Statuses: -
E.g. the following Statuses were assumed as Resolved.
CALCULATE (
SELECTEDMEASURE (),
Jira_Tickets[Status] = "Completed"
|| Jira_Tickets[Status] = "Closed"
|| Jira_Tickets[Status] = "Done"
|| Jira_Tickets[Status] = "Resolved"
)
This is the first time I used Calculation Groups and I found them to be very useful ( especially for multiple Time Related DAX Calculations ).
Visualizations :-
For the theme of this Report I used one of Atlassian’s Logo and matching blue colors for most of the Report.
I took a visualization Idea of combining a Column chart and a Matrix to display bars for the months from one of the Top Experts on this forum (Thanks @MudassirAli ) .
Here is a link to the Report:-
P.S. The Decomposition Tree visual on the Summary page is not working on the link above but works on Power BI Services my Work space.
Thanks and Regards,
Nebiyu
@Greg
I love the simplicity in the report, headings and different colors used for different Page Headings of the report. You really are an expert now in using the Smart Narratives.
Ring chart looks really cool and awesome explanation as always.
Great Submission!!
@datazoe Wow for the design especially the navigation panel. What type of Red Color is this? Looks really amazing with Black background.
Great work!!
@MudassirAli This one is again using a template and specifically design / template from `https://www.numerro.io/ so I can’t take credit for the design, just how I applied it. I have been wanting to do a fly out navigation for a while. As I suspect, it’s a little annoying but not overly so :). Using these templates has been really helpful on my quest to make better designed reports overall.
@Neba I really like the look of your report! I am partial to the blue/white/grey a lot (which is why I forced myself to use black/red haha).
I am also liking this combo a lot too: