Hi,
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…
SWITCH(MONTH([Date]),
1,“January”,
2,“February”,
…
11,“November”,
“December”)
If you now add both views to your interactive Dashboar view, it should work.
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |