1 Reply Latest reply on Jan 28, 2019 3:04 AM by Mark Fraser

    Dynamic Field name based on Date Value Selected in Date Filter

    sharan kv

      Hi Geeks,

       

      I have a table with the one calculated dimension, which should be termed as a combination of the string("Status as of") and with the date value selected in the filter(MM-DD format). Can you please help me how can this be achieved?

       

      For ex:

       

      1) If the date selected in the filter is from 01/01/2019(DD/MM/YYYY) to 07/01/2019(DD/MM/YYYY) then the column should be labelled as "Status as of 01-01"

      2) If the date selected in the filter is from 08/01/2019(DD/MM/YYYY) to 14/01/2019(DD/MM/YYYY) then the column should be labelled as "Status as of 01-08"

       

       

      Thanks in advance for the help and time

       

       

      Regards

      Sharan