Dimension Logic

[sona_sa]

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.

[jwjackso]

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

[sona_sa]

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.

[jwjackso]

Are you suppressing zeroes or not including null values?