[Help Request] - Creating an Indicator with the SUM of a Calculated Field

Good afternoon, 

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

TOTAL:                                                                                                                                              1,280

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?

Thanks!

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
Комментариев: 9

Hi!

You have to add, to formula this info, to get the value of each row.

([Project ID],[Total Estimated Annual # of Devices/Parts Effected)*([Project ID],[Totale Estimated Service Pricing])

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hey Pietro, 

I tried this version of the formula but unfortunately it is still producing the same results of my initial attempt and not taking the sum of each calculated field individually. 

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hi Cody,

very strange.

Can you share some screen, so I can help you.

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Just a heads up if anyone sees this, calculated custom fields can be added as dimensions in Wrike Analyze so there is no need to re-create the formula itself on a widget. 

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hurray! This is a new update I am assuming, since calculated custom fields could NOT be added as dimensions earlier? 

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
Avatar
Juan

Hi Komal Thukral, thank you for chiming in, we are checking this information with our Product Team to provide you with an accurate reply. We will share an update with you in this thread.
 
In the meantime, please feel free to learn more about other updates related to Wrike Analyze announced in this recent post in our Weekly Release Notes forum 🙂 If you have any additional questions, please let us know.
0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hey Komal!

Sorry for the delayed response. I actually submitted a help desk ticket based on this post and they informed me that I could add calculated custom fields directly now so it must be relatively new?

If you navigate to the Wrike Help Center and click "Submit a Request" you should be able to see the form shown in the picture below and under "Catagory" go to "Wrike Analyze" --> "Add Custom Field as Dimension". From there I just requested my calculated fields, and they were added to Analyze. 

 

Hope this Helps!

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
Avatar
Juan

Hi Cody Weber, thank you very much for sharing this information with the Community. Komal Thukral, in case you need to contact our Support Team, you can submit a request here:
 
 
We will get back to you once we receive a confirmation from our Product Development Team to provide you with an accurate reply. Thank you!
0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
Avatar
Juan

Hi everyone! After checking this information with the Product Team, I can confirm that calculated fields can now be added as dimensions to Wrike Analyze. If you have any questions about this option, please let us know 👍

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: [Help Request] - Creating an Indicator with the SUM of a Calculated Field
[this list is visible for admins and agents only]

Вверх
Didn’t find what you were looking for? Write new post