I have a question for the below calculation the values are repeating multiple times and details shared below step by step.
Above calculation is working fine when the cutoff days is 0.
Sample 1 when the cutoff day is zero.
when i change cut off days into 10
sample 2 below the values are repeating multiple times.
The calculation are working fine but not sure why in the report for each run date values are repeating.
I need to get result when i select rundate parameter 02/11 and cutoff days 10 it should display the data withing range between dates 02/02 to 02/11 (10days day).
please help us to resolve sample attached workbook.
@James Emery @Jim Dehner
Thats the requirement from biz users Menu Title should have Text and Distinct count Numbers for Menu Title.
To get both i combined as union in Custom SQL below query
Union
1st table contains Text
2nd table contains distinct count of Text
Example below
Is there any workaround to resolve this issue am using UNION i have attached query in spreadsheet. as you said tableau Calculate those Total and Grand Total but the Total count of title will be a separate column and i have to get below. as per the requirement order of the column remain same also shared the spreadsheet. this will not allow Total and Grand Total to show for the below mockup attached spreadsheet.
Attached Mockup
