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

And you need to have them in the same graph? Otherwise you can stack them in the graph desiger instead of overlapping them? Or have two separate graphs? ... View more

Hm, you might need to prepare the tables, add the attributes to each if them.. ... View more

Which version of VA are you using? You should be able to do this eiter with report linking or using parameters. ... View more

I don't think you can do this with the default graphs. You should be able to achieve the desired result using the graph designer and add two bar charts on top of each other, one showing actual value and the other hte percentage. I think you can hide the percentage bar so only the percentage figure is visable. ... View more

Hi! Maybe you can achieve this by createing three new measures, one for february, one for the latest month and one for the difference. Depending on how your months are formatted you have to define your formula, but something like this: Feb: IF dateFromMDY(month(datepart(now())),1,YEAR(datepart(now()))) = 01FEB2020 return VALUE ELSE missing Curr: IF dateFromMDY(month(datepart(now())),1,YEAR(datepart(now()))) = DATEOFMONTH return VALUE ELSE missing Growth: Curr - Feb Might help you 🙂 ... View more

Which are the Business questions you want to answer with your dashboard? Make a list of them and prioritize them. The ones most important should be easy to get an answer on as soon as you open the dashboard, with none or few selections. The other ones might need some input och selections. I am not sure that drill-down is better suited than using multiple graphs, it ell depends on the questions 🙂 /Fredrik ... View more

Hi! What you can do is to transform your data (befre loading it into VA) and create a new dimension containing the name of the measure and a new measure containing the value. You then group your chart by the new dimension and filter it with a list object containing the new dimension. As value in the bar chart you use the new measure. //Fredrik ... View more

Hi! What happens if you add the first page data to the second page, would it not be filtered as well? I mean if you for example put a table with customer data on page2? //Fredrik ... View more