Display all months in X axis and Expression

[smilingjohn]

Hi All ,

I have line charts and in x Axis the months are displayed in altrenative way like  below screenshot 

Why is this not hsowing Feb, April,June and so on  any gues ? 

Expression 

My Below expression is working fine when I have only count like below 

count({<PROJECT={'Cricket','Hockey','Wrestling'},CASE_ID-={'null'},STATUS={Active},Year={'>2019'}>+
<PROJECT={'Cricket','Hockey','Wrestling'},CASE_ID-={'null'},STATUS={Active},Year={'>2019'}>}Matches)

No Result 

If I add  if(GetFieldSelections(Team)='India', this dont show any result for me , Can anyone please help me in sorting this ?

if(GetFieldSelections(Team)='India',
count({<PROJECT={'Cricket','Hockey','Wrestling'},CASE_ID-={'null'},STATUS={Active},Year={'>2019'}>+
<PROJECT={'Cricket','Hockey','Wrestling'},CASE_ID-={'null'},STATUS={Active},Year={'>2019'}>}Matches))

Thanks 

[PiEye]

Hi John

For the chart issue, the setting you need is in the chart properties, under the "axis" tab. Ensure the X axis type is set to continuous, and it will give you the option to change the step between categories: 

For the second issue, can you describe more what you are trying to achieve? The condition is looking for the case where only India is selected; is this what you are doing?

Pi