Forum Discussion

AnnaNguyen's avatar
AnnaNguyen
Data Storage
12-09-2023

How to use Blox to incorporate dynamic count based on Sisense functions to TextBlock

To add dynamic count Count([id]) to the widget, I just simply type {panel:Count} (screenshot 1).   For complex Sisense function (please see my screenshot 2 below) like this one: avg(DDiff([Da...
Blox
dashboards & reporting
soniya01's avatar
soniya01
Data Storage
12-09-2023

  1. Data Preparation:

    • Ensure that your data source is connected and contains the information you want to count.

  2. Create a Metric or Measure:

    • In Sisense, create a metric or measure using Sisense functions to calculate the count dynamically. For example, if you want to count the number of orders, you might use a function like COUNT([OrderID]).

  3. Add a TextBlock:

    • In your Sisense dashboard, add a TextBlock widget or element where you want to display the dynamic count.

  4. Bind TextBlock to the Metric:

    • Configure the TextBlock to be dynamically linked to the metric or measure you created. This typically involves using a binding or referencing the metric directly.

  5. Refresh and Display:

    • Save your changes and refresh the dashboard. The TextBlock should now display the dynamic count based on the Sisense function.
  • AnnaNguyen's avatar
    AnnaNguyen
    Data Storage
    12-10-2023

    Thank you for the response, this is very helpful for me. While this helps me add Blox widget with a simple Sisense function such as counting COUNT([OrderID]), I can just simply do "text": "{panel:Count}". 

    However, for complex Sisense function (please see my screenshot 2 above) like this one: avg(DDiff([Days in benefit_effective_date],[Days in birth_date])), each record ID will have this function applied (i.e. record ID 1 with ddiff is 200, record ID 2 with ddiff is 100, record ID 3 with ddiff is -100, etc), and I want to get count of all record IDs where each of their avg(DDiff([Days in benefit_effective_date],[Days in birth_date])) LESS THAN 0, in that case, how do I add it to Sisense Blox textblock widget?