4 Replies Latest reply: Jul 21, 2011 12:42 PM by ggoyal_123 RSS

    Line chart 2 expressions

      Hi All,

       

       

      I have a line chart which has 2 dimensions right now:

      1. date

      2. types of queries (i only want 5 here.. insert, select, update, delete and create)

       

      this graph gives me a total count of these different types of queries.

       

      Now i want to extend this graph into showing me two lines. One which gives me a count of types of queries (which it already is) and the 2nd line should show me a total of all the queries (every type, not only limited to the 5 mentioned above).

       

      I tried a lot of cominations, somehow i cannot get the 2 lines on the same graph.

       

      Thanks.

        • Re: Line chart 2 expressions
          Stefan Wühl

          Hi,

           

          maybe something like

           

          =count( total <date> Queries)

           

          ?

          You might add a {1} if you want to disregard selection also:

          =count({1} total <date> Queries)

           

          Could you post a screenshot? I am curious how a linegraph looks like with that kind of dimension then.

           

          Regards,

          Stefan

           

          P.S:

          At best, you could also post a small application demonstrating your problem, that almost ever helps to get a quick solution.