Conditionally creating a line chart.

[ankit777]

Hi All,

I have a table.

Category	Point	Score	Date
North	a	7	March 20, 2014
North	a	6	March 21, 2014
North	a	5	March 22, 2014
North	b	7	March 20, 2014
North	b	9	March 21 2014
North	b	4	March 22 2014
South	c	3	March 20, 2014
South	c	5	March 21 2014
South	c	7	March 22 2014
South	d	8	March 20 2014
South	d	9	March 21 2014
South	d	7	March 22 2014

I want to create a line chart in which I want to show the date wise score of all the point in a particular category when user selects that category. For example

If user selects North, he should see the trend for point a and b in the line chart.

If user selects South, he should see the trend for point c and d in the same chart.

Please help.

Thanks

[MK_QSL · Accepted solution]

Like this?

[Gysbert_Wassenaar]

I'm not sure what you mean by trendlines. Are those simply the lines themselves or the lines you get when you enable for example the linear option under Trendlines (on the Expressions tab). See attached example

[ankit777]

Hi Manish,

Thanks for your reply. It exactly meets my requirement. But can you explain why are you using sum function?

[ankit777]

HI,

The chart you provided is correct. Please explain the use of sum() function.

[CELAMBARASAN]

Hi,

If there are many values for a particular combination of dimension then it will result you in "Null". If use sum around that field name then it will add up and show you the consolidated value for that combination.

[jagan]

Hi Ankit,

You need to use Aggregate functions like Sum, Count etc in Expressions to the get value by the dimensions.   For single date and point you have multiple scores, if you want to get by  Date and Point then you have to use Sum(Score) and use the dimensions date and point.  Sum() is similar to Group by in SQL

SELECT

date,

point,

Sum(score)

FROM TableName

Group By date, point;

Hop this helps you.

Regards,

Jagan.

[ankit777]

Thanks everyone.

[MK_QSL]

SUM is used considering the possibilities that there could be more than one different score for same category, point and date combination...