I had a question involving pie charts. Im attempting to create a pie chart that uses the latest date entry from a table. Since there are many different entries within the table, i do not know how to direct the pie chart only to select the most recent date entries.
an example chart
Entry Date Reports in Progress Reports Completed
5/9/2011 5 6
5/16/2011 4 7
5/23/2011 7 5
5/30/2011 9 3
*6/6/2011 *5 *8
*information i need the chart from
My goal is a pie chart that, for this week, would display the reports in progress (5) compared to the reports completed (8), yet only using the data entries for 6/6/2011
i tried playing around with min/max aggregations within dimensions and expressions, and im stumped. Am i missing anything?
any idea how to change the '06/06/2011' part to always take the most recent date? I would be adding data to the table as the year progresses, and i would like the chart to always refresh to the most current week