I’m trying to figure out what would be the best visualisation option in Looker for this specific use case (budget and invoicing for projects). In a single viz, I’d like to see:
- Target budget
- Value of work performed
- Actual amount invoiced
In a different dashboard tool I’ve done this using a bar chart (for the value of work performed) with an overlay of shapes to show the target budget and amount invoiced, but Looker does not support this type of chart, unfortunately.
The goal is, in one chart, to view where if we’re on track on the budgeted amount, and whether the actual invoicing is on track with the invoicing that has been performed, and therefore easily spot projects that are over budget or under-invoiced.
The amounts could be individual dimensions (single row), or measures for aggregation.
Any creative ideas? (This can involve a custom vizualisation if you have a code example).