There are a couple of things that you need to do.
1. Set up a relative date filter to selection only the last 7 days.
Help reference: Filter Dates
2. Filter to select only the rows with CPU % > 95%
3. Create a count of the rows rather than a sum of the measure.
An example workbook is attached. For the date filter, I anchored the date to 2016-01-05. You would not have an anchor date selected if you want it to flex based on the current date.
discussion 212143.twbx 5.1 KB
Thank you! I also want to filter out the top 2 computer it's not showing computer 1 and 3 which are top 2. Tableau only shows computer 2 and 3 for some reasons.
Any help would be appriciated
How are you defining the top 2 computers? If it is by total count after all of the filters have been applied, I would do it with a Table Calculation like this:
rank(COUNT([CPU usage (%)]))<=2
That results in a T|F value. You then add it to the filter shelf and select true only. As always with Table Calculations, you'll need to watch the context and direction when working with more complex visualizations.
Updated example attached.
discussion 212143.twbx 5.2 KB
Thank you a lot Jeff
It worked beautifully
Excellent. I'm glad that I could help.
Good luck with Tableau. I hope it continues to be a good experience as it has been for me.