I'm not sure which kind of view you expect for "bar graph" but here is what I can propose.
This shows week ago and (today + delta from week ago)
Create calculated fied of
if [Date]=today() or [Date]=today()-7 then [Date] end
[Date header] in the filter shelf and filter out "Null"
Put [Date header] in the column with MDY format
Put sum(view) in column shelf.
Put sum(view) on secondary axis as gantt chart and synchronize.
Put sum(view) in mark of second axis and change to table calculations as below.
Put Table calculation sum(view) in color and size and "edit in shelf"
then put "-" on top of formula.
Adjust label alignment.
Change Color setting
Bar_compare_1week_ago_9.0.twbx 18.2 KB
Which value are you trying to keep?
Table calculations require all the data in the view. Since there is no example dataset, let me propose a solution based on assumptions.
The trick is in table calculation filters. Table calculation filters apply after table calculations are calculated and hide marks. So applying this filter won't change the value you calculated but it will let you hide the bars that you don't want to see.
If you want to only keep the seventh bar you can write a calculated field like INDEX()=7 then use it as a filter and just keep rows that returns True. You will see that your LOOKUP function still returns the same value but marks are not displayed.
first of all, thank you for your answer
second of all, what I need, referring to the workbook you've posted (thank you for that as well), is just the green bars in the sheet. Meaning, I want to compare only the Delta between the sites.
My view needs to show ONLY three bars, where AAAAA = 66, BBBB = 7, CCC = 54.
Is there a way to show those three bars without showing the data for last week?
What I need to keep is the Delta - lets say something like this:
- 2016-02-22 has 5,000 views for site A, 3,000 views for site B
- 2016-02-29 has 7,000 views for site A, 7,000 views for site B
I want to see 2 bars:
- Site A: 2,000
- Site B: 4,000