Morning all,
So I am trying to create a dashboard that shows two things:
1. Mileage of a vehicle by vehicle ID, by org and by month, by org - just a simple line chart will work.
* I created an LOD for this = LOD Mileage.
2. The more challenging part that I am dealing with is vizing the overall month to month cost of the vehicle and being able to show the detail of the sales code.
The sales code is a code that parses out the overall cost. So one could be a fuel surcharge or maybe an accident repair. This way the accountant types can have a detail of what different type of charges made up the whole monthly charge.
I am thinking that the viz should look something like this but I don't know how to do this:
Or perhaps you have another idea that would work better.
Again, I am trying to look at this viz in two ways - one is by vehicle ID and the other is "rolled up" to just an organization level.
Thank you,
Scott
hi see the attached
this will do what you want - hope the actual data has more differentiation between the monthly A and X costs
this is the total by month all GSA cost
and this is the breakout by sales code
Your real data will show some separation
also the first question is
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
