Monthwise Data not proper in chart

[#1]

Hi All,

I have a query. In my application, the text box is giving the correct result on month selection. But when i take the same expression in a chart with month as a dimension, it is not giving the correct result. For eg, for the month of April 2014, total headcount as on first day of month is 8915 and total headcount as on last day of month is 8914, which is correct in text boxes. But in the chart for the same it is giving incorrect values.Any suggestions on this friends?

Regards,

Raghu

[#2]

Hi,

Your chart is also showing correct da as showing in textboxes

Just check the expression total for both of your expressions and see.

Here your data is for ason date means if you select year=2014 and month=jan, the figure is for 2014 Jan,

If you select 2014,feb, the figure is for 2014 till feb and so on

[#3]

Hi Ravi,

Thanks for your reply. Yes the total value is right. But i need against each month the data should be same as the one which text box is showing.

[#4]

use TOTAL keyword in your expression like the following:

=(Count(Total DISTINCT{<Date={"<=$(=MonthEnd(vMaxDate,-1))"},Flag={'Joined'},JYear=,Month=>}Pers.no.)

-Count(Total DISTINCT{<Date={"<=$(=MonthEnd(vMaxDate,-1))"},Flag={'Left'},JYear=,Month=>}Pers.no.))

Hope it will work.......

[#5]

In your text box the data you are showing is sum of all the omnth as you have included {Month=} condition in expression.

So it is excluding the month selection.

But in your table box you are showing values across months , hence both the values are not matching.

Change your text box expression to affect by month like:

Count(DISTINCT{<Date={"<=$(=MonthEnd(vMaxDate,-1))"},Flag={'Joined'},JYear=>}Pers.no.)
-Count(DISTINCT{<Date={"<=$(=MonthEnd(vMaxDate-1,-1))"},Flag={'Left'},JYear=>}Pers.no.))

Then only you can check the values across table and text box.

Hope this will help you..!

[#6]

Hi Saranya,

Thanks for your suggestion. I tried the TOTAL.. but with that, all months gives the same value in the chart.

[tresesco]

I guess, this is second thread with similar requirement by you. Please explain your requirement in more details. May be, it would be better if you can give some expected output for different selections or non-selections.

[#8]

I think the way you are doing validation for data is incorrect.

Because your expression in chart and text box can't be the same.

In your text box the data you are showing is sum of all the omnth as you have included {Month=} condition in expression.

So it is excluding the month selection.

But in your table box you are showing values across months , hence both the values are not matching.

Change your text box expression to affect by month like:

Count(DISTINCT{<Date={"<=$(=MonthEnd(vMaxDate,-1))"},Flag={'Joined'},JYear=>}Pers.no.)
-Count(DISTINCT{<Date={"<=$(=MonthEnd(vMaxDate-1,-1))"},Flag={'Left'},JYear=>}Pers.no.))

Then only you can check the values across table and text box.

Hope this will help you..!

[#9]

have u added 'TOTAL' in both two expressions?

[#10]

Hi Tresesco,

The requirement is like this..

I need to calculate number of employees working in the organization. It has to be shown month wise. Like at the first day of month, how many employees are working in the organization.Similarly at the last day of month how many employees are working. For eg, for the month of April 2014, total headcount as on first day of month is 8915 and total headcount as on last day of month is 8914, which is correct in text boxes. But in the chart for the same it is giving incorrect values. Similarly for eg, in July 2014, total headcount as on first day of month should be 9041 and total headcount as on last day of month should be 9236.