0

I am working on data viz on Tableau desktop

I have a dataset, with a column for dates, in this column , there are different dates, and null cells.

I need to use the dates in this column as filter, better still , page filters, however, I need to achieve the following goal.

whatever date choose for the filter( or the automatic run page filter) from this column, I need that all the null cells in the same column to be replaced by the choose dates for the filters , else I will lost the data associated with the null cell in the viz.

I have tried to use parameters, in that way, I have to chose filter value first, then change the parameter value to align with the filter value ,manually, which is not ideal, also lack of automation and kinda of repeated clicks.

I hope you can help me with this particular problem with some magic trick, or simple a wise function will do

Pepin Peng
  • 457
  • 1
  • 8
  • 21
  • I'm not sure that including ALL the null values when you pick a *single* date is likely to give good or meaningful results. Is there something about the structure of the data you are not telling us? – matt_black Mar 07 '23 at 13:45

0 Answers0