Need show zero values on the bar chart x-axis

[kiranb13]

Hi All,

I need to create a bar chart.

Below is my requirement. I need show last 3 months data in bar chart irrespective of the date selection. 

For example : Current month is Aug 2022, i need to show the chart for May, June and July 2022. In the database i do have vaules for July month. I created Master calender to acheive May2022 and June 2022. But even though i had written set analysis expression to get three months data i unable to filter the data with set analysis. If i uncheck "show 0 values" i will be able to see only July month data. Can anyone help me here ?

I have tried the below expression:

if(GetSelectedCount(Participant)=1,
(SUM({<CUST_Month={">=$(=Date(addmonths(Max(today()),-3),'MMM-YY'))<=$(=Date(Max(today()),'MMM-YY'))"},FromDate=,ToDate=>}[CUST_NO_OF_ENROLLMENT])),0)

also i tried with adding sum({1}0) as well.

[sidhiq91]

@kiranb13  Could you please share some sample data? It would help us to resolve the issue.

[kiranb13]

I have tried with the below expression :

if(GetSelectedCount(Participant)=1,
(SUM({<CUST_Month={">=$(=Date(addmonths(Max(today()),-3),'MMM-YY'))<=$(=Date(Max(today()),'MMM-YY'))"},FromDate=,ToDate=>}[CUST_NO_OF_ENROLLMENT])),0)

also i tried with adding sum({1}0) as well.