Hello,
I have 3 quick filters i.e. Transportation, City & Name.
I would like to display the 2 calc fields wrt to month without creating any parameters in place of quick filters because relevant values will not working as expected.
Need to pass all the below filters and match the results.
Avg= countd(TRXID)/Countd(date)
LSA & LS are pre calculated fields
Ex:
By Default
When Transportation="All", City="All' and Name="All'
Display same value in both calc fields for change in Transportation
When Transportation="Air", City="All' and Name="All' When Transportation="Ground", City="All' and Name="All'
When Transportation="All", City="Oklahoma City' and Name="All'
When Transportation="Air", City="Oklahoma City' and Name="All' When Transportation="Ground", City="Oklahoma City' and Name="All'
When Transportation="All", City="All' and Name="Justin Ritter'
When Transportation="Ground", City="All' and Name="Justin Ritter'
When Transportation="Ground", City="Oklahoma City' and Name="All'
When Transportation="Ground", City="Oklahoma City' and Name="Craig Reiter'
I hope it is clear. Please let me know for any clarifications.
Thanks!
Hello Ashok,
I'm not sure from this what the desired output and values are and where you are stuck. It would appear that you have started the work for this but it isn't clear where assistance is needed?
Patrick
Become a Viz Whiz on the Forums! Support the Community and master Tableau.