how to display fields values

[kunkumnaveen]

Hello All,

A kind of wired thing is going on with my dashboard,the thing is ,the thing  which was working great before reload was not working  ,anymore after reload

this is how my dashboard look,3 charts

Dimension:1) LOCATION,

                 2)LocationQuality

expression:

firstsortedvalue(distinct {<Category=,Decision=,ROLE=,SUPCAT=,YEAR=,LOCATION=,name1=,ENSTEHDAT=,MaterialName= ,LocationQuality={QUALITY_GOV }  >} Value, -ADATE)

so on click on any of these three chart ,it used to get select both dimension values,i mean this

After going a reload i got new LOCATION data in to dashboard ...

so on click on any of these three charts, only LOCATION is getting selected but not LocationQuality any more,even though i have same

dimensions and expression

it working fine if i promote and demote dimension i mean

Dimension:1)LocationQuality

                 2) LOCATION

but i want it to work when dimensions are:

                                      1)LOCATION

                                       2)LocationQuality

PFA....

plz any suggestion ..thanks

[kunkumnaveen]

Hello All,i am still looking for any help or suggestion for the above requirement ..plzzzz

[Anil_Babu_Samineni]

Naveen, I don;t have the access. Can i know the dimension

Are you using any Calc dimension for Location

If yes, Please sahre me the Calc expr

[kunkumnaveen]

Hi Anil,

Among two dimensions one is a calculated dimesion

Dimension:

1)if(not match(LOCATION,'CLOSED'),LOCATION)

2)LocationQuality..(i got this filed by applying a cross table function at script level)

[kunkumnaveen]

Will it going to make difference if we use calculated dimension  as dimension

[Peter_Cammaert]

Apparently, your set analysis forces the single value-dimension 'LocationQuality' to go into hiding. Check it out: eliminate the LocationQuality dimension. Nothing will change.

And this only happens in graphs, not in table charts. If you change the chart type to Straight Table, two dimension columns will appear, and clicking on the value will select values in both dimensions.

I think this is default behavior. You can try turning this series of charts into a Trellis setup (with LocationQuality as Trellis dimension). That will allow you to select the two dimension values.

Best,

Peter

[kunkumnaveen]

Hello All,

i got struct at this requirement from last three days ,i have no clue wants going wrong .can any one help me plz