2 Replies Latest reply on Jan 11, 2013 9:32 AM by mohen leo

    Color coding combined measure values in a bar graph

    mohen leo



      I have data of labor estimates and actual billed hours (regular and overtime) for a number of tasks in categories.


      I would like to compare the sum of the total billed hours to the sum of estimates by categories, while also displaying how much of the total hours was overtime vs. regular time.


      I can obviously create a calculated field "Billed (total)" for the total time:


      and then display all four measure values in a bar graph:


      but this looks kind of clunky and what I'd really like is to just show the total as one bar, but use color to display the portion that was overtime vs regular time.


      like in this quick photoshop mock-up:


      It seems very basic, but I can't figure out how to do it. I've done similar things using groups on dimensions, but don't know how to apply it to measures.


      Is it possible?


      I've attached a standalone workbook with the data.