Convert a Characteristic into a Key Figure (BEx)

本文详细介绍了如何在BEx查询中利用特性进行计算与公式操作,包括创建新公式、变量,以及如何正确配置特性作为关键指标。通过实例演示了如何将日期特性用于计算差异,并说明了在不同场景下使用特性的具体步骤。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

This is a very simple document to demonstrate how to use characteristics in a BEx Query as a part of a calculation.

Example: There are two date: Start Date & End Date (characteristics) in the query and we want to use the difference [End Date - Start Date] in a calculation.

 

So how to we use a data or any other characteristic in a Formula?

I will explain the same step by step with screenshots.

Here I take an example as a Date.

 

Step 1: Create a new formula.

Step 2: Create a new Formula Variable.

Step 3: Change the Processing Type to "Replacement Path" and select the characteristic to the characteristic which we need as a key figure.

Note: Make sure the characteristic or the part of the characteristic which you want to use as a key figure is numeric.

Step 4: Go to the "Replacement Path" tab and Select the "Replace with" value as "Key".

Here in the "Offset Setting", you can specify the offset (position of the character) and the "Offset Length" from where you want to use the value as a key figure.

Example: Date is "20120415" (YYYYMMDD) and let's say you want to use the "Day" part of the date as a key figure. I.e. 15. So you set the Offset start as 7 and Offset Length as 2. If you to use the whole date as keyfigure, You can use "Offset Start" as 0 and Offset length as 8.

OR

Step 5: In the formula created in Step 1, insert the formula variable which we created and we have the characteristic ready to be used as a key figure or for calculations.

We can use the same procedure show above to use any characteristic as a key figure.

 

内容概要:该研究通过在黑龙江省某示范村进行24小时实地测试,比较了燃煤炉具与自动/手动进料生物质炉具的污染物排放特征。结果显示,生物质炉具相比燃煤炉具显著降低了PM2.5、CO和SO2的排放(自动进料分别降低41.2%、54.3%、40.0%;手动进料降低35.3%、22.1%、20.0%),但NOx排放未降低甚至有所增加。研究还发现,经济性和便利性是影响生物质炉具推广的重要因素。该研究不仅提供了实际排放数据支持,还通过Python代码详细复现了排放特征比较、减排效果计算和结果可视化,进一步探讨了燃料性质、动态排放特征、碳平衡计算以及政策建议。 适合人群:从事环境科学研究的学者、政府环保部门工作人员、能源政策制定者、关注农村能源转型的社会人士。 使用场景及目标:①评估生物质炉具在农村地区的推广潜力;②为政策制定者提供科学依据,优化补贴政策;③帮助研究人员深入了解生物质炉具的排放特征和技术改进方向;④为企业研发更高效的生物质炉具提供参考。 其他说明:该研究通过大量数据分析和模拟,揭示了生物质炉具在实际应用中的优点和挑战,特别是NOx排放增加的问题。研究还提出了多项具体的技术改进方向和政策建议,如优化进料方式、提高热效率、建设本地颗粒厂等,为生物质炉具的广泛推广提供了可行路径。此外,研究还开发了一个智能政策建议生成系统,可以根据不同地区的特征定制化生成政策建议,为农村能源转型提供了有力支持。
### GATT Characteristic 2A1A Definition and Usage In Bluetooth Low Energy (BLE), characteristics are used within services to define specific properties of data being exchanged between devices. Each characteristic is identified by a unique UUID, which may be either a standard 16-bit or full 128-bit value. The characteristic with the identifier `2A1A` corresponds to the Temperature Measurement characteristic[^4]. This particular characteristic belongs to the Environmental Sensing service and serves as an essential component for applications requiring temperature monitoring capabilities over BLE connections. #### Data Structure and Format Temperature Measurement (`2A1A`) contains information about measured temperatures from sensors connected to the BLE device. According to specifications outlined in official documentation: - **Format:** The format includes flags indicating various aspects such as unit type (Celsius vs Fahrenheit) along with actual measurement values. - **Unit Types Supported:** - Celsius degrees represented using signed integers scaled appropriately based on resolution requirements. For instance, when working with this characteristic programmatically in Android environments, developers would handle updates through callback methods like so: ```java @Override public void onCharacteristicChanged( BluetoothGatt gatt, BluetoothGattCharacteristic characteristic ) { if ("00002a1a-0000-1000-8000-00805f9b34fb".equals(characteristic.getUuid())) { byte[] data = characteristic.getValue(); // Process received temperature data... } } ``` This code snippet demonstrates how one might implement logic inside an overridden method defined within a custom implementation extending `BluetoothGattCallback`. When changes occur at remote endpoints regarding environmental sensing attributes including but not limited to those pertaining specifically towards thermal conditions monitored via sensor readings encoded under said universally recognized identifiers; these events trigger corresponding actions locally upon receipt thereof ensuring real-time synchronization across paired entities participating within wireless communication sessions facilitated through standardized protocols established around Generic Attribute Profiles [^2].
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值