Forum Discussion
Solution SageBest visual to choose
I have the following data, which contains Vehicle Service information. I am able to get Individual summary with totals, If I use table. But, struggling to get the same information in charts.
I want to see the below criteria in a visual other than table/matrix. (stacked chart may be?).
1. How many vehicles serviced by each Person did on each date.
2. Count of each vehicle type (like Jeep -2, Mini Bus -1 ) by Individual on each date.
Here is the data:
Which chart is suitabe in this situation where you need to show All Vehicle serviced by a individual on each date and count of each vehicle serviced by individual on each day.?
3 Replies
- TomMartens
Super User
Hey,
my current favorite for visualizing multi-variate categorical variables is the custom visual "Infographic Designer" that you can find here
On its support page there are detailed explanations - look for small multiples.
Hi rocky09,
You can use matrix visual and drag Date and Services to Rows field, vehicle to Columns and Values field, then you will get what you want.
Regards,
Xiaoxin Sheng- Phil_Seamark
Microsoft Employee
You could always use the Bar visual but use a hierarchy on the Axis
one that goes ServiceBy/Vehicle and then a second chart the other way around. Drill down fully and you will see a nice graphical depiction of your data.
