Gauge Chart has no Needle

[cring]

I am a rookie at charts and am attempting to create a gauge chart on an active report.  I have a total count that I placed in the Y-axis and in the Gauge Axes.  What I am trying to do is create a gauge that shows green if my total count is less than 10, yellow if it's 10-20 and red if it's over 20.  When I run my report, the gauge has no needle.  Any help is appreciated.  Let me know what additional information I can provide to troubleshoot.  Thanks!

[MFGF]

I am a rookie at charts and am attempting to create a gauge chart on an active report.  I have a total count that I placed in the Y-axis and in the Gauge Axes.  What I am trying to do is create a gauge that shows green if my total count is less than 10, yellow if it's 10-20 and red if it's over 20.  When I run my report, the gauge has no needle.  Any help is appreciated.  Let me know what additional information I can provide to troubleshoot.  Thanks!

Hi,

I'm guessing you have set manual maximum and minimum values on the gauge axis - is this correct? Have you checked that the total count values are within the axis ranges you have specified? If the count value is outside of these ranges, the needle can't be rendered (which is obvious when you think about it in those terms) :)

Cheers!

MF.

[cring]

Yes, I have the min set to 0 and the max to 40.  My total count is 33.

[MFGF]

Yes, I have the min set to 0 and the max to 40.  My total count is 33.

Temporarily remove the maximum value then run the report again. Does the needle appear? What value does it represent if so?

MF.

[cring]

I changed the maximum to automatic and removed the manual 40 I had entered.  I still have no needle on the gauge.  Where do I define that I want LT 10 green, 10-20 yellow and GT 20 red?  Are those calculated fields that I then add to the chart?  Maybe that's the step I'm missing??

[MFGF]

I changed the maximum to automatic and removed the manual 40 I had entered.  I still have no needle on the gauge.  Where do I define that I want LT 10 green, 10-20 yellow and GT 20 red?  Are those calculated fields that I then add to the chart?  Maybe that's the step I'm missing??

Ok - let's do a quick sanity check. Create a new report with just a gauge in it. Drag your total count item into the Gauge Axis area. Run the report. Do you see a needle?

Once we have a needle we can deal with the colour ranges :)

MF.

[cring]

I copied the query into a new, blank report.  I added the total count in gauge axes.  When I run the report, I have no needle on the gauge.

[MFGF]

I copied the query into a new, blank report.  I added the total count in gauge axes.  When I run the report, I have no needle on the gauge.

Hi,

What exactly is the count you are using? Is it a query item from your package? Is it a calculation defined within the report? If so, how is it coded? Why did you copy the query?

MF.

[cring]

I am using a data item where I am doing a count distinct on an internal control number. 

count (distinct [internal control number] for report)

[MFGF]

I am using a data item where I am doing a count distinct on an internal control number. 

count (distinct [internal control number] for report)

I just created a new report and added a query calculation with the same syntax as yours. I used this in the gauge azis of a gauge and I see a needle.

What are you doing differently to me? Anything else going on?

MF.

[cring]

Nothing I can see that would affect this.  I am doing several filters to find particular data. 
I created a brand new chart from scratch with just the gauge chart on it and there is a needle.

[MFGF]

Nothing I can see that would affect this.  I am doing several filters to find particular data. 
I created a brand new chart from scratch with just the gauge chart on it and there is a needle.

Ok - good. So now you have a needle, that proves your expression works and it proves that the gauge works. If you go back to your original report and put the same data from the same query into a crosstab, do you see any values displayed in the crosstab?

MF.

[cring]

Yes, I do.

[MFGF]

Yes, I do.

Ok. The issue is, we don't know what they are, and you haven't told us anything about how your query is defined or filtered, and you haven't indicated whether the values displayed are what you would expect and what ranges they lie within.

If I was a betting man, I'd say you are returning no data to be displayed in the gauge query? I'd strongly suspect your filter or filters are the cause.

MF.