Currently I am working on a Sheet that contains some kpi's that illustrate amount of products we have sold with a date picker object to allow the user to select a date range that needs focus. In the auto generated section of the data load editor I set the field 'Receive_Date' which is under the format of MM/DD/YYYY Hh:mm:ss to be loaded with this format:
DATE([RECEIVED_DATE],'MM/DD/YYYY') as [RECEIVED_DATE].
and then at the bottom used 'tag field [RECEIVED_DATE] with $date;' so that the data picker can distinguish 'Received_Date' as a eligible field.
How ever I am noticing a few issues.
Firstly, when I select 'yesterday' or 'today' which are the predefined fields I can successful create a sheet wise condition for those specific received dates how ever kpi is showing zero which is completely false. I did a check on this by setting the kpi data function to show that specific date without the use of data picker and got a count > 0.
Secondly, whenever I set it to 'last 7 days' or 'last month' the date picker doesn't work, i will click on these functions and the sheet with refresh and the date picker will only show something like the last 3 days
I.E. Ill select last 7 days and the sheet condition will show 8/20/2021 -8/23/2021.