3 Replies Latest reply on Oct 17, 2018 7:01 PM by Deepak Rai

    Show latest 2 weeks data and labelled empty cells as NoData

    Adam Anie

      Hi All,

       

      As attached in the workbook, it's just a sample data. In actual scenario, I will pull database from SQL server and it is a huge database. Usually I will create a simple dashboard. However due to additional requirement, I need to come out with a workbook/dashboard that will show the latest 2 weeks data and empty cell need to be labelled as 'NoData'.

       

      Can I know in this case how shall I do it. I knew that I can do filtering for 2 weeks data in workbook but for huge database, I think it is better to do it via custom sql query. And for 'NoData' perhaps can do it using calculated field.

       

      Please advise. Appreciate that.

       

      Thank you.