Skip to main content
Solved

IFS APPS 10 - LOBBY - BAR CHART ELEMENT - TOP -N MISSING

  • June 18, 2021
  • 2 replies
  • 501 views

randallkern
Sidekick (Customer)
Forum|alt.badge.img+6

Any idea why IFS created bar chart elements in a lobby have a use TOP N option, but when I create one the option isn’t there? 

 

Best answer by Imal Thiunuwan

Hello @randallkern,

Before approaching bar chart configuration, it should be mentioned that the correct data source configuration is required for a chart to display a valid visualization. You should define a data source by setting the columns with their correct data types in order to meet the expected outcome when it is used in a chart. When using a correctly configured data source for a chart, you will select X and Y axes columns. Y axis column is generally expected to be numerical since this will be used to for formatting/aggregation operations. Lobby element designer suggests the column with the most appropriate data type by highlighting them in bold when using the X and Y axes column drop-downs.

 

As @Novishan Dissanayake mentioned, TopN is enabled for bar charts by default, and it uses to control the amount of data fetched from the database. So, if you configure the data source correctly as mentioned above, the TOP-N option will be available.

Cheers!

This topic has been closed for replies.

2 replies

Novishan Dissanayake
Hero (Partner)
Forum|alt.badge.img+13

Hi @randallkern,

 

‘TopN’ is enabled for bar charts by default. This is to control the amount of data fetched from the database. TopN will show the assigned Threshold value of it.

 

Cheers!

Novishan


Imal Thiunuwan
Superhero (Employee)
Forum|alt.badge.img+16
  • Superhero (Employee)
  • Answer
  • June 18, 2021

Hello @randallkern,

Before approaching bar chart configuration, it should be mentioned that the correct data source configuration is required for a chart to display a valid visualization. You should define a data source by setting the columns with their correct data types in order to meet the expected outcome when it is used in a chart. When using a correctly configured data source for a chart, you will select X and Y axes columns. Y axis column is generally expected to be numerical since this will be used to for formatting/aggregation operations. Lobby element designer suggests the column with the most appropriate data type by highlighting them in bold when using the X and Y axes column drop-downs.

 

As @Novishan Dissanayake mentioned, TopN is enabled for bar charts by default, and it uses to control the amount of data fetched from the database. So, if you configure the data source correctly as mentioned above, the TOP-N option will be available.

Cheers!