Hi All,
Error Range:
=If(x<-1;"-100%";
If(x>-1 And x]<= -0.7;"-100% to -70%";
If(x>-0.7 And x]<= -0.5;"-70% to -50%";
If(x>-0.5 And x]<= -0.2;"-50% to -20%";
If(x>-0.2 And x]<= 0.2;"-100% to -70%";
If(x>0.2 And x<= 0.5;“20% to 50%”;
If(x>0.5 And x]<= 0.7;“50% to 70%”;
If(x>0.7 And x<=1;“70% to 100%”;
If(x>1;">100%")))))))))
Count of records:
=Count(y;All)
When i was turning into barchart,its displaying those who has the values in the bar chart.
Remaining ranges are not coming into the chart.
I want to display the barchart if there is no data.
Hi Mahesh,
I am not sure if this object is created at the backend or created as the report variable.
If it is coming from the backend (may be universe), then create two queries for this report. One with only the object which is showing the ranges with out any conditions. This would give you all the LOVs and use the query which you have currently in place.
Then merge the Range objects from both the queries and ultimately use this merged object in the report or the chart you are using.