topic Re: Need show zero values on the bar chart x-axis in Reporting Service & Alerting

Need show zero values on the bar chart x-axis

kiranb13 — Sun, 21 Aug 2022 16:49:23 GMT

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.

Re: Need show zero values on the bar chart x-axis

sidhiq91 — Sun, 21 Aug 2022 15:30:15 GMT

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

Re: Need show zero values on the bar chart x-axis

kiranb13 — Sun, 21 Aug 2022 16:50:00 GMT

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.