Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i hav 2 charts
i have clicked on 1 chart , the 1st chart data wll be displaying and aslo 2 chart related data also displaying ,
then if i want to drill down o 2 chart .
if am drillin down on 2 chart , the 1st chart dat hould not get reflectd, wat ever first i have clicked on the 1st chart that as to get pop up
ex: i have sales on country wise on month wise
1st chart will be countries wise
India, aregntina, canada based n month wise sales,
if i click on 1st chart india , the data will how up.
in the secnd chart , the states wise data will show .
Now my requirement is
if i go to second chart and click on statewise data,
the first chart inia wouldbe like that ony , it should not refelect , how
no not coming
in the 1st chart dimension i have kept as month andin the exprssion as
count(DISTINCT{<[Miss from Testing]={'Yes'},Year = {$(vMaxYear)}>}SRV_OUT_ID)
and in the background color as
=If(GetSelectedCount(RES_GBGF_NAME)>0,
if(count(DISTINCT{<[Miss from Testing]={'Yes'},Year = {$(vMaxYear)}>}SRV_OUT_ID)<=SUM({<Refline={'inbound'}>}Refvalue),rgb(117, 238, 7),
if(count(DISTINCT{<[Miss from Testing]={'Yes'},Year = {$(vMaxYear)}>}SRV_OUT_ID)>SUM({<Refline={'outbound'}>}Refvalue),rgb(238, 24, 7), rgb(238, 237, 7)
)),rgb(141,170,203))
secon chart
count(DISTINCT{<[Miss from Testing]={'Yes'},Year = {$(vMaxYear)}>}SRV_OUT_ID)
and in the background colour as
=If(GetSelectedCount(RES_SL_CI_NAME)>0,
if(count(DISTINCT{<[Miss from Testing]={'Yes'},Year = {$(vMaxYear)}>}SRV_OUT_ID)<=SUM({<Refline={'inbound'}>}Refvalue),rgb(117, 238, 7),
if(count(DISTINCT{<[Miss from Testing]={'Yes'},Year = {$(vMaxYear)}>}SRV_OUT_ID)>SUM({<Refline={'outbound'}>}Refvalue),rgb(238, 24, 7), rgb(238, 237, 7)
)),rgb(141,170,203))
the first chat if i click on the first and second will change
then furthur if i clisk on second filetrelated to second chrt , the corresponding first chart should not get changed ,how?
Well, the expression is the same, so the filter to be applied in set analysis should be the same.