Hi

I'm very very new to Tableau and tasked with creating a Salesforce dashboard for my team. We are a consulting team and use SF to answer customer queries. For each sub-category we have a SLA (number of days in which the ticket must be resolved). I have managed to connect to the SF database and found the metrics I need, except for the SLA table as this is not part of SF, just something my team does. I have used an Excel spreadsheet to map the SLAs to each Sub-category and then created a relationship between the SF database and the Excel using Sub-Categories.

So far so good but here comes what I'm struggling with:

I need to create a sheet that shows our SLA adherence in % for each sub-cat but the "Age of case" field is a calculated field I have created the SF database data and "SLA in Days" is a field from the Excel file, so when I try to create a calculated field that shows me how many cases out of the total cases are SLA compliant I get an error message about sum(or count - i tried both) being aggregations that cannot be used with another aggregation.

Could you please help with any suggestions what to do?

Thanks,

Ana