Last 7 days data calculation in Tableau

tableau-api calculated-field
Yousuf Sultan picture Yousuf Sultan · Apr 27, 2017 · Viewed 19.3k times · Source

I am having an issue in calculating last week data in Tableau. Below is my scenario:

In my dashboard, I have a slider which selects the date. In my table, I have a list of users where I will be showing each of them's call records. One column will have last week records and one will have total records.

For Total records, there is not an issue. But for finding last week's count, I need to have a calculated field, that needs to subtract 7 days from the date selected and then give out the number of records for each user.

Say I have selected date as 25-04-2017, then my table should show all the records until 25-04-2017 in one column and other should show data from 18-04-2017 till 25-04-2017.

Answer

Ric_R picture Ric_R · Apr 27, 2017

You can filter it with Relative days. When adding your dimension (date type) to the Filters list the picture below will appear.

enter image description here

Now you can click on the relative date and to choose the best option for you. You can see it in the picture below.

enter image description here

Related questions

Tableau count number of times same value appears in column

I have a field such that Color Pink Blue Pink Blue Pink Pink Pink Pink Pink Blue Blue Pink Pink Pink Blue Pink Blue Pink Blue How to create calculated field to count number of times Pink appears? Total numbers …

Read More
Counting distinct number of records based on a condition in tableau

Item Location Empty A X No B X No C X No The above table is generated by query select it.item,lt.location,lt.isempty from locTable lt join itemTable it on lt.location = it.location Item table has "…

Read More
Tableau Format Percentage Pie Chart

I created pie chart in tableau, i.e When I try to format number into percentage, I get this How would I even create a calculated value. Data is in the form TYPE Email Removable Media HTTP CD/DVD For …

Read More