Dynamic Carousel Bar Chart

1. Problem description

When the data source contains categories, series, and time dimensions, it is desirable to rotate the chart data in ascending order of time, as shown in the following figure:

2. Implementation ideas

Set the time parameter in the SQL query statement to filter the data, the value of the time parameter will change with time, and then refresh the chart regularly.

1. Data Preparation

Create a new dashoboard, create a data set ds1, and the database query statement is as follows:

SELECT 

Owner_city,

strftime('%Y-%m',Order_date) YEARMONTH,

sum(Shipping_fee) Shipping_fee

FROM SIndent

where strftime('%Y-%m',Order_date)='${left(monthdelta("2011-01-01",mod((datetonumber(now())-datetonumber(a))/1000,12)),7)}'

group by Owner_city,strftime('%Y-%m',Order_date)

order by Shipping_fee

2. Report Design

1) Click on the menu barTemplates > Template Parameter, create a new default value=nowThe template parameter ofa.

2) The layout of the dashoboard body component is changed toAbsolute Layout, dragged into the main body of the dashoboard designBar Chart, bind data information as shown below.

3) Bar chartStylechooseTitle, checkShow Title, the title content fills in the formulaUNIQUEARRAY(ds1.select("YearMonth")), and set the suspension position x direction50%, y direction50%, the characters are16font.

4) Bar chartStylechooseLegend, uncheckedLegend Is Visible.

5) Bar ChartStylechooseLabel, checkUseLabel, the text is checkedValue, the location is set toOutside.

6) Add timed refresh, bar graphSpecial EffectschooseInteraction ,Turn OnBackground detection, the time interval is1 second.

3. Effect preview

1) The effect on the PC terminal is as shown in the figure below:

2) The effect of the mobile terminal is shown in the following figure:

The completed template can be found at:%FR_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\Dashboard\Dynamic_Carousel_Bar_Chart.frm

Click to download the template: Dynamic_Carousel_Bar_Chart.frm