I have a datasource with 50 time duration fields that I need to convert to hh:mm:ss format,
so I wrote separate calculated fields for each of the 50 fields, in one of the business dashboards with tabular display I have shown the 50 calculated fields with the corresponding date time, The customer requested that we include the measure names as filters in this visual, so I did, but in the filter dropdown, I can see 100 fields that include both the calculated fields and the original fields; the customer wants the report to be more dynamic and configurable; how can I hide the original fields and display only the calculated fields in the filter dropdown?
Hi Manoj,
Check this link:
https://kb.tableau.com/articles/howto/hiding-measures-from-measure-names-quick-filter
where you can create separate datasource and blend the data accordingly.
My Suggestion would be better create Pivot and use the Pivot names as filter with that you don't need to write the 50 Calculations you need to write just Calculation .
BR,
NB
