topic Dimension Logic in App Development

Dimension Logic

sona_sa — Tue, 21 Dec 2021 21:56:36 GMT

Hi Team,

I have this Graph, Where I am representing month wise Salary. I want only month from April to March. But I have the data till September.

I have used this dimension - =If([Recruitment Year Month]<>'Jan 2021' and [Recruitment Year Month]<>'Feb 2021' and [Recruitment Year Month]<>'Mar 2021',[Recruitment Year Month]).

How I can increase till March 2022. If I do not have data for after Sep 2021.

Thanks.

Re: Dimension Logic

jwjackso — Tue, 04 May 2021 15:03:49 GMT

If you don't have a Master Calendar , create one. Use the dates from the Master Calendar for your date dimension.

Re: Dimension Logic

sona_sa — Wed, 05 May 2021 05:17:55 GMT

I used the same. Now I have the Date till March 2022. Still I am not able to plot the graph till March 2022.

My Dimension is R_YearMonth and Expression is Count({<[Recruitment Type]={'New','Stepup','Replacement'}> } [Sl.No.]) If I have data till Sep 2021, But for Oct 2021 to March 2022 it should be 0, Either I have the data or not.

Re: Dimension Logic

jwjackso — Wed, 05 May 2021 20:02:40 GMT

Are you suppressing zeroes or not including null values?