I am interested in SAS visual analytics. How does this work?
1-you have to build a large table with all variables. All dashboards use this table.
2-you have to build a table for each dashboard.
3-Each dashboard can read from different tables at once
Thank you.
Not exactly...
The filter Country=USA for table1 will only subset the data in table1. Creating a Country=USA on table2 means you are using the Country column from table2 will subset the data in table2 only. You have to create filters per table, even though the column may exist in each table.
Hope this helps.
Hi Kimo,
Welcome to the SAS Visual Analytics community. To answer your questions:
1-you have to build a large table with all variables. All dashboards use this table.
Yes
2-you have to build a table for each dashboard.
No you don't have to. You can create multiple dashboards from the 1 table
3-Each dashboard can read from different tables at once
Yes
To get you started using SAS Visual Analytics, you will see a box titled "SAS Visual Analytics Starter Kit" at https://communities.sas.com/t5/SAS-Visual-Analytics/bd-p/sas_va - I suggest going through these links.
Also @ChrisHemedinger posted earlier this week some very SAS Visual Analytics on-demand webinars you may find helpful at
https://communities.sas.com/t5/SAS-Visual-Analytics/Column-Percentage-in-bar/m-p/274082#M4452
Kind Regards,
Michelle
Just to clarify @MichelleHomes comments - you can do it however you like. It is based on your individual report.
In some cases - it works better to have a report/dashboard that is based on a single table. Perhaps you have multiple views of the data - for instance a treemap that shows the products by Batch Number. Then another section that has a map showing where the batch numbers were distributed.
You can also have the data broken into smaller tables if it is more convenient for you or works better for you data.
Sorry if my answers appear contradictory and created any confusion.
You can create a large table or multiple tables and load them into memory. If you are replicating the data in the multiple tables, it is obviously taking up additional resources (and may affect performance) which is why you might consider using one large table. Also you may want to use one large table if you want to have interactions within and between your reports so the data can be filtered. The source and target tables must be the same for the filtering to work.
I suggest spending some time reading the documentation, watching videos/webinars/tutorials and perhaps attend SAS Visual Analytics training to gain a solid understanding with your data load/preparation and report creation.
Kind Regards,
Michelle
Thank you for your time.
Kind Regards,
Thank you @kimo. Glad to help.
Kind Regards,
Michelle
I have a new question: "if you want to have interactions within and between your reports so the data can be filtered. The source and target tables must be the same for the filtering to work."
Is it not possible to put a general filter that filters all tables at once?.
In other words put a filter that interact with all tables but each table serves to calculate indicators.
New questions should really be created as a new question so that the thread remains as the original question. Please keep this in mind in future.
Filters are data source specific for the data items involved. If you have multiple tables being used in a report the filters will be applied to only the tables where a filter definition has been applied. Essentially a filter is a where clause on the table.
It isn't possible to have a filter that applies to all the tables "at once". If you require this, it is best to join the tables outside of SAS VA and load the combined table into memory.
Thank you,
I think I understand. If I make the filter
Country = USA.
If I defined in table1 and table2 the filter. each table is then filtered by the filter USA
It is correct?
Thank you and sorry for the inconvenience.
Not exactly...
The filter Country=USA for table1 will only subset the data in table1. Creating a Country=USA on table2 means you are using the Country column from table2 will subset the data in table2 only. You have to create filters per table, even though the column may exist in each table.
Hope this helps.
As previously stated a filter is a where clause for a specific table. I suggest you read the Working with Filters section in the SAS Visual Analytics User Guide and trying it out in your own environment http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#n0t60h2we10v5pn192cle...
Kind Regards,
Michelle
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.