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

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

I think you are on the right track by creating different dimension variables depending on what the "General RTA category" contains. The visualization part can be done by using different objects for each of the variables. Maybe different bar charts, key indicators can be used? Another way could be to create differnt meassures depending on the contined value and then use these in an bar chart as different measures. In that case tou can create a "total" dimension variable with only one value; "Total". Just my 5 cents, have not tested my thoughts 🙂 ... View more

Could it work by create numeric variables of the dates and then use the aggregate table function to get min/max per id, and then calculate the days? BR Fredrik ... View more

Hi! I don't think it is possible without pre-arranging the data. I usually join the interval-data with a calendar-dataset before loading it to VA, but the data grow very quick 🙂 //Fredrik ... View more

Sorry for late answer, you might already found a fix, but anyways:   Create a textvariable for weekday: IF ( DayOfWeek('date'n) = 1 ) RETURN 'Sunday' ELSE ( IF ( DayOfWeek('date'n) = 2 ) RETURN 'Monday' ELSE ( IF ( DayOfWeek('date'n) = 3 ) RETURN 'Tuesday' ELSE ( IF ( DayOfWeek('date'n) = 4 ) RETURN 'Wednesday' ELSE ( IF ( DayOfWeek('date'n) = 5 ) RETURN 'Thursday' ELSE ( IF ( DayOfWeek('date'n) = 6 ) RETURN 'Friday' ELSE 'Saturday' ) ) ) ) )   and one for date: Format('date'n[Raw], 'YYMMDD8.')   And use them instead of the date variables, should work 🙂   //Fredrik ... View more

I think the date format is the problem. Is it possible to create two text objects containing day/week and then use them and the format string? //Fredrik ... View more

What do you want to achieve? How would you like to have it visualized? //Fredrik ... View more

Hi! I did a work around where I used ranking to get the lastest data and also rolling 30 days. When the users opens the report it always shows the latest data and if they want they can change the date using a drop down.   I added a parameter to the drop down. The purpose is to store the selected date. I set default values to 1939 and 2039. I then added a data source filter to do the filtering: date <= [date parameter]   I also created a numeric variable from the date to use in the rankings.   The BANs and the bar charts shows the latest figures using rank (hope you get the swedish :)):   The line chart shows the rolling 30 days also using rank:   Hope this helps you 🙂 //Fredrik ... View more

Hi! Hope I understand your problem correct 🙂   I did a test using sashelp.class. You can try it yoursellf by importing sashelp.class into VA. This is the outcome:     On the report there are 2 button bars and 1 cross-tab. All measures are set to average aggregation. I have created 2 new dimensions that are used in the cross-tab. I also created 2 dimension for the choices in the button bars. I use the button bars to select level of detail for sex and name (using parameters). Depending on their values the drill level will change:               Then create a new report and add the data set.   Then create 2 new dimensions (*_dim, 2 new level choice (*_choice) and 2 paramters (*_level): Set default value for the parameters to 'Sex' and 'Name'. Define the sex_dim as:   Create name_dim as: Create level choice as:     Add two button bars and assign them as:   Add a cross-tab and assign as:   Set all the measures to average aggregation and start testing 🙂   //Fredrik         ... View more

It might be possible of you use the graph designer and stack two graphs on each other. The top one as the one you attached and the bottom one with the DS.Use category as shared rule and format the bottom graph so that the bars are white so only the label is visible. Change the label color (usually the same as the bars). Create a calculated measure with value=0 so that the bars are minimized. Just a thought 🙂 //Fredrik ... View more