NG
When you create a graph and assign formatting to data points on the Y-Axis the formatting works as expected. Large numbers will show up for example as 304,123 or 1,302,109. However the value range on the Y-Axis does not appear to take this formatting into consideration. Is there a way to have the formatting applied against the Y-Axis as well.
Also when downloading an Excel Spreadsheet from SalesForce the file can not be directly accessed from MashZone without first saving into Excel 2002 Format. Current desktop version is Office Excel 2003 SP3.
I am unfamiliar with different versions of Excel's data format but I connot see any differences between 2002 and 2003 and I don't think this affects your problem.
Based on the image you posted I assume that the data feed column that provides values for the horizontal axis is of type Text. The reporting period reads 2009.0-1.0.
Please note that formating is aplicable to typed values only. E.g. to print only year and month of a given value of type Date MashZone needs to understand that this is a date. You can easily ensure your values are typed correctly by inspecting the column header icon within the data feed editor's debug output:
.png)
To present your data properly I may suggest that you make use of the operator Columns > Change data type. Your pattern seems to be yyyy.M for the starting of the reporting period.
Stephan,
Thanks for the response. The column type is number as indicated in the image provided below. I realized the Fiscal Period is incorrect but am not concerned about that right now. Also note that the values are formatted correctly in the image as numbers. In the Excel file the numbers appear properly as well as shown in the second image I am attaching.
As for the Excel issue with the SalesForce export files I will be glad to mail you a sample directly to your IDS Sheet account if you wish to review. My SoftwareAG email is my user name.
Thanks.jpg)
