Sorry. Typo on my end. Case when sum(Case when `Completion` is not null then 1 end) =0 then '0' when sum(Case when `Completion` is not null then 1 end) ❤️ then '1-3' when sum(Case when `Completion` is not null then 1 end) >=3 then '3+' END

Hey there, Sounds like you need a count of completed courses and then categorization for the "How many courses have been completed." Maybe something like this will help: Case when sum(Case when `Completion` is not null then 1 end) =0 then '0' when sum(Case when `Completion` is not null then 1 end) ❤️ then '1-3' when…

This was an amazing find. I had duplicate data appended. I was going to blow away the entire dataset and spend days doing another incremental upload. This was such a gift.

Thanks, Valiant Spur. This helped me out in a major way.

That is an elegant solution. The best option would be for an email to be sent to the user to prompt them to check it out. Any ideas on that?

Try hitting the "Edit Table" pencil icon on the right hand of the Drill Down Detail. It'll slide out the columns on the table. I've found that my beastmode calcs are there and are not selected. Clicking on them will add them back to the table. My problem is that I don't seem to be able to filter on them. That means that if…

* Is your Sharepoint Connector pointing at the right page? * The connector doesn't include any subpages, so you might need to add another one targeting that specific url (i.e. acme.sharepoint.com/coyoteorders) * Run the "Lists" report and look under the Title column to see how the connector is reading your list name.* Copy…

Thank you so much. I hereby present you with the Transparency Award!

Beautiful n8isjack. This adds the pizzaz we wanted. Consider yourself much loved by our team. PS. And select "no aggregation" under the Series tag.

Regret that this is not a viable solution because: * This chart type set the first series as the line and subsequent series as bars. * I want the first datapoint to be displayed as a line, the others as bars. * Therefore, switching the series positions would negate the value of the chart. I need a way to set the goal on a…