CODEWITHSUNDEEP
analyticsdata-visualizationspotfire
cookiemnstr247
cookiemnstr247

Reputation: 131

Spotfire Line chart with min max bars

I am trying to make a chart that has a line graph showing the change in value in the count column for each month, and then two points showing the min and max value in that month. The table table is below. 

Date        Min     Max     Count
1/1/2015    0.28    6.02    13
2/1/2015    0.2     7.72    8
3/1/2015    1       1       1
4/1/2015    0.4     6.87    7
5/1/2015    0.36    3.05    8
6/1/2015    0.17    1.26    13
7/1/2015    0.31    1.59    15
8/1/2015    0.39    3.35    13
9/1/2015    0.22    0.86    10
10/1/2015   0.3     2.48    13
11/1/2015   0.16    0.82    9
12/1/2015   0.33    2.18    5
1/1/2016    0.23    1.16    14
2/1/2016    0.38    1.74    7
3/1/2016    0.1     8.87    9
4/1/2016    0.28    0.68    3
5/1/2016    0.13    3.23    11
6/1/2016    0.33    1       5
7/1/2016    0.28    1.26    4
8/1/2016    0.08    0.41    2
9/1/2016    0.43    0.61    2
10/1/2016   0.49    1.39    4
11/1/2016   0.89    0.89    1

I tried doing a scatter plot but when I try to Add a Line from Column value I get an error saying that the line cannot work on categorical data. enter image description here

Any suggestions on how I can prepare this visualization?

Thanks!

Upvotes: 1

Views: 1648

Answers (1)

S3S
S3S

Reputation: 25112

I would do this in a combination chart.

  1. Insert a combination chart (Line & Bar Graph)
  2. On your X-Axis put your date as <BinByDateTime([Date],"Year.Month",1)>
  3. On your Y-Axis put your aggregations: Sum([Count]), Max([Max]), Min([Min])
  4. Right click > Properties > Series > set the Min and Max to Line Type
  5. (Optional) Change the Y-Axis scale

Results

Upvotes: 1

Related Questions