[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!
Hi!
You have to add, to formula this info, to get the value of each row.
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.
Hi Cody,
very strange.
Can you share some screen, so I can help you.
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.
Hurray! This is a new update I am assuming, since calculated custom fields could NOT be added as dimensions earlier?
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!
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 👍