Jump to content
  • 0

Line Chart with 2 Different Size Series



I have two tables, each has a column called Comp_ID. When filtering by Comp_ID, table 1 has 127 records and Table 2 has 4 records.

Here are snippets of each table:

Table 1


Table 2


I want to plot these on a single chart with Loss on the x-axis and Probability (Acceptable_P and Prob_Inherent) on the y-axis.

I created a view with an inner join on Comp_ID. When I build my datapage I get 4 instances of the curve for the table with the 127 records and a step chart for the 4 record table.


However, if I chart these individually I get the nice curves as expected.

I can do this in Excel easily but struggling with building this chart in Caspio, TIA.

This is the screenshot from Excel - 


Edited by emarchewka
Clarification with images
Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...