Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I have 3 columns A, B and C in my table, Now I need to create another column D, where D=(A+B+C)* n where n can range from 1 to 10.
I want to show all these four columns on my dashboard and just by selecting value of n in slider I will have the required table on dashboard.
If there is any video available on you tube, kindly provide the link.
Thanks in Advance !!
Regards
Anjana
Anjana , please have a look on this sample .
Hi Anjana,
In Script reload your table with all A,B,C columns.
Now create a variable as vInput and provide min and max values as 1 and 10 respectively.
Create a slider and assign vInput to it.
Now create a straight table with A,B,C as Dimension and a expression as:
(sum(A+B+c))*vInput.
Now when you wil slide you vInput values, the chart will reflect accordingly..
Hope this helps you.
regards
Nitin
Hi,
you have to create a chart, select straight table in the general tab, add the 3 dimensions, A,B,C and then in the expression tab =(A+B+C)*n
Create the variable n (Settings > variable overview) and then the slider object, in which you select the variable n.
Anjana , please have a look on this sample .
Hi,
I am able to create this variable n but When I create this straight table, there are only columns heading but no values under Heading A,B C and D.
Kindly help !!
Anjana
Miss!
have a look on the sample i have just given in my comment .
To create a variable just go to Settings>>DocumentProperties>>Variables Tab>>
And then add new variable and name .
Now call it in the slider object
Hi Everyone,
Thanks for the help.
I am Know able to create the required table.
Wish you all a happy New Year
Thanks once again !!!
Anjana
A very Happy New Year to you MISS!!
Are not able to see the comment of mine with a sample attached .
Hope you get some help from it.