Forum Discussion
MCFNeil
8 years agoQrew Captain
Just a note on side by side bar graphs.
It compares the the same data, but is classified in a different category.
For example,
So if your dollar value was in the same field, but you classified the record as revenue or expense, you could then build a side-by-side bar graph. One bar would be expense and the other revenue.
In your case, you'd have to have your device records all on the same table, with them classified as assigned, or available.
In this case it still wouldn't show a total allocated vs. actual, but rather it will show assigned vs available.
Overall, it sounds like you might need to re-architect your app/data a little bit.
It compares the the same data, but is classified in a different category.
For example,
So if your dollar value was in the same field, but you classified the record as revenue or expense, you could then build a side-by-side bar graph. One bar would be expense and the other revenue.
In your case, you'd have to have your device records all on the same table, with them classified as assigned, or available.
In this case it still wouldn't show a total allocated vs. actual, but rather it will show assigned vs available.
Overall, it sounds like you might need to re-architect your app/data a little bit.