We are making an Analytics board and looking to create an indicator widget that can give us the sum of a set of calculated fields for a list of projects in a folder.
Since you can't import calculated custom fields as dimensions in Analyze, you need to re-create them in your Widget.
The formula we are trying to re-create is:
Number of Devices Effected (Dimension) * Service Pricing (Dimension) = Revenue Generated (Calculated Custom Field)
For example. in a table view it would look like this:
Name Number of Devices Effected Service Pricing Revenue Generated
Project 1 10 100 1000
Project 2 5 50 250
Project 3 3 10 30
How should we go about creating an indicator widget that would show the value of 1,280 above?
I have tried the below formula, but it is taking the sum of each column and multiplying them together instead of multiplying each column first and then taking the sum of the calculated fields.
For our example, with the given numbers, the above formula is returning a value of:
(10+5+3) * (100+50+10) = 2,880, which is not the correct value we are looking for.
Does anyone have experience with doing something like this with an indicator widget?