Some sources show missing values as ‘0’, “-” or “n/a”. We always check what each source use for particular data set and unify all those variables into one system. We have two types of missing data in our database: N/A – there should be a value in this point in time but for some reason … Continue reading “Missing values and N/As”
In Macrobond you can select date to indicate point in time with date or you can use a relative shortening to, for example, always show value from one year before the end of series. This can be used everywhere where you see Date box, i.e.; Cross sampling, Observation label. Date Relative Other Date 01.10.1997 the … Continue reading “Indicating point in time”
Class of series What Stock, Flow and steps mean? Annual Rate (AR) and Aggregate series as Stock Can I choose class of series? Can I change class of series? Changing from Flow to Stock (how to decumulate series?) Annual Rate (AR) Prices How to change Current to Constant? (inflation adjusted series) How to change Constant … Continue reading “Class, AR & Prices”
What happens when series is being discontinued? In our database Files saved on Personal/Department/Company Account How to find discontinued series? Add superseded Data-tree Search tab Yellow bar How to connect old series with new one? When the source discontinues its time series, we also change their status in our database. Most series are discontinued because: … Continue reading “Discontinued series”
Core databases Country & Region Special nodes Source & Release Concept & Category Searching & filtering Importance of data (the red exclamation mark) Using search bar Using the tree filter How to filter? Creating a filter Setting the default filter Clear your filter Organizing results Structured view/Flat view Filtering results Shortcuts to access data – … Continue reading “Different views – entry-points and how to work with them”
Overview Filters vs Quick filters Filters Types Predefined & saved Filters Filter list Filter sets How to use Filters? Include, Exclude, Not any & Disable By metadata from a series Quick filters How to use Quick filters? Organizing the results Overview Filters will help to speed up the process of finding the data you want … Continue reading “Using filters”
Browse vs. Analytics How it works Features for navigating data Search tab Release tab This article will introduce you to the fundamentals of finding data in the application. We’ll take a look at the different Activities you can use to find data, which is: The Browse, Analytics, Search and Releases tabs. As we review them, … Continue reading “Finding data – overview”
How to access metadata? What can I find there? Time series Source Release Concept Disappearing metadata Each series has its own metadata containing information about source, frequency, unit, class, currency, inflation adjustment, additional comments, methodology, release dates etc. You can quickly access it from anywhere in the application. How to access metadata? Regardless of which … Continue reading “Time series information – accessing the metadata”
What is Actions ribbon? How are Actions organized? Browse Add to documents Presentation / Dynamic table 12 last observations / Transformations Locate series in tree Releases Search Each Activity tab is like a workspace, with tools and features suited to particular types of tasks. For example, browsing data, or performing analyses. So, what happens if … Continue reading “Using the Actions ribbon”
Overview Creating list from My lists tab Types of lists Concept for Region and child list from Lists tab (on Series list) Adding list to a document Editing list Deleting list Overview You can save list just like in-house series – on Personal, Department or Company account – then use it in other documents and … Continue reading “My lists activity tab”