Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have been trying to find a chart (stacked bar chart, pie-chart, or really anything) that would show the average values for two dimensions (let's say Avg(ETIME) = 10, and Avg(ITIME) = 5) along with the total of both in one graphic. Or a marker in the Combo Chart would work if it could display the value. The closest I've been able to get is a regular bar chart using a new field for the total (E+ITIME) that shows all three individually but this doesn't meet the requirements. Thanks.
How about rearranging your data into a table with a dimension field that has ETIME and ITIME as possible values and their data in a data field?
Your could then have a Combo Chart with the dimension field as dimension and two measures being sum(data) and avg(data).
Thanks for the reply but I'm not sure I understand. Let's say I have this simplified table.
Item / ETIME/ ITIME
ITEM1 / 8 / 3
ITEM2 / 10 / 5
ITEM3 / 12 / 7
What would I need to do? Thanks again!
Using your sample data, table like the following
Item / TimeType / Value
ITEM1 / ETIME / 8
ITEM1 / ITIME / 3
ITEM2 / ETIME / 10
ITEM2 / ITIME / 5
ITEM3 / ETIME / 12
ITEM3 / ITIME / 7
Then TimeType as a dimension (Item as well?) and sum(Value) and Avg(Value) as Measures.