Forum Discussion
Showing total in a table
Dear all, good morning.
I have the below table and would like to create a chart that would showcase the total of cargoes by day.
| Cargo ID | Entered Day | Released Date |
| A | 01/01/2021 | 03/01/2021 |
| B | 02/01/2021 | 04/01/2021 |
| C | 01/01/2021 | 02/01/2021 |
I managed to create it using the below with speedramps help
But now I need to have a table/matrix containing all cargo ID for the month, so if I click on a specific month it will show all cargoes for that month as a list / table.
Could anyone help me?
Hi again Pedro !
I have updated the example
There is a By Mate page and By Month page.
Click on day or month on the graph and all the valid cargo details will be displayed in the bottom visual.
This is done by adding the Valid Cargos field in the filter panel
See attached screen print
please click thumbs up and accept solution, thank you.
5 Replies
speedrampsSuper User
Hi again Pedro !
I have updated the example
There is a By Mate page and By Month page.
Click on day or month on the graph and all the valid cargo details will be displayed in the bottom visual.
This is done by adding the Valid Cargos field in the filter panel
See attached screen print
please click thumbs up and accept solution, thank you.
Incremental refresh to build data - snapshots
The man and the myth, thanks and solution accepted 🙂
- speedramps
Thak you Pedro. Well done !
- speedramps
As explained before, this measure will handle by day, month with a calendar
Valid cargos =var min_date = MIN ( 'Calendar'[Date] )Var max_date = MAX ( 'Calendar'[Date] )VAR validrows = FILTER ( Commodity_List , Commodity_List[Entered Day] <= max_date && Commodity_List[Released Date] >= min_date )RETURNCOUNTROWS ( validrows )But how can I see which cargoes are being considered for each date? I would like to click on the chart and show me on a table what are the ones considered (like cargo A,B for day2)