-
If date falls within the current month
I am trying to calculate the # of visits (that a therapist does) per working day against a goal of how many visits per day we budgeted them to do in a month. I am running into an issue with the calculation for the current month. For example, the goal for June was 22 visits a day and we had 733 visits in the month of June…
-
Count items within a cell
Looking for a formula that can count the number of items in a cell, that are separated by commas and I am stumped. So in the example below, row 2 has 3 items, row 5 has 0, the other rows have XX items. Any suggestions?
-
Filter on Total Column?
Can you filter on a total column? We are using a pivot table to calculate our selling capacity per areas, per therapist discipline but hoping to remove any that have a TOTAL less than 5 for all of the disciplines in an area combined. Wondering if I am missing a simple filter options vs adding a few more beast mode…
-
Beast Mode - Color Coding
I am trying to do a beast mode with HTML code for if the Variance > Schedule, then make it red. The hiccup I am running into is that Variance and Scheduled are both already beast mode calculations, not natively in the ETL. So how can I do the HTML coloring beast mode case when statement when both items are beast mode…
-
If date falls within the current month
I am trying to calculate the # of visits (that a therapist does) per working day against a goal of how many visits per day we budgeted them to do in a month. I am running into an issue with the calculation for the current month. For example, the goal for June was 22 visits a day and we had 733 visits in the month of June…
-
Single Value Card - Value is 0
I am calculating the NPS score of a survey dataset. Today, the NPS Score is 0. When doing a table, it will show 0.0 but when I switch it to a Single Value Card, it is just blank and does not display 0. I cant find a property to help with allowing 0s. Any ideas?
