How can I easily see last months value for something like Sales so I can do a month to month comparison when I’m using time as a dimension (where you have Months or Weeks or even Days going across the top of the display)?
It’s easy to do this in Stratum, and there are at least 2 answers to the question:
1. – Use Time Ranges, yeah yeah I know the…[Read more]
An easy way to show only YTD months or weeks when displaying information with the months or weeks going across the top or down the side.
I wanted to add an update to this post. When I initially suggested that you can use an expression to filter the months to only see those months that have passed and the current month, so that the future months…[Read more]
What is the fastest way to export from Stratum to Excel?
Soooo….my first response is always, do you really need to export? Are you just looking for a calc that you are more comfortable with in excel vs. Stratum. If so, it might save you time overall to do the calc once in Stratum then you can use all the flexibility of Stratum to see what you…[Read more]
I’m assuming you have populated the category and are able to see the working days by at least one level – probably by company. If this is not the case the rest of this post won’t help…. The problem comes when you want to look at the working days by another dim, as you mentioned – customer, rep or region, or some combo of those.
Frank, hoping you can provide some insight on how to accomplish this with the system control category. We have requirements to look at the number of working days and so far by customer, rep, region or a combination of them. I am not seeing how you can use the system control value category to correctly total the working days based on the…[Read more]