User Profile

AnnaNguyen

Data Storage

Joined 3 years ago

4 Posts

View All Badges

User Widgets

Contributions

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([Days in effective_end_date],[Days in effective_start_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 effective_end_date],[Days in effective_start_date])) IS LESS THAN 0, in that case, how do I add it to Sisense Blox textblock widget? Thanks for reviewing. Please let me know if more clarity or verbal talk is needed.
12-11-2023 Place Build Analytics
Blox
dashboards & reporting
1.6KViews
0likes
2Comments
Re: How to use Blox to incorporate dynamic count based on Sisense functions to TextBlock
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?
12-10-2023 Place Build Analytics
1.5KViews
0likes
0Comments
How to get list of dashboards and custom table(s) that are used in each dashboard?
I have figured out how to get list of custom tables in Sisense by connecting to MongoDB server and prismWebDB database. But then I run into some issues and would like to get guidance from the Community: I get list of custom tables from DatasetTables table but I’m not sure how to identify what custom tables come from which cube? Is there an accurate identifier of some sort that I can use? There’s a table named Elasticube, joins with datasets table on oid = elasticube but I’m not sure if this will give accurate table location. I get list of dashboards from Dashboards table and filter on datasource_title to get dashboard names from a specific Sisense cube. Are there any columns from this table or other tables I can use to get list of dashboards and custom table(s) that are used in each dashboard? If so, how is Dashboard table and the other table connected on what inner join? Thank you for the suggestion.
11-21-2023 Place Build Analytics
dashboards & reporting
data models
1.1KViews
0likes
0Comments
What is the alternative to LENGTH function when building a dashboard?
I have been tasked with building a report and one of the requirements is to filter individuals with name that exceed 32 characters maximum. In SQL query, I can do this with a combination of CASE WHEN and LENGTH functions, but in Sisense I saw that this functions only available in the cube and not in the dashboard so I'm wondering if there is an alternative to this? Because I tried to avoid adding custom columns to the cube so that not to harm the production database so any chance I can achieve this in the dashboard would be great.
03-06-2023 Place Build Analytics
dashboards & reporting
1.4KViews
0likes
1Comment