Jump to content
  • 0

Line Chart with 2 Different Size Series


emarchewka

Question

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

image.png.5b1334b07d3dd32b573d915f52e83337.png

Table 2

image.png.a1a2e728616ca457fb60fe76a4a149b5.png

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.

image.png.798ee64ae62befa23175ac911dd55a7f.png

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 - 

image.png.157453a685882f2a3a95095a29f5edd3.png

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.

Guest
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.

Loading...
×
×
  • Create New...