If we want to show the Count of Order ID for 1 any Specific Date, we can use the Calculated Field like below,
count( if [Date] = [Date_Parameter] then [Order_ID]) end )
"=" operator used to filter & show 1 Value only. And there is no "IN" operator in Tableau, alternative is "OR" Operator.
For more Details click on Alternative for "IN"
Some times Customer may want to select Multiple Dates, in that situation we have to use "Quick Filters".
Note: We can pass Max 1 Value at a time from Parameter. Look @ Tableau Viz: Parameters - Tableau
if you want to select multiple Dates then go for "Quick Filter"
1) Drag the Order Date field onto work Area, then convert onto Full Date.
2) Right click on Date on the Rows/ Columns shelf then click on "Show Quick Filter".
3) then crate calculated field like below
count([Order_ID])
4) Now we can use the above calculated field to get the desired Result.
5) If you don't want to show Dates on the Report, Drag out the Order Date from Rows Shelf.
6) Now it will show the count of Order ID's for Selected Dates (Will not Date wise, since we removed Date in the above step).
No comments :
Post a Comment