Visokio website     Downloads     Video tutorials     KnowledgeBase  
View data and variables - Visokio Forums
View data and variables
  •     schergr February 13, 2012 12:04PM
    Have a tab with two bar chart views. One Current state and the other target state. The difference between the two is affected by a variable which changes the value of a formula over time.

    The formula looks like this...

    IF([StateAsOf]<[Date],[Source],[Dest]) <br />
    I have preserve output in formulas turned on in the block where I've created the formula referencing the variable to accomodate for the variable.

    Is it possible to FREEZE the value of the variable in one view and hav it still be dynamic in the second? I've tried a query, but the query doesn't seem to capture the value fo the variable.
  • 4 Comments
  •        benjamin February 14, 2012 4:46AM
    The best option would have two(2) variable and two(2) coloumns
  •     steve February 14, 2012 7:16AM
    If you need further help, please post a configured sample data file.
  •     schergr February 16, 2012 10:53AM
    Yeah...did that, just hoping there was a slicker way (like including the values of variables in queries?)
  •     steve February 16, 2012 12:25PM
    You can use variables in custom "Formula" measures in 2.7's Bar/line view
Add a Comment

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories