Need to display past 12 months and last 3 months data

[chinnu123]

Hi Community,

I am posting this question again and again because I am unable to resolve this issue.

I need  12 months and and last 3 months data in a bar chart side by side by taking count of incidents for the last 12 months and last 3 months

Can any one please help me to solve this issue.

Here I am attaching sample data please consider  ISSUE field as Dimension and count of incidents as expression.

Thanks in advance,

Regards,

Chinnu.

[#2]

Hi,

I need to look for your application, can you send me?

[#3]

Do you change your script in the load ? Look the field SUMBIT_DATE_MMYYYY below:

LOAD ISSUES,

     Incidents,

     SUBMIT_MONTH,

     DATE(SUMBIT_DATE_MMYYYY, 'MM-YYYY') AS SUMBIT_DATE_MMYYYY

FROM

  (biff, embedded labels, table is [Sheet1$]);

[#4]

Do you change your script in the load ? Look the field SUMBIT_DATE_MMYYYY below:

LOAD ISSUES,

     Incidents,

     SUBMIT_MONTH,

     DATE(SUMBIT_DATE_MMYYYY, 'MM-YYYY') AS SUMBIT_DATE_MMYYYY

FROM

  (biff, embedded labels, table is [Sheet1$]);

[chinnu123]

Hi Marcos,

       First of all I need to be thankful  for your help

I am talking about the qvw file which you attached.In the attached qvw file if you select on individual ISSUES we are getting 100% instead of getting that particular issue percentage

for example according to your qvw file the network value is =8.8% but when we click on network issue individually it is showing 100% instead of 8.8%.

                 Hope you understand

Thanks in Advance,

Regards,

Chinnu

[chinnu123]

Hi Marcos,

Have you figure out any solution?

[#7 · Accepted solution]

Hi,

I understood,I guess rsr (My english is a little bad, sorry) but for network is 9,5%? Or my expression change the values? Look my new file again... see if is this..

Regards

Marcos Freire

[#8]

It works?

[chinnu123]

Hi Marcos,

Yes it works....

    Thanks for your work,support and most important your time spending for me.

Regards,

Chinnu.

[#10]

Pleasure...

any problem, we are here in the community

Regards,

Marcos Freire...