Get your own customer support community

Recent activity

Subscribe to this feed
  • question

    Bryan Crotaz asked a question in CustomWare on January 04, 2010 17:31:

    Bryan Crotaz
    Failure of set-data and grouping reporter - bug?
    Grouping reporter gives zero result:

    {table-data:DailyTimesheet}
    || Day || Start || Finish || Minutes || Location ||
    | {date-data:Date|format=dd-MMM-yyyy|required=true|}today{date-data} | {date-data:Start|format=HH:mm|required=true|}now{date-data} | {date-data:Finish|format=HH:mm|}{date-data} | {set-data:Minutes}{report-on:injected=true}{report-info:data:Finish > date:milliseconds > - %data:Start > date:milliseconds% > / 60000}{report-on}{set-data} | {list-data:Location}{list-option}Office{list-option}{list-option}Home{list-option}{list-option}Travelling{list-option}{list-data} |
    {table-data}

    h2. Summary

    {report-table}
    {grouping-reporter:key=data:Date > date:d MMMM yyyy|as=Day}
    {grouping-stats:data:Minutes|as=MinutesData}

    {local-reporter:data:DailyTimesheet}
    {date-sort:data:Date}
    {local-reporter}
    {grouping-reporter}

    {report-column:title=Date}{report-info:grouped:Day}{report-column}
    {report-column:title=Total Mins}{report-info:grouped:MinutesData > stats:sum|format=#.#}{report-column}

    {report-empty}_No data has been entered yet._{report-empty}

    {report-table}

    1. The total mins column shows 0 regardless of input data
    2. How can I change the total mins to divide by 60 and show hours with one decimal place?
  • question

    Bryan Crotaz asked a question in CustomWare on January 04, 2010 16:40:

    Bryan Crotaz
    How to do time difference with report-on (or similar)?
    I have two time columns in a timesheet {table-data} row, Start and Finish.
    I want to add a third column showing hours (Finish-Start). I've used a previous answer to do it with {report-on} and divide by milliseconds, but it doesn't seem to allow an result other than integer. I'd like to show one decimal place. Is there a way to do this?