thank you for sharing your best practice... ... View more

The user will have no way of knowing if it's a percent graph or an index graph so they'd have to klick the tabs to find the graph after making the selection... This was considered but rejected. We went with displaying the unit in the graph name using a textbox with a parameter instead. Not perfect but it's something. Thinking about sending in a feature request to SAS so that you can allow a calculated object to inherit the format (and also sort order) of another object... ... View more

I am not sure where JSON helps. You don't say why the number of observations is important so hard to address any detail there.   It might be that processing in a somewhat different order, such as getting a count of the common start/ end pairs before doing the expansion that caused the 35 million rows would be appropriate.   Suppose you COUNT data by start end pairs and get a result similar to this: start end count 2012 2013 103 2012 2014 145 2012 2015 154 2012 2016 234 2013 2014 98 2013 2015 133 2013 2016 199 2014 2015 55 2014 2016 101 2015 2016 88 When you transform that to get single year keep the count with it so it looks like: Obs count year 1 103 2012 2 103 2013 3 145 2012 4 145 2013 5 145 2014 6 154 2012 7 154 2013 8 154 2014 9 154 2015 10 234 2012 The  example data would have 30 rows of data. Which would still be much smaller than just transorming the 103 rows of 2012 to 2013. Summarize that data to total the count by the year and there are only 5 rows of data to actually plot with counts in the 622 to 1119 range (for my given example). ... View more

I suggest starting here:  Managing Access to Functionality  ... View more

Could you do that using tabs, either using the tab container och tabs in the report? ... View more

Hi! You can create something similiar by using a bar chart.   Create a calculated measure with value 1 and add to the bar chart as measure. Add your time dimension to the bar chart as categoy. group the bar chart (rows) on your machine (or what you use), as in yourexample grd_a and grd_b. Create calculated measures for each of your statAcronym Create a display rule for each of the measures. Could look something like this: BR Fredrik ... View more

@acordes wrote: The DOW technique Exactly. Learned it here on the communities. ... View more

Thank you for this, your solution did work, and your counters to why VA is not the best solution is now understood Just to be clear, it seems like it SAS Visual Analytics is the final solution you need (dashboard). It reads data from the distributed CAS server and is built for visualizations and modeling of your data using a variety of objects it provides. In your scenario you need to completely restructure the data, which I don't think I don't think Visual Analytics can do. It does provide some data preparation features, but you need to completely rearrange your data for what you want. Which is pretty normal.   SAS Viya has other applications for data preparation like Data Studio, SAS Studio (here you can use point and click tools, SAS/SQL/Python code and more) or you can use open source languages like Python in other programming interfaces.   While you can do some data preparation in Visual Analytics, I personally prefer doing the majority of cleaning and structuring of my data prior to starting my dashboard in Visual Analytics. I like to program (SAS/Python/SQL) though, so I like to use code for my data prep since I have the most control that way and can easily automate that process.   ... View more

Could you share a code example? ... View more

You can use a data driven content and create a viya job that creates the table dynamically and display it in VA. Might help you...:) BR Fredrik ... View more

Hi,   I found an answear to a similar question in this paper : "Mastering Parameters in SAS® Visual Analytics" at section "Adding Dynamic maximum functionality to drop-down list". I just tried it and it worked for me.   The idea is to create a binary variable in your table that will flag your desired default value. Then add a filter logic on each SAS VA object that you want to filter to only takes rows that are flagged if the parameter is set to missing (i.e. if no value is selected in the dropdown list).   Hope it will help.   Have a nice day.   Paul. ... View more

Hey Rushabh_45,   The guidance given after your post is how we were able to resolve the issue and we did not have to rebuild the report. SAS Tech needs to see your xml file and the solution came through that system, not here. The solution/fix was pretty quick.   Good luck. ... View more

I have the same issue, can't get the calculated item in SAS VA to evaluate the second if... IF ( 'Make'n In ('Ford') ) RETURN 'Blue Oval' ELSE ( IF ( 'Type'n In ('Sport') ) RETURN 'My Favorite' ELSE 'Everyone Else' ) Did you ever get a resolution? ... View more

You cannot create a custom category from an aggregated measure even in the  most current release.  ... View more