cancel
Showing results for 
Search instead for 
Did you mean: 

Bar Chart

Former Member
0 Kudos

Hi

Report fields are Date of suevey (mm/dd/yy), OverallRating(1,2,3,4,5) projectid

I want to show bar graph.

In x- axis Month value LIke jan, mar, -- dec.

in y axis overallrating like 1,2,3,4,5

plotted data is count of projectid's.

means i want to show for particular month how many projects are rated how much

means in jan 4 projects are rated 4, 3 projects are rated 5

in feb 2 prjects are 4 , etc.

can anyone help me which column values i have to talke in on change of, showvalues in data tab of bar chart.

Thank you

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

If i take generate date in on change of then i am getting correct datevalues on x-axis , like first 1/10/2009 data , and next this 2/1/2009

but if i convert date format to month value

MonthName (Month ({TOWERCSSRATING.GeneratedDate}))

then on x-axis first i am getting feb data, then jan data.

i think on x-axis the month values are coming in alphabet order.

please give me solution.

Former Member
0 Kudos

Swetha,

don't worry, do this.

In Chart expert>data tab>in "Onchage of" dorp down list you have selected your calculated month right? below that there is a button "Order". click that button-->you will get a common tab. here you will have 4 options to sort.

1.ascending

2.descending

3.specified

4.original

select specified-->then one more tab will come "specified order". here from drop down list select the values in order as per the requirement. hope I was clear.

Cheers,

Anil

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

Sorry for late reply.

i am using month, rating descriprion in on change of

and project id in show values.

i am getting correct data, but

i am calucating month by using this fomula

MonthName (Month ({TOWERCSSRATING.GeneratedDate}))

so o/p is januvary, but i want jan.

and chart showing first feb date and then jan data.

but i want first jan data, next feb etc last dec.

please give me solution.

Former Member
0 Kudos

Morning Swetha,

On change of = Month

Show Value = Overall Rating (projectid).

Regards

Jehanzeb