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 |
---|---|
43 | |
29 | |
22 | |
20 | |
15 |