hi,
I have "A " table where number of cases details saved with stages("accepted","not accepted","document_submited","completed") and dates store as created_at date , document_submitted_at date and completed_at).
Now I want to make report where single date filter and count of cases display as per loanschemes vs stages.
I have created dim date and relationship created between created_at ,Completed_at, Document_submitted_at but one reltion is active and another 2 relation ship is inactive so in visualisation count of cases is not displaying as per accepted and document submited or completed. Please give solution to this problem.
