Problem with hsum in crosstabulation on time field.

(5 posts) (2 voices)
  • Started by Fredrik Terent
  • Latest reply from Fredrik Terent
  1. Fredrik Terent, Member

    Hi,
    I have a problem with a summary of an time field.

    The query returns a field as CAST(IFNULL(Pho.tid,0) as time) as '#{Talk_time}[Samtalstid]'
    I specify the column style with SELECT 'dbr.colstyle', '[Samtalstid]', 'hh:mm:ss';

    The cross tabulation is done by date and as long as I only chooses 1 day, the hsum are presented in a time format, but as soon as I have 2 or more days, then te hsum only shows an integer...

    What am I doing wrong?

    Regards Fredrik

  2. myDBR Team, Key Master

    Fredrik,
    The hsum does not yet support time datatype for calculation, but if you leave out the time conversion (cast) and just select seconds, the 'hh:mm:ss'-colstyle will take care of the conversion and will show you the seconds formatted as time.

    --
    myDBR Team

  3. Fredrik Terent, Member

    Thanks, it works in the

    normal
    columns, but still not in the hsum. Do I need to specify the columnstyle in any way for the hsum?

  4. myDBR Team, Key Master

    Fredrik,
    make sure you are running the latest build.

    --
    myDBR Team

  5. Fredrik Terent, Member

    It works (I had a SECS_TO_TIME) in a temporary table, that caused me the problem.

    Thanks for good support!


Reply

You must log in to post.