Year - Combo Graph Problem

[Anil_Babu_Samineni]

Hello,

I created one Combo graph. I want to ask you one question, I do have 2014 data from one table and 2015 data from another table. But, now i want to merge those two tables. Here, I am expecting the graph (Combo Chart) of 2014 and 2015 Year wise data.

While i taken two dimension's as Year & Year1 with Expression's are

1) Avg({$<name -= {'Key Message Delivery','Sales Objective Category'}>} Score) - Display options is Bar

2) Avg(Score) - Display options (Symbol - Circle & Line - Normal)

Note: If we can display 2014 & 2015 Data in graph. Now, in my graph it showing 2014 Data only. If possible, Please help me to show those two years. If not, Let me know, Please?

For Ref. PFA of my Application

- Anil

[sunny_talwar]

So you want to see two bars and two symbol for 2014 and 2015?

[Anil_Babu_Samineni]

I want to see 2014 & 2015 Data in Single Graph with those two expressions.

[sunny_talwar]

Where is year 2015 in your application?

[Anil_Babu_Samineni]

Sunny,

I have two tables. One table has 2014 & Another table has 2015 Data (Dim - Year & Year1) . So, Now i want to show those two year data with two expressions.

Is that is possible, Because, 2015 Data has another table.

[sunny_talwar]

Why don't you concatenate these two tables into one table? If you can share the csv files, I might be able to show you what I am trying to do here

[Anil_Babu_Samineni]

Sure,

Updated : I Apologize to forget to add. Thanks.

PFA.

[sunny_talwar · Accepted solution]

Excel file attached has a weird template for date. Can you check this

If I force 2015 manually using this script:

2014:

LOAD RowNo() as Rowno,

  rep,

    franchise,

    product,

    Date,

    Year(Date) as Year,

    Score,

    groupObservation,

    name,

    Username

FROM

(txt, utf8, embedded labels, delimiter is ',', msq);

Concatenate(2014)

LOAD RowNo() as Rowno,

  rep,

    franchise,

    product,

    Date,

   2015 as Year,

    Score,

    groupObservation,

    name,

    Username,

    '2015' as Flag

FROM

[2015Data.csv]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

I get this:

Note: I removed Year1 dimension and now you Year dimension include 2014 and 2015 and you get the chart that you might be looking for

[Anil_Babu_Samineni]

Sunny,

Perfect, If we add like FLAG and Concatenate. in future, we are getting any trouble, Right?

[sunny_talwar]

Flag's are not bad... but 2015 as Year is risky. I would want to get this year from 2015 from the date. But date isn't right and needs to be fixed