i think for your charts you wil have to choose if you are going to display total hours or total minutes (easier) as you need to leave it a number value for caluations into the chart.
Here is one way to get what you are looking for.
create one formula for total minutes for the day
//row_minutes
({table.loghours}*60)+{table.logminutes}
create 2 formulas for your row level categorizations (like you already did)
//Bill_grouping
if {table.logreason} in ['MAC','Service','Training'] then 'Billable' else if {table.logreason} in ['Warranty','Lunch'] then 'Installation time' else if {table.logreason} in ['Travel'] then 'Travel Time'
Of course fix the like values to match what you want them to be.
do the same thing for your other categorization need
now you can group your data and insert a chart at any level and get what you want
Group on technician
add a group header1B
insert a chart into GH1B (say a pie chart)
in the data tab for on chnage of use then @Bill_grouping formula field
for show value(s) use the @row_minutes formula set as a SUM.
If you want to show totals for each sub category you can use a crosstab
it can be placed in any header or footer
do not insert any column (unless you want to - like a day breakout)
for row insert your other category formula field
for summarized field use the @row_minutes formula field again set to a SUM
if you want to convert this to display HH:MM
right click on the summarized field in the ct
select format field
select common tab
select display string formula and use this to convert ho it is displayed
totext(floor(currentfieldvalue/60),0,'00') + ':' + totext(remainder(currentfieldvalue,60),0,'00')
Edited by DBlank - 09 Nov 2011 at 4:14am
IP Logged
