Widget: Accidents on a certain day compared to the same day in previous years

[galraij]

Name Accidents on a certain day compared to the same day in previous years

Title

Visualization

Visualization explanation present stack bar with different severities

Use case When this infographic should be displayed

SQL query Sql clause and usage guidance. In addition to query, detail which parameters should be modified when executing it and which output fields are language specific When creating the query and filtering CBS data - it's better to use the numeric values of the categorical fields (accident_severity = 1 is better than accident_severity_hebrew = 'תאונה קטלנית'). For code redeablity - one can create constants and dictionaries.

Additional context

• Definition will be used by BE team to generate a Json response to FE
• Definition will be provided by Data team, after internal review
• Definition will be written in English and should use language agnostic definitions and data structures (e.g. SQL columns) as much as possible.

[ChayneAzriel]

created a redash queries for this one, with my changes for this infographic

redash query 2

edited by @atalyaalon 's commment.

[atalyaalon]

@ChayneAzriel looks very good! I suggest the following:

1. Bar graph:
   • Add the killed count on both parts or bar.
   • I think that the dashed line should be in the top (including September)
2. Line graph: change the direction of the x-axis (2008 should be on the left)

Also - I suggest separating it to 2 different Widgets - and creating an issue for each one - one graph per Widget.

[ChayneAzriel]

above are the updated graphs according to your comments. if there are no other changes, we can open another widget and move on?

[atalyaalon]

@ChayneAzriel Yes please :)