Tags:
• Project Owner
• Creator
• Explorer

In this article:

1. Benefits of Applying a Date Flag
2. Apply a Date Flag
   • Analysis Table
   • Visualize

1. Benefits of Applying a Date Flag

When you flag a standard axis as a Date, Harmoni provides the following benefits:

• The ability to have a rolling reference based on previous x periods.
• Ability to rank by the latest period when it is plotted in the across dimension.
• When dragged as a filter, the last element is applied by default.

2. Apply a Date Flag

When data is brought into Harmoni, time data is usually automatically flagged, but if not, or you need to manually create grouped time periods, any standard axis can be flagged as a date to create a time axis. After creating your axis with time series data and while in edit mode, select the axis and from the design menu, under the flags section, click date.

• Select the axis
• Click flag from the design menu

🔗 Learn how to create a grouped time series using the expression editor.

Analysis Table

When creating an analysis with a time axis in the across dimension, the table automatically scrolls to the far right to show the latest results in view. You can still scroll to the left to see the data across other periods.

 

When the view is saved into a story, the story preview defaults to the latest results. If the view is used in a dashboard, the view will also display the most recent time periods by default.

 

Visualize

When an analysis that includes a time axis in the across is visualized, Harmoni automatically selects a line graph. When the time axis includes more than 13 time periods, the line graph includes a time slider to help you manage large numbers of time periods.

Learn more about line graphs.

Where to from here?

Learn more about Harmoni:

• Project Design - Organize items in your Project Tree
• Project Design - Apply Record View and Card View Flags
• Project Design - Design Menu