I'm trying to compare information in my database choosing any two dates and comparing the information absolute and relative way.
I found a way to choose any two dates and make the absolute comparison but i can´t find how to do the relative comparison (%). Also, i'm showing the information in two tables; one contains the information for both days and the other only has the comparison, that makes the analysis difficult because the user has to scroll both tables.
I'm comparing information that can be added and information that can not be added by sum.
The way to choose both dates is using text input and filtering a table that shows the variables for those days.
For the difference between dates i created a new calculated item that put the information positive for one day and negative for the other, everything else is zero and i use it in a new table aggregating the information.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.