Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have one bar chart and one button in that button two clicks are their one is current selection and another one is 12 months
if i click the current selection the bar chart it display the current seletion data . and click 12 months it display current selection-12 months data in bar chart. plz tell me urgent....
Provide sample data please...
Use two expression with conditional enable facility.
For 12 month data
Sum({<Date={'>=$(=AddMonths(Max(Date),-12)) <=$(=Max(Date))'} >} Value)
Hi
Try like this
Current selection
=Sum({<DateField = {">=$(=MonthStart(Max(DateField))) <= $(=Date(Max(DateField)))"}>}MeasurementField)
Current selection - 12 month
=Sum({<DateField = {">=$(=MonthStart(Max(DateField),-12)) <= $(=Date(Max(DateField)))"}>}MeasurementField)
You can replace 12 in variable and use it in the button also and optimize in one expression.
in the above statements in place of measurement field I use count( if(op_status='won',op_status))/count(op_status)
it work or not other wise plz give information about this... urgent
any one plz help me
Hi
Try something like this
count({<DateField = {">=$(=MonthStart(Max(DateField))) <= $(=Date(Max(DateField)))"}, op_status={'won'}>}op_status))/count({<DateField = {">=$(=MonthStart(Max(DateField))) <= $(=Date(Max(DateField)))"}>}op_status)
i am calculating the both current selection and 12 months in bar chart . in button object wrote this code like if(vtogle_something='last',12months,current selection)
i m using this code to write the expression in bar chart like (if vtogle_some='last',
i don't next and also using the condition(expression like rate%)
count( if(op_status='won',op_status))/count(op_status) to display the bar chart corresponding clicks in one button object plz tell me the working expression........plz........urgent