"Creating a dashboard"

PeterSu80
PeterSu80 New Altair Community Member
edited November 5 in Community Q&A
I am working with a MySQL database that is collecting revenue information by transaction and by location. I hope to create a dashboard that can automatically show trend data like: Last 12mo total revenue, last 7 days, and be able to filter the charts by the city the sale happened. I run any major statistical packages on are there are tutorials that aim more for this purpose (most tutorials ive seen are more for complex and predictive analysis)?

Thanks!
Tagged:

Answers

  • JEdward
    JEdward New Altair Community Member
    Are you meaning the dashboards & reports you can create with RapidAnalytics? 
    http://rapid-i.com/content/view/305/232/lang,en/
  • PeterSu80
    PeterSu80 New Altair Community Member
    Indeed, but the one area I am having particular trouble with is how to set a range. I have a dataset where I hope to make the transaction date the ID. Eventually I want to be able to then filter out the last 7 days worth of transactions and add together in a "last 7 day revenue" type of figure (it be awesome if I could have it recognize today and run back 7 days), but if it has to be manually inputted every time (through a macro or something else) that should be fine for now.
  • land
    land New Altair Community Member
    Hi Peter,
    that is easily possible with for example Generate Attributes. You can do there complex date operations and create a column named for example "keep" and put in a value "yes" or "no". and then Filter accordingly using a Filter Examples with Value Filter.

    You might know, our enterprise editions contain support with guaranteed information time. You would have had a solution for this problem within minutes as an enterprise customer.

    Greetings,
     Sebastian

Categories