How to multiply between two values in eazybi?

Yousif Al Rawahi March 24, 2024

How to multiply between 'Laptops and Tabs Price' (which displays the price of each model) and 'Objects created' (which displays number of each model created) in eazybi?

What I want is the total price of each model based on how many objects created.

And as you can see, in 'HP ProBook 450 G6' (and other models), it shows two different prices, is there a way to display separately? 

FYI: 'Laptops and Tabs Price' selected from the Dimensions, and 'Objects created' selected from Measures.

 

Screenshot 2024-03-24 152034.png

2 answers

0 votes
Roberts Čāčus
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 25, 2024

Hi @Yousif Al Rawahi

The value of Laptops and Tabs price is numeric. I recommend importing it as a measure. After that, you can use the "Laptops and Tabs price sum" measure to view the total from all applicable Assets objects. See an example below, where I have the "Rate" attribute from "Person" type objects imported as a dimension and measure:

SCR-20240325-mrnw.png

With the measure "Person Rate sum" there is no need to define additional calculations. Please visit the eazyBI documentation page for more details on how numeric attributes are imported in Measureshttps://docs.eazybi.com/eazybi/data-import/data-from-jira/assets#Assets-Measures.

Best,

Roberts // support@eazybi.com

Yousif Al Rawahi March 25, 2024

In Jira Assets, I have a list of all models of laptops in one table as shown below. Total 407 laptops with different models.

Screenshot 2024-03-26 094325.png

In eazybi, I grouped the laptops by models by importing as Dimensions, and dragged to Rows, and selected 'Object Laptops and Tabs Price' as Measures, but it doesn't display any value. I believe this is due to price will display of each model only, not the grouped ones, right?

Screenshot 2024-03-26 100410.png

Is there a way to display to solve this?

Roberts Čāčus
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 25, 2024

Hi @Yousif Al Rawahi 

"Object Laptops and Tabs Price" is a property for individual Object dimension members. To see the value of this property, you would need each laptop and tablet type object member in the rows.

Please see if you can select the "Price" attribute for import as a measure in the eazyBI import options. Or see in Measures whether it is already imported as a measure "Laptops and Tabs Price sum".

Best,
Roberts // support@eazybi.com

0 votes
Walter Buggenhout
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 24, 2024

Hi @Yousif Al Rawahi,

This would be a fairly simple calculation. In the Measures section of your report (sitting right above the area you included in your screenshot), either select the User defined or Report specific section and add a new calculated measure.

Name it Total Amount (or anything that makes it clear for you what it means) and add the following formula:

[measures].[Laptops and Tabs Price] * [Objects created]

I notice from your screenshot that you seem to have imported the price as a dimension. That is probably because you have set up your data in Jira in such a way that this is coming from a select custom field, but that feels a bit odd for information you would like to use in calculations. If you imported the price value as a property, you could also try to solve the calculation like this:

[Laptops and Tabs Price].currentMember.Get('Laptops and Tabs Price') * [Objects created]

As the name of the property (the part in parentheses behing .Get()), make sure to use the name of the custom field you are importing here.

Hope this helps!

Yousif Al Rawahi March 25, 2024

I have used this calculation: [Laptops and Tabs Price].currentMember.Get('Laptops and Tabs Price') * [Objects created], but it says (Formula is not valid:
MDX object '[Objects created]' not found in cube 'Assets'). So I [Measure] before [Objects created], it shows no error but it doesn't display any value.

Have I missed something?

Suggest an answer

Log in or Sign up to answer