Home : Dashboard Buttons - Pick Examples
Q14576 - INFO: Dashboard Buttons - Pick Examples
Dashboard buttons can be setup to select Variable Numbers, Locations, SampleNumbers, etc... and place the selected text on the dashboard.  This allows you to make dynamic dashboards where the user picks what is displayed by passing these selections to SQLFIRST, MVSTAT functions or Quick Trend, Year Over Year Graphs.   

Example 1 - Allow user to select VarNum to display Variable Info, Average, Min and Max. 

  1. Use Dashboard>Button in Spread Design.
  2. Click Misc and choose Pick VarNum.
  3. Enter the button text
  4. Click OK
  5. Enter a default varnum in C3 (the cell that will be set when a Varnum is selected).  The Pick Varnum will place the text in the cell to the right when it is used in a dashboard.  Hint:  You can merge B3 and C3 if you want to hide the text that the pick returns and you can still refer to C3 to see the data.
  6. Enter the following formulas:
    1. C5: =VINFO($C$2,"VarDisp")
    2. C6: =VINFO($C$2,"Units")
    3. C7: =GAVG($C$2,1,"R")
    4. C8: =GMIN($C$2,1,"R")
    5. C9: =GMAX($C$2,1,"R")

Example 2: Allow user to select Multiple VarNums to display Variable Info, Average, Min and Max. 

  1. Use Dashboard>Button in Spread Design.
  2. Click Misc and choose Pick VarNums.
  3. Enter the button text
  4. Click OK.
  5. Enter a comma separated list of VarNums in C3 to use as the default.  The Pick Varnums will place a comma separated list in the cell to the right when it is used in a dashboard.  Hint:  You can merge B2 and C2 if you want to hide the text that the pick returns and you can still refer to C32 to see the data.
  6. To display each VarNum Individually use the Split function.
    1. C4 =Split(C3,",",1)
    2. D4 =Split(C3,",",2)
    3. E4 =Split(C3,",",3)
    4. ...
  7. Enter the following formulas:
    1. C5: =VINFO($C$2,"VarDisp")
    2. C6: =VINFO($C$2,"Units")
    3. C7: =GAVG($C$2,1,"R")
    4. C8: =GMIN($C$2,1,"R")
    5. C9: =GMAX($C$2,1,"R")
    6. Highlight C5:C9, F5 Copy Special, Highlight D5:J5 and F6 Paste Special.
Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 4/2/2020 12:13 PM.
Last Modified on 4/20/2020 11:19 AM.
Last Modified by Scott Dorner.
Article has been viewed 93 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article