Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi ,
i want to know how will i use slider with my chart to find out (top n providers by revenue)
in my chart i am using provider description is a dimension and sum(revenue) is an expression.
in my slider i am using min value 5 max value 30 and static step=5.
please let me know the steps
hi
you have to set the variable to 0
use it in the slider as you like
Than in the chart options -----> Presentation -----> Max Number and in it put your variable name
If I understand you corretly, you want to show a top N in your charts and you want to be able to set the N with a slide, am I right?
I do this by making a variabel (vTopN) and add this variable to a slide.
Then go to the presentation tab of the charts which you want to show the top N.
Check Max Number (1-100) box and give the name of the variable (vTopN) as the expression.
ya u r right.i want to show top n provider in respect of revenue in my chart
hei
attach is an example
the steps you need to do:
1. build a chart with:
dim :provider
exp: sum(revenue)
2.create a varaible with the name Slider.
3.go to presntion tab in the chart properties
and in the box in the top left side Max Visible number enter the formula "=Slider"
thats it
hope its help you
hi.........
Dennis is right. Declare a variable and use it in your slider. also set the limit to 5...and sort order to decreasing.
hi it is working fine thanks
You have to define a variable with a value. Ex: Va = 5 (define in Variable Overview).
This variable should be added in Slider as well the Chart/Graph that you are working on.
In Slider go to General -> Select Variable and select the variable name from the list box.
Similarly set the values min as 5 , max as 30 and static step as 5.
Go to chart -> Presentation -> enable the check box (max visible number (1-100) and enter the variable name as =va1).
Now what ever you select in slider the same will reflect in the above chart.