Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a project that I am working on that will show project status and sales stage information in a give time period. This information is coming from two seperate systems. I want to view the counts of the various statuses and stages over a given timeframe, usually over a year. The problem that I am have is when I select a sales stage I loose several months of project status data. Is there any way to maintain the project status data, even when selecting a sales stage causes some dates to be excluded?
Thanks!
You can do it using set analysis. Suppose you don't want any selection to effect the sum(Sales), you can write
sum({1} Sales)
Thus the sum(Sales) will be always constant irrespective of any selections made.
Richy,
Thank you for your suggestion. I would like to be able to select the date range initially and not have the project status or sales stage affect the selected date range. Any thoughts on that?
what is going to be the date range? Is it a dynamic value like last 12 days?
Or is it what you can select ?
i have three list boxes where a user can select a month, day and year.
One way you can achieve this is by creating a loosely coupled table which has data only needed for the graph you want to show.i.e. a table isolated from all other entities, which can be done from load script. This way the selection of the date range will affect only the chart, not any other product or whatever it is, and vice versa
Anyway, see what others are saying. Maybe somebody can help you out.