Certain analyses produce category series – which by design do not keep any time parameters. With below workaround you can pass time information through analyses and show it in Bar chart. Add formulas We have formulas which output time parameters, add needed ones to Series list: week() month() quarter() year() From their output you will … Continue reading “Workaround – Dynamic dates in Bar chart”
Overview How to create a Dashboard? Examples Overview Dashboard can be created from Bar chart using combination of Text, Graph, Symbol columns and Rules applied to them. How to create a Dashboard? Add series and perform calculations. Add Bar chart and open Graph layout (Ctrl+L). Arrange series the way you want. Each section in Graph … Continue reading “Dashboard”
Purpose Creating calculated in-house Adding calculated in-house to a chart Sharing calculated in-house Editing calculated in-house Adding another calculated in-house in same file Changing calculated in-house’s location Deleting calculated in-house Questions Can I connect my calculated in-house series to original file? Can i download in-house series through other Macrobond API (i.e., Python)? Why can’t I … Continue reading “Calculated in-house series – saving your own calculation”
Overview How to create a heatmap? Shortcut from panel from panel Build it Choosing color ranges Two colors Three colors Applying rules to chart Multiple rules Value series Using other series for formatting Examples Questions Can I format within a row instead of a column? Overview You can create a Heatmap by modifying Bar chart … Continue reading “Heatmap”
How to create a dynamic table? Shortcut from panel Build it How to copy a dynamic table? Example You can create tables as reports, using Bar Charts presentations. The table is created using a bar chart with text columns. Below is an example of what the end result might look like. How to create a … Continue reading “Dynamic table”
Overview How to create simple bar chart? Settings Changing default settings Graph layout Graph style Chart size Width Height Text columns Graph columns Symbol columns Legend Conditional formatting True & False – text Many conditions – formatting rules Style sheets What analyses work with this chart type? Examples Questions How to adjust the gap between … Continue reading “Bar chart”
Overview Settings Properties for Table Table layout Additional options Copying the data What analyses work with this chart type? Example Overview When you want to take a close look at individual values in your data, you can view your series in a table. When the series you’re viewing are category series, this will be a … Continue reading “Category table”
Overview Settings Properties for Table Table layout Additional options Copying the data Save series as in-house What analyses work with this chart type? Example Overview When you want to take a close look at individual values in your data, you can view your series in a table. When these are time series, they will be … Continue reading “Time table”