Creating a dashboard with filtering condition


I have a list of buyer purchasing data which consist of total quantity of the product and due date to ship the product.

I want to create a dashboard which can show the total quantity of product that will be shipped by month (e.g. January, February …December).

E.g. On the dashboard, when i click January, it will show me the total quantity of product that is due on January.

You would need to do two things… create a simple table with month names (only one column is needed). I assume that you have a date field in your table. Create a virtual column (Ref type) with an app formula into your purchasing data table…

If you now add both views to your interactive Dashboar view, it should work.

1 Like