How to set meter diagram based on value from query

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

    Hi,
    As a newbee on myDBR, I have a problem that I cant find a solution for.

    I have a meter chart that should visualize if a person has reached todays target. So the scale should be the target+x%. I can get it to work if I hard code the scale with.

    select 'dbr.chart.options', 'scale', 0, (30), 5;

    , but how do I make the scale based on a value from the database?

    Regards
    Fredrik T

  2. myDBR Team, Key Master

    Frederik,
    perfect timing to create meter charts. We just released a version which supports new ChartDirector 6.0 meter charts. See examples in the demo.

    You can set the scale from DB just by quering the value from DB instead of using constants:

    select 'dbr.chart.options', 'scale', s.minimum, s.maximum, s.step
    from scale_values s;

    --
    myDBR Team

  3. Fredrik Terent, Member

    Ahha, of course. Thanks


Reply

You must log in to post.