Skip to Content
0
Former Member
Dec 18, 2007 at 09:36 AM

Procedure For Creating Query for DAshboard-SPeedometer Chart!!

42 Views

Hi Gillian Leo

Thanks a lot for ur reply..As I was waiting for this.Before going into that,I want to clarify something regarding my Dashboard.

I have an average Score & number of responses which is survey report based on the Product in a speedometer chart.

1.Could you pls tell me o,What are the steps to create a Query for the above scenario???

2.Also one morething,The average Score is calculated in the range Basis..like <=2.0,>2 & <3.0,>=3.0...

3.How can we do this step in Query level???Is it done by condition or Restricting KF??If condition ,do we

need a variable to create or just I enter the values in it???

Pls give me a clear Picture of my Requirements Any Doubts Pls u can ask me..As I am new to BI & very new to Dashboard creation.

Thanks a lot.