Hello, I am trying to create a Card that will help with the forecasting. We receive cases (CasesID) by Regions all year, I need to create a Card that will show all the regions and then the month as columns, the values will be all the cases submitted in that month / the total cases submitted from that region.
Where I am struggling is the date that I am not sure how to count all the cases from that month and then divide it by all the cases.
I am using a pivot on Domo to recreate this, if there is a better option please lmk maybe a heatmap?
This is my progress so far