Customizing Measure Options - Capabiltities?

Hello,

I see there are various options to aggregate data 'Measure' Column Types once they are brought into the data model while in the Visualizer Tab space, creating reports, however I have not stumbled upon any option to extend functionality of measures and build more custom measures report side like 'rolling 3 month sales average', 'Month over Month Sales Difference' or any static measures that if displayed on a dashboard, would possibly not respect a time filter if selected where appropriate.

Any documentation or feedback pointing me in the right direction is much appreciated! Thank You

Find more posts tagged with

Comments

Dan Rosen

You can use BQL expressions and familiarize yourself with the various date functions and built in date hierarchy in Birst.

For example, rolling 3 month sales average (assuming current is not included) could be something like:

([Sales Date: Sum: Sales] where [Time.Months Ago] >=1 and [Time.Months Ago] <=3) / 3

If you want something on a dashboard to not respect a time filter, in edit mode on the dashboard click on the filter from the list and it will show a filter icon on the corner of dashlets where that filter is applied... you can click on a dashlet and that icon will disappear signifying that it won't use that filter

Legacy Contributor

Thank You! I will revisit the Modeler -> Prepare -> Script BQL layer to look at building some out. Appreciate the fast response!

Dan Rosen

One thing to note is that BQL in the prepare scripting is a slightly different syntax than in the visualizer expressions. For example, your sales column in a report may be [Sales Date: Sum: Sales] but in prepare it would be something like [SalesSource.Sales]

Also, an easy way to learn what date elements are available is to hop on visualizer, go to the time hierarchy (folder) and add everything. Then you can see how the various fields relate to the standard date field

Copyright © 2025 Infor. All rights reserved.