Long post as i think a little background will help understand the issue i am facing
i have a table for loans which has the following fields
1. App id
2. Created date
3. Funded date
4. Funder name
the below case 1 and 2 are already done , writing this here as thats the disired solution for the bar chart visual
Case 1: i want to count total application regardless if it was funded or not.
I am using count of app id for this. This is displayed in a card.
Case 2: i want the total funded count.
I am using count of funded date. This is displayed in a card
The logic required is that I need to see the counts based to created date and funded date.
Example
I have two slicers on my page
- Created date
- Funded date
The total count should not be affected by the funded date slicer( I edited the interaction in the total count card) SOLVED
The funded count should not be affected by the created date slicer( I edited the interaction in the funded count card) SOLVED
Now i want a visual stacked chart by funder name
I want the total counts of each funder and funded counts of each funder and then also get the % funded
The logic for this I want to count funded applications by funded date regardless of their created date
And created date is counted regardless if it was funded
I was able to do this on a card as it only contains one value and i was able to edit interactions but I am unable to figure this out for a visual with multiple fields.
Is there a way to edit interactions of one field in a visual. Or is their any other solution
Thanks
