Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have 6 Objects in my dashboard
i.e
2 list boxs ,LH01,LH02(Global Objects):if we select these two List boxes then only complete dashboard Has to Reflect.
4 Charts,CH01,CH02,CH03,CHO4
1)if we select CH01 then That CH01 Chart only Reflect not other charts (CH02,CH03,CH04)
2)if we select CH02 then That CH02 Chart only Reflect not other charts( CH01,CH03,CH04)
3)if we select CH03 then That CH03 Chart only Reflect not other charts (CH02,CH01,CH04)
e.t.c
Dimesion is Month field
My expressions are
1)count(DISTINCT Number)
2)(count({<resolved_Date={'=resolved_Date<=duedate3'}>}DISTINCT Incident_Number3))/count({<resolved_Date={"*"},duedate3={"*"}>}distinct Number3)
Thanks,
May be like this:
1) Count(DISTINCT {<GlobalFilter1 = $::GlobalFilter1, GlobalFilter2 = $::GlobalFilter2, GlobalFilter3 = $::GlobalFilter3>} Number)
2) (Count({<resolved_Date = {'=resolved_Date<=duedate3'}, GlobalFilter1 = $::GlobalFilter1, GlobalFilter2 = $::GlobalFilter2, GlobalFilter3 = $::GlobalFilter3>} DISTINCT Incident_Number3))/Count({<resolved_Date={"*"}, duedate3={"*"}, GlobalFilter1 = $::GlobalFilter1, GlobalFilter2 = $::GlobalFilter2, GlobalFilter3 = $::GlobalFilter3>} DISTINCT Number3)
1)if we select CH01 then That CH01 Chart only Reflect not other charts (CH02,CH03,CH04)
2)if we select CH02 then That CH02 Chart only Reflect not other charts( CH01,CH03,CH04)
3)if we select CH03 then That CH03 Chart only Reflect not other charts (CH02,CH01,CH04)
Where are you selecting CH01, CH02 and CH03 getting selected?
i am selecting on Bars Month Wise ..
example:
i have 6 maonths Jan ,Feb,March,April,May,June.
If i selcet May then May data i can see on Bar chart.But that should not reflect on other charts Like CH01,CH02,etc
May be use three different alternate states to do this. Do you have a sample where this can be demonstrated?
Check the attached to see if this fulfills your requirement.
Best,
Sunny
your correct sunny but
i have expressions like this who to write for this
1)count(DISTINCT Number)
2)(count({<resolved_Date={'=resolved_Date<=duedate3'}>}DISTINCT Incident_Number3))/count({<resolved_Date={"*"},duedate3={"*"}>}distinct Number3)
May be like this:
1) Count(DISTINCT {<GlobalFilter = $::GlobalFilter>} Number)
2) (Count({<resolved_Date = {'=resolved_Date<=duedate3'}, GlobalFilter = $::GlobalFilter>} DISTINCT Incident_Number3))/Count({<resolved_Date={"*"}, duedate3={"*"}, GlobalFilter = $::GlobalFilter>} DISTINCT Number3)
i have three Global filters how can i can do this
May be like this:
1) Count(DISTINCT {<GlobalFilter1 = $::GlobalFilter1, GlobalFilter2 = $::GlobalFilter2, GlobalFilter3 = $::GlobalFilter3>} Number)
2) (Count({<resolved_Date = {'=resolved_Date<=duedate3'}, GlobalFilter1 = $::GlobalFilter1, GlobalFilter2 = $::GlobalFilter2, GlobalFilter3 = $::GlobalFilter3>} DISTINCT Incident_Number3))/Count({<resolved_Date={"*"}, duedate3={"*"}, GlobalFilter1 = $::GlobalFilter1, GlobalFilter2 = $::GlobalFilter2, GlobalFilter3 = $::GlobalFilter3>} DISTINCT Number3)
{<GlobalFilter1 = $::GlobalFilter1,GlobalFilter2 = $::GlobalFilter2, GlobalFilter3 = $::GlobalFilter3>}
assuming your global filter are like three list boxes in default state, replace GlobalFilter1 etc. with the field names used in these list boxes.