Results 1 to 5 of 5
  1. #1
    Newbie
    Join Date
    Apr 2016
    Posts
    5

    Default 7 day dashboard reports.

    I have made a daily Bandwidth report in MB using the following

    Code:
    round(coalesce(sum(p2s_bytes), 0) / (1024*60*10),1) as sent
    round(coalesce(sum(s2p_bytes), 0) / (1024*60*10),1) as received
    This seems to be working well but when I add it to the dashboard it only shows the last 24 hours. I would like it to show the last 7 days. Is this possible?

    P.S. I pasted the code I used to make the report because I truly do not know what I am doing and would love some feedback.

  2. #2
    Untangler jcoffin's Avatar
    Join Date
    Aug 2008
    Location
    Sunnyvale, CA
    Posts
    5,757

    Default

    Change the timeframe in the widget settings.
    Attention: Support and help on the Untangle Forums is provided by
    volunteers and community members like yourself.
    If you need Untangle support please call or email support@untangle.com

  3. #3
    Untangle Junkie dmorris's Avatar
    Join Date
    Nov 2006
    Location
    San Carlos, CA
    Posts
    15,903

    Default

    the dashboard shows the last hour only (this is for performance reasons)
    Last edited by dmorris; 03-20-2017 at 11:16 AM.
    Attention: Support and help on the Untangle Forums is provided by volunteers and community members like yourself.
    If you need Untangle support please call or email support@untangle.com

  4. #4
    Newbie
    Join Date
    Apr 2016
    Posts
    5

    Default

    Quote Originally Posted by jcoffin
    Change the timeframe in the widget settings.
    I think this would display the total usage of the last week correct? I could see how this might be a compromise seeing as showing the daily is not possible.

    Quote Originally Posted by dmorris View Post
    the dashboard shows the last hour only (this is for performance reasons)
    ok thanks I will stop looking for a way to do this.

    I have noticed that the database query can take a very long time. Is this something that is likely to change in the future?

  5. #5
    Untangle Junkie dmorris's Avatar
    Join Date
    Nov 2006
    Location
    San Carlos, CA
    Posts
    15,903

    Default

    I mean - you can change it now, but to no more than 24 hours.

    Might we change it? We might, but the problem with allowing values that are dangerous is that users change immediately to the most dangerous setting allowed.
    Attention: Support and help on the Untangle Forums is provided by volunteers and community members like yourself.
    If you need Untangle support please call or email support@untangle.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

SEO by vBSEO 3.6.0 PL2