Good morning,
we created a Story "Distribution Report" with two Datasources:
- "MDF Scale" contains the data inside a MDF called "cust_rating_scale" which has a scale of 5 assessment
1. Does Not Meet
2. Partially Meets
3. Fully Meets
4. Exceeds
5. Far Exceeds
- "Job Information + MCA Total" contains the Job Information of employees and their evalutaion on Performance Forms. These evaluation are the same of MDF "cust_rating_scale".
We want to create a table that has all the counts of each evaluation and the totals. I send you two screenshots:
- the expected table output (table_expected.PNG)
- the table with now inside the Story on which we can't make totals and we missed one assessment (Valutazione_no_show_total.PNG)
Any advice on how to do it?
Thanks
Tommaso