Has anybody else experienced hover pop ups that will not go away? I am seeing them in Visualizer and Dashboards with more and more frequency. I am also seeing pop ups that have nothing to do with the report I am viewing. For example, the below pop up looks like it should be on a bar chart but the report in question was…
Hi there After the LN Analytics update was run at a client, the reports/dashboards no longer have Time dimension drilling available. Even when creating a new Visualizer report, the attribute Year\Month is static and cannot be drilled. Has anyone else experienced same? Is there a resolution on how I can fix this? Thank you…
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?
It looks like you're new here. Sign in or register to get started.