Last updated
Last updated
Improve new style for chart list when user clicks on dropdown list "Add a chart"
Color your data based on logical conditions.
You can set the font and background colors used in your charts based on the data. For example, if the Campaign is "Summer Sale," then set the entire table row font color to green, or if Clicks is less than 100, set the scorecard background color to red.
The dimension value color map is a table of the dimension values that appear in your report, with an associated color for each value. Charts that use the color by dimension values option get their colors from this map. The dimension value color map is created automatically from the data in your report. You can also edit the map directly to add values and change colors.
Dimensional value color map is only available in line-chart (use Breakdown Dimension), Bar Chart (use Breakdown Dimension), Area Chart, Pie Chart, Scatter Chart (Double Colors is another value "none").
Allow uploading multiple files with the same structure: Column type, ...
Tracking Action Log with the file name when it fails or succeeds.
The calculation rule:
Get the maximum value of all metrics
Take the min value in the above result as Y on the left, take the max value of the above result as Y on the right.
Remaining metrics: calculate the shortest distance with left Y and right Y to choose the right axis.
List of datasources: KiotViet, Haravan, Tiki, Sapo, Lazada, Shopee, FB ADS, GG ADS, BO report, Save data Big table/dynamic table
Add button Notification setting.
Click a button, pop-up Notification setting will be displayed.
The pop-up allows the user to customize to send an email and notify when the data pull job succeeds/fails.
By default, select all options and enter the email owner of the data source.
Keep List view mode or Grid view mode if it was selected before
A trendline is a line superimposed on a chart revealing the overall direction of the data. Insight supports three types of trendlines: linear, polynomial, and exponential.
A linear trendline is the straight line that most closely approximates the data in the chart. (To be precise, it's the line that minimizes the sum of squared distances from every point to it.)
If your data is best explained by an exponential of the form eax+b, you can use an exponential trendline to show the direction of your data.
A polynomial trendline displays data directionality as a curved line. It can be useful for analyzing large, highly variable data series.
Highlight values of interest in your charts and visualize progress towards your goals.
Reference lines show how the data in a chart compares to a reference value. For example, you can use reference lines to visualize daily sales against a target sales figure, or show the average revenue per store and compare each store to that average.
Add “Analysis” parent menu, including 3 submenus: SQL Workspace Data Explorer Schedule Query
Left panel:
(1) List of Business Objects tables
(2) List of Event tables corresponding to Source
(3) List of Analytic tables created by (6)
(4) Clicking on a table will open table detail Tab
(5) Hover on a table will show Ellipsis, clicking on Ellipsis will show 3 actions: Open, Query, Delete (Only show when it is an analytic table)
(6) Add an Analytic table button. Clicking on will open create analytic table popup
Table details: List of columns are attributes of BO/Event
Create analytic table
Add field: Add columns to an analytic table
Query Editor: Input query
Query result: After the user inputs query and clicking on Run button
Save Queries: Listing Saved queries
Explore Data: The same Explorer project, Available fields and Data are columns of Query Result (Only enable Expore data button when successfully run query)
Save result: Save data from Query result to Analytic table (Only enable Expore data button when successfully run query)
(1) Select Analytic table to Save result
(2) Mapping columns of Query result with selected Analytic table
(3) Write mode: Methods of processing and storing data
Schedule: Set up a schedule to execute the query and save results into the Analytics table (Only enable Explore data button when successfully running query)
(1) Schedule name
(2) Select Analytic table to Save result after executing query
(3) Mapping columns of Query result with selected Analytic table
(4) Write mode: Methods of processing and storing data
(5) Set up a schedule to execute the query and save results into the Analytics table
(6) Send email/notification after the schedule runs completely
Schedule query: List of created Schedule Query
Run history