Hi,My apologies in advance for the length of the question - I couldn't figure out how to make it shorter.
I am trying to create an exhibit of customer data for "higher-ups". I have 8 quarters of data so far, and will be appending more with each passing quarter. The overall population of customers numbers 400-550, with around 200 of those buying product each and every quarter. Each quarter's data is initially captured in excel and, beyond the customers, consists of revenue and gp (gross profit) dollar amount columns and an ordinal ranking for that customer for each of the two measures. It is a requirement to be able to compare year over year (like quarter) changes in some, if not all, of the measures. I can either do that as formula columns in my spreadsheet or as functions in my exhibit( thoughts?). As you can see I will basically have the same "properties" for each quarter: rev$; gp$; rev rank; gp rank; and then any formula columns I may use. So, my question is, what is the best way to handle this? If I add the values as individual columns, I am concerned my dataset may eventually get too large. If, for each quarter, I add a column (property) like "Q4-09" with a value for each customer like "1 - 22,000,000 - 3 - 1,750,000" (rank - rev amount - rank - gp amount), how will the user "massage" the data? i.e. compare, say Q4-08 to Q4-09. Again, sorry for being so verbose, and sorry if I have been unclear. I work at a company that is rather backward when it comes to web technologies and would like to demonstrate the usefulness of the semantic web and the tools available. As you can see my conundrum is the similarity of each quarter's data. Thank you in advance for any and all help you may offer. Best Regards, Kirk --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SIMILE Widgets" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/simile-widgets?hl=en -~----------~----~----~----~------~----~------~--~---
