I have a table with Locations( varchar)/Activitydate(Date)/Qty(Float).
I want to create a view for dashboard for Sum of Today’s Qty with Location. What criteria do I put in the builder , what is the syntax for creating where clause in such case ?
Also How do I create a table with single row single column with the current date which gets updated when it changes without editing the data table or just by refreshing the page. In that case I may use this table to join with above table to create the view.
Thanks for support.