Salta al contenuto

Documentation BI4H (EN)Documentation BI4H (EN)

  • Quick Start
  • Navigation
  • Interactions
  • Charts
  • Tables
  • Filters
  • Modules
  • Data Explorer
  • Self service
  • Quick Start
  • Navigation
  • Interactions
  • Charts
  • Tables
  • Filters
  • Modules
  • Data Explorer
  • Self service
  • Quick start

    • Start up

    • Profile

    • Top tool bar

      • Change theme layout
      • Language selection
    • Elements of BI4H

    • What is the HUB

    • What is the APP

    • What is a module

  • Navigation

    • Tiles & child buttons

    • Navigation bar

    • Stepper

    • Sidenav

    • Bookmarks

    • Schedule

    • Global search

  • Interactions

    • Point & click interaction

    • Change chart type

    • Export widgets

    • Fullscreen

    • Additional details

    • Modal windows

  • Charts

    • Lines

    • Colums

    • Composed lines-columns

    • Bars

    • Area

    • Bubble

    • Pie

    • Heatmap

    • Funnel

    • Treemap

    • Geographical maps

    • Gauge

    • Scatter plot

    • Range

    • Sankey

    • Radar

  • Grids

    • Grids option

    • Simple grids

    • Group grids

    • Pivot

  • Filters

    • Smart Filter Bar

    • Filter layout

      • Single filter
      • Group filter
      • Expanded filter
      • Tree filter
      • Builder filter
      • Search filter
    • Filter types

    • Filter options

    • Interactions

  • Modules

    • Numbers

    • Tab

    • Buttons

    • List Indicator

    • Street maps

    • Aid to interpretation

  • Data Explorer

    • Introduction

    • Configuration

      • Edit module -> Generals
      • Edit module -> Aspect
      • Edit module -> Sharing
    • Create a new query

      • Add fields from Univers
      • Add fields from tables/snippets
      • Conditions sections
      • Advanced mode
    • Existing query

      • Run an existing query
      • Create a query using existing query
    • Sharing

      • Share a query
      • Run a shared query
    • Export results

    • Query category

  • Self service

    • Your first dashboard

      • Adding a new page to the app
      • Adding modules to the page
    • Edit Module -> DATA tab

      • Dimension & Alternative Dimension
      • Measures & Alternatives Measures
      • Categories for alternative data
      • Name of dimensions & Measures
      • Sorting of Dimensions & Measures
      • Visibility of Dimensions & Measures
      • Measures Formatting
      • Measures Threshold
    • Edit Module -> ASPECT tab

      • Title customization
      • Show Legend & Customization
      • Box colors
      • Split module
      • Box Options
      • X Axis
      • Y Axis
      • Chart Colors
      • Type (Rotate, Invert, stack)
      • Zoom
      • Tooltip
      • Average
      • Values
      • Change type
      • Other (Aspect)
    • Edit Module -> INTERACTIVITY tab

      • Action
      • Filters
      • Data
      • Other (Interactivity)
    • Edit page - Generals tab

    • Edit page - Options tab

      • Options (Page)
      • Filters (Page)
    • Edit page - Info tab

    • Edit page - Other tab

    • Rendering examples

      • Column chart combined with a line
      • Stacked chart
      • Chart with opposite axis
      • Chart with a constant line
  1. Docs
  2. Self service
  3. Data

Data

Reading time:

Optional where condition

Here you can add a where condition to the query used to initialize the widget if needed. Clickhouse SQL syntax required, The syntax is similar to SQL Server.

e.g.


Limit

You can limit the number of rows to be displayed, for example, we have this chart : number of stays by type, but I'd like to display only the first 3 types with the highest number of stays,

To achieve this display,

  1. Under Measure set Descending order as order
  2. Under Dimension, set None as order
  3. Set 3 to limit


If you enable Group data, and set 3 to limit the number of rows, the 2 first types will be displayed and the other types will be grouped with others.


Exclude hidden data

As you know, we can hide a dimension or a measure from a widget with the below option.

This action only hides the dimension from display, but it is still present in the query, which can sometimes make the results hard to understand. See this example.

We have a widget with two dimensions: stay type and stay month. The second dimension is hidden, and the measure is sorted in descending order. But if you look at the results, the order seems weird. Indeed, the sorting is done on the combination of stay type and stay month, even if stay month is hidden in the widget, 


What we need is to sort only by stay type, in this case, we can activate the ' Exclude hidden data', the hidden dimension will be excluded from the query.

Here is the result after enabling the option.


Custom data snippet (Advances level)

Create PHP snippets, not using a query but PHP code to execute code.There's a flag in Admin hub in order to enable the PHP snippet creation.

Result mapping function (Advanced level)

You can manupulate via JS the query result before visualizing them in the widgt. it can change the values in the JSON and you can edit the whole result set at once, Custom formatting enables you to edit one value at time instead.


Last update: 25 November 2024
Views: 135

© 2025 Documentation BI4H (EN)

Powered by WordPress

All'inizio ↑ Su ↑