Difference between revisions of "LatestValues Editor Column Settings Tab"
From dataZoa Wiki
(→Cell Formatting (column N only) buton) |
(→Display Settings:) |
||
| (17 intermediate revisions by the same user not shown) | |||
| Line 21: | Line 21: | ||
</table> | </table> | ||
<br> | <br> | ||
| + | <div class="imgGlyph24 imgHowTo"></div> Notes on Display Settings:<br> | ||
| + | <ul style="margin-left: 3em;"> | ||
| + | <li>When <i>"Latest Values"</i> or <i>"External Data"</i> are selected, the <b>Timespan</b> (offset) and <b>Arrows</b> settings have no effect. The most recent values are always displayed.</li> | ||
| + | <li>When <i>"Prior Values"</i> is selected, the <b>Arrows</b> setting has no effect.</li> | ||
| + | <li>When <i>"Prior Values"</i> are displayed for Weekly data, values and dates shown are for the week inclusive of N periods in the past, and this can have subtle consequences. For example, showing Weekly data for One Month ago may show data in the current or prior calendar month, depending on calendar details.</li> | ||
| + | </ul> | ||
| + | |||
| + | |||
| + | <div class="imgGlyph24 imgIdea"></div><div class="imgGlyph24 imgHowTo"></div> Showing values from unrelated series as a column in a LatestValues Display | ||
| + | <div style="margin-left: 3em;"> | ||
| + | <p>Generally speaking, each column in a LatestValues Display derives from its row Series. By choosing <i>External Data</i> for a column, you can show values from Series that are <i>not</i> among the rows of the display itself.</p> | ||
| + | <p>To designate these External series, you provide the name of a GroupList that lists the Series of interest in the order you like. This column then shows the latest value for each Series in that GroupList.</p> | ||
| + | <p><b>Remember:</b> Changes to the GroupList will affect this embed.</p> | ||
| + | |||
| + | <b>Usage Notes:</b> | ||
| + | <ul> | ||
| + | <li>The dates of the displayed values will match those of the primary data series (seen under "Row Settings").</li> | ||
| + | <li>If the GroupList contains more series then the primary data then the extra series are ignored.</li> | ||
| + | <li>Empty values indicate either a missing series or lack of a value on the specified date.</li> | ||
| + | <li>If all values are empty, check that you have correctly entered the name of a valid, non-empty GroupList.</li> | ||
| + | <li>This data is only exported with the download tool when using the "Only Data as Shown" option.</li> | ||
| + | </ul> | ||
| + | |||
| + | [[LatestValues_Display_External_Data_Example|<b>Example</b>]] | ||
| + | |||
| + | </div> | ||
</div> | </div> | ||
Latest revision as of 11:51, 26 December 2023
Contents
Column Selection
A LatestValues display can have up to 9 columns of data, each of which can be individually specified and formatted. Each column has its own numbered sub-tab indicating what to show and how to show it.
Subtabs: Column 1Column 2Column 9N
Column 1
Column 2
Column 9N
Display Settings:
| Field | Description | Example |
| Display Settings | Year-over-Year, where "down" is good... | |
| Show | What to show; latest, prior, etc | Percent Change |
| Timespan | Number and type of earlier values to show | 1 Year |
| Arrows | Red/Green indicator arrows | Down is Green |
| Date | Show date of the observation right in the column | |
| Units | Show date of the observation right in the column | |
- When "Latest Values" or "External Data" are selected, the Timespan (offset) and Arrows settings have no effect. The most recent values are always displayed.
- When "Prior Values" is selected, the Arrows setting has no effect.
- When "Prior Values" are displayed for Weekly data, values and dates shown are for the week inclusive of N periods in the past, and this can have subtle consequences. For example, showing Weekly data for One Month ago may show data in the current or prior calendar month, depending on calendar details.
Generally speaking, each column in a LatestValues Display derives from its row Series. By choosing External Data for a column, you can show values from Series that are not among the rows of the display itself.
To designate these External series, you provide the name of a GroupList that lists the Series of interest in the order you like. This column then shows the latest value for each Series in that GroupList.
Remember: Changes to the GroupList will affect this embed.
Usage Notes:
- The dates of the displayed values will match those of the primary data series (seen under "Row Settings").
- If the GroupList contains more series then the primary data then the extra series are ignored.
- Empty values indicate either a missing series or lack of a value on the specified date.
- If all values are empty, check that you have correctly entered the name of a valid, non-empty GroupList.
- This data is only exported with the download tool when using the "Only Data as Shown" option.
Header Settings:
| Field | Description | Example |
| Display Settings | ||
| Custom Label | Free text/(limited)html | Y/Y % Chg |
| Show Header | Show or suppress column header entirely | |
Cell Formatting (column N only) button
Tabular displays have highly refined formatting options. This tab controls formatting for the selected row. All rows can be formatted at once in the LatestValues Settings tab. Read about the cell formatting tab here.
