Superimposed Data Visualization for Multiple Time Periods

In data visualization, superimposing data from different time periods can provide valuable insights and facilitate comparative analysis. This article outlines the steps to create a data source with multiple years and configure a widget to display superimposed data effectively.

Steps to Create Superimposed Data

1. Create a Data Source:

   • Prepare a data source that includes data for three different years. For example, you can use data from 2022, 2023, and 2024.

2. Define Expressions:

   • Create an expression to format the date. Use the TO_CHAR function to change the date format to display as day/month. The expression would look like this:

     TO_CHAR([Date], 'MM-DD')
     

3. Column Configuration:
   • Please configure the values section based on your requirement and configure the created expression in the column section . Ensure that the year(Date) field is included in the row section to differentiate between the time periods.
     
     
4. Set Maximum Page Size Limit:
   • To enhance performance and usability, set a maximum page size limit for the widget. This will help manage the amount of data displayed at one time.
     
     
5. Visualize the Data:
   • After configuring the widget, you will be able to see the superimposed data for the three different time periods. This visualization will allow for easy comparison and analysis of trends over the selected years.

Example Visualization

The final output will display the superimposed data for the specified years, allowing for a clear visual comparison.

Additional References

• BoldBI Documentation
• Data Visualization Best Practices
• SQL Date Functions