I am trying to perform either (* or / ) between two records however the output is always 0. However whenever I tried to + or - operations, it works. Lets say: Column 1: Value 20 Column 2: Value 10 I tried this → SavedExpression('Column1')/SavedExpression('Column2') and the output is always 0. What am i doing wrong?
I want to export the dashboard using the top right button that converts it to a printable pdf. This does not work and it shows download failed. What can be the reason for this and how could i fix this?
Quick question. If we have two records going into a script with a source that has 5 columns as the key, but we are only setting up our LK with 4 of the fields. If, within one scripted source run, there is two records as follows, would it insert both as it doesn't know the LK exists in the previous record yet to do an…
Is there a flag field or some other way to identify if the customer is in standard or daylight savings time? I have created a BQL expression for Pacific time using DateAdd which will work until 11/03/2024, when DST ends. DateAdd(Hour,-7,NOW) Ideally I would like to avoid having to edit the expression whenever the time…
I have found an interesting info here: https://dragonden.agiledragongroup.com/c/resources/issue-with-calculated-averages-in-summary It talks about the well-known issues with averages at the Summary level in reports. Specifically, it says: Birst has an account level setting called ‘LegacySummary Flag’. Only Infor can turn…
For the sake of example, I made a table in Visualizer to simply list the line numbers in a sales order. When I check the order in CSD, I see that there are 26 lines (27 including an inactive line). In Birst, only line # 19 is listed. However, if I add a Quantity Ordered column (or other Measure from Sales Order Line) to…
What is the proper syntax for creating multiple IF THEN conditions in a scripted source in Birst? IF [MWRA_Enrollee_file_1.PlanCarrierCode]='A1C' THEN [PlanCarrierCode]='LBAS' ELSE IF [MWRA_Enrollee_file_1.PlanCarrierCode]='A1D' THEN [PlanCarrierCode]='LLTD' ELSE [PlanCarrierCode]=[MWRA_Enrollee_file_1.PlanCarrierCode] END…
2025-01-15 20:17:02,761+0000 INFO - Finished ST_ICSEU_CS 2025-01-15 20:17:02,818+0000 INFO - Loading directly from script output - ICSEU_CS.txt.tmp 2025-01-15 20:17:02,828+0000 INFO - Bulk loading staging table ST_ICSEU_CS from source file C:/Birst1/Production/[CUSTOMER_PRD-SX-Source]/data/ICSEU_CS.txt.tmp 2025-01-15…
Is there a way to make tables within your birst dashboard ignore embedded filters so if you filter the table stays untouched?
Hello, I would like to modify the Perfect Line expression on my custom space, but I have no idea how I can summarize the Net Amount LC based on the sasa Shortage: MAX([sasaPlanned Receipt Date: Sum: sasa Net Amount LC] - [sasa Planned Receipt Date: Sum:sasa Shortage] - SAVEDEXPRESSION('sasa Late'), 0) I also tried to…
It looks like you're new here. Sign in or register to get started.