Hi Team,
I have a table ‘ Multiple fields in one date range’. , it has 3 columns ‘Date’, ‘on hold’ and ‘Released’. I have attached the data source and the workbook.
In the tableau workbook, I have created two simple calculations in sheet 1. ‘Count of on hold’ and ‘count of Released’ .
My question -
In the same view , I would like to use the date range slider filter to select and display- ‘count of Released’ values when date range is from 12/26/2023 to 12/30/2023
And I would like the date range slider filter to select and display- ‘Count on hold’ values when date range is from 12/31/2023 to 01/10/2024 is selected.
If a date range is selected overlapping the date ranges , for example if slider selects date range from 12/29/2023 to 01/02/2024 then the date range 12/29/2023 to 12/30/2023 should show values for ‘count of Released’ and date range 12/31/2023 to 01/02/2024 should display ‘Count on hold’ .
Wanted to know if this is possible and if I should approach with creating a Parameter or a set.
Thank you!
Regards,
Rishi Saka
Hi,
I understand that one way to do it would be to create a new column with the criteria. for example
COUNT(IF str([Date]) < '2023-12-31' THEN (if [On Hold] = 'DM' THEN ([Released]) END)
ELSEIF str([Date]) >= '2023-12-31' THEN (if [On Hold] = 'HZ' THEN ([On Hold]) END)
end)
is there another method that is more efficient.
Thank you!
Regards,
Rishi
