How to find the data of last six months from the current month?

[#1]

Hi,

We have to generate a bar chart which shows the count of Patients visit across the period of 6 months with current MTD.

Could you please help us in this??

Thanks,

Thirumalai

[senpradip007]

Try this:

=Count({<Date={'>=$(=AddMonths(Max(Date),-6))<=$(=Max(Date))'}>} PatientId)

Hope it will help you.