Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@kiranb13 Could you please share some sample data? It would help us to resolve the issue.
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.