Hello and welcome to the official Birst forum, a part of the Infor OS Platform community. We're excited to have you here and look forward to fostering a collaborative environment where users can share knowledge, ask questions, and explore the capabilities of Birst. 🚀 About This Forum 📌 This forum is dedicated to…
I have a table report that I need to export to excel every month or so. It only has a couple thousand rows, but is 45+ columns wide and has lookuprow expressions which make it very heavy. I find that I have to grab an attribute that has several values and filter one at a time doing an export for each (and even then it…
Hi, I am getting an error "Cannot read properties of null (reading 'indexOf')" when using the STAT() function as my denominator. I even use the IFNULL() and IIF( savedexpression('a') IS NULL, 1, savedexpression('a')) but still getting the same error. Could you help us find a way to avoid this error? Regards, Christian
I am interested in embedding a Birst Dashboard into a Lightning Page. I am able to embed Birst into the Classic Salesforce no problem, but when I try to access it through Lightning, the Server refuses to connect. I am not sure if the rules are different or if Birst does not support Salesforce Lightning.
I have a problem with making filtered KPI expression. The formula below doesn't work. [Recognition Date: # Distinct recognitionHashKey] WHERE [Fiscal Time.Calendar Year] = GetVariable( 'Current Calendar Year' ) AND IIF( 'V{USER_GROUP_LIST}' = 'Admin' OR 'V{USER_GROUP_LIST}' = 'Power User' OR POSITION('V{USER}', [Manager…
I am using a lower grain to lookup a higher grain which results in more than one row in Visualizer. The code is below. There is more than one work unit key per Member Organization (HR Organization Unit Level 2), which is why I am getting duplicate rows. LOOKUPVALUE(0,[Work Unit.Work Unit Key],1,SELECT [HR Organization…
We have deployed several dashboards for HCM and use the standard GHRBirst roles to control access. Specifically we use the GHRBirst-HRGeneralist which allows access to all employees and the GHRBIRST-DirectSupervisor which allows access only to that specific Supervisor's hierarchy. We do have 1 dashboard where we would like…
Hi Team, May I ask what is/are the counterpart function in BIRST ETL script function for UPDATE? Thank you for your inputs
Good afternoon, I'm trying to create a KPI for a dashboard called "Win Rate %." I am trying to take the SUM of the first column (CO Line Flag) and divide it by the count of the 2nd column. So, in the below example it would be 9/10 = 90%. Here is the report expression I'm using the CO Line Flag: IIF([CO Create Date: CO Line…
What is the proper syntax for COUNT DISTINCT in a Prepare Script?
I was told that my ER 109130 (Top N by Selected Attribute) will be archived July 1st if it doesn't receive enough upvotes by June 2nd. It already has 7 upvotes so I'm not sure how many more are needed, but if you can support that would be really helpful, as this is a much needed feature that several of us are interested…
It looks like you're new here. Sign in or register to get started.