BAR CHAR EXPRESSION

sona_sa — Tue, 29 Jun 2021 09:02:13 GMT

Hi,

Please find attached QVW and try to make an expression in same bar chart.

Now I have to 2 expression in BAR Chart.

DOJ =Count(DISTINCT If(MonthEnd(Link_Date)=Monthend(DOJ),EmpCode))

DOL =Count(DISTINCT If(MonthEnd(Link_Date)=Monthend(DOL1) AND DOL1<>'01/01/1900',EmpCode))

I have Total Head Count till Date = 4718, Expression is

=Count({<DOL1={'01/01/1900', ">=$(=Today())"}>} DISTINCT EmpCode)

Now I have to make an expression in backward for month wise like this.

For June – 4718

For May - (4718 + June Month DOL -June Month DOJ) = Like (4718 + 16 – 5) = 4729

For April - (4729+ May Month DOL -May Month DOJ) = Like (4729+ 69 – 40) = 4758

Thanks.

Re: BAR CHAR EXPRESSION

dineshm030 — Wed, 30 Jun 2021 10:59:34 GMT

sona_sa — Wed, 30 Jun 2021 12:57:04 GMT

Hi Dinesh,

Output is correct, Can u build the same in my QVW. Backyear month will follow the same.

Please find the attached QVW.

Thanks