Creating Multiple Line Charts(beginner)

You can get something close to what you describe.

  1. In Visualize, select Line Chart
  2. For Y-Axis, select "Average", then select PRICE -- note, you can't plot the exact prices, it has to be some bucketing function
  3. In X-Axis, select "Date Histogram", then select CHK_IN_DATE
  4. Then select "Add Sub-Buckets", select "Split Lines", select "Terms", select "SOURCE_SITE_C"

You should get something similar to the screenshot below.

If your graph ends up being too messy with more lines than you expected, switch the order of steps 3 and 4 (or just use the arrow keys to switch the order of operations, see this blog for explanation)

3 Likes