Hello,
I am trying to create a percentage value I can enter into a horizontal bar speedomenter using the MashZone arithmatic functions. In order to do this, I need my data feed to find the sum of a column of values in an Excel file but cannot figure out how to do this. Can someone please tell me how or if MashZone is capable of doing this?
Thanks,
Thomas
Thomas,
although I do not know your feed in detail there are two operators that tend to be useful in your situation. Both are found in the Calculation category on the data feed editor's left hand panel
- Aggregation might be used to find the sum of a numerical column
- Goal accomplishment might be used to calculate the percentage based on known or dynamically calculated values.
Regards
Stephan
Ok, so I used the aggregation tool like you instructed and it worked. Thanks for the advice!
However, when comparing the numbers MashZone calculates to my manual calculations the results did not match. In some cases the result was close (i.e. 0.07 when it should be 0.05) but in other cases it was far off (i.e. 0.30 when it should be 0.15). I found that this problem was caused when the columns were aggregated. When I pulled up what MashZone calculated I noticed that there is a 100 row rule built into MashZone that does not allow for more than 100 rows to be aggregated at a time. Due to the fact that the majority of my columns contain more than 100 values the results I get when I divide the partially aggregated columns are skewed. Is there a way to successfully aggregate columns with more than 100 rows?