Hello everybody, the source properties of a column was change from string (original format) to float. The column contains data like "8,5" but in Birst, data became "85". Is there a solution to get the information with the right format ? Thnaks ind advance for you Help
New to BIRST so still exploring options: If you create a report or a dashboard and it gets deleted by mistake, does it end up in a Recycle Bin so the developer can restore it from there?
I feel like I should already know the answer to this one but I am hitting a brick wall and need some expert assistance. I want to display all values from a dashboard filter on a designer report but am getting an error. The code I am using is GetPromptValue('Veteran.Veteran Code Description') Which works for a single value…
Hello, We have a requirement where a third-party system will send a zipped file, and we need a method to unzip these files for further reading and processing. Could you provide insights on how to achieve this using Landmark, IPA, or ION in FSM?
How do you make a repository variable available in a consumer space? Is there something that triggers this? It seems I always have to wait/click around for a while until it shows up, but not sure if there's a defined way to make this happen. Keep in mind this is a consumer space with no model. Thanks
Is it possible to apply a style sheet to the reports created in Birst? I have a client who is interested in applying the same fonts, colors, etc. automatically whenever a new report is created.
I've tried using REPLACEALL and am not having much luck as I do with other characters. Does anyone know how I can clear a string containing these characters " \
I have the following in a SELECT - SELECT [Level(Employee.Employee).Employee Key], [Level(Employee.Employee).Termination Date] FROM [Level(Employee.Employee)] LEFT OUTER JOIN SELECT [Level(Employee Work Assignment Actions.Employee Work Assignment Actions).Reason Code] FROM [Level(Employee Work Assignment Actions.Employee…
I have a scripted source (e.g. fact_update) that will update the fact table (e.g. fact_table) with multiple column keys and dates (analysed by date). I only need to update the measure deleted_flag to 1 (for some records) and then another scripted spurce (e.g. delete_record) to execute the DELETE FROM. Given that these…
Is there a good way to add/subtract quarters from the current date? For example, sales 1 quarter ago, sales this quarter, sales next quarter, etc.. I noticed that you can't use Quarter Seq Number in the date functions.
It looks like you're new here. Sign in or register to get started.