-
How to show a specific date with an aggregate (max)
Hey guys, So I'm creating a card that looks at the sales of our employees each day and then lists the day with the max sales. Our Data is structured by transaction, so I had to create a Magic ETL to Group the sales by date and employee in order to find the max by day. The problem I'm having is when I try and display the…
-
How to find a max value from multiple aggregates
Hey guys, I'm looking at our collections information from the last two years to find our best collections month during that time frame for each of our locations. Before when I had to do this I just did it in ETL using a group by function, but this case is a little more complicated as I'm wanting a specific set of…
-
Drill Path Filter to show Specific Apt's without a Specific Procedure
Hey guys, I'm afraid that the answer to my question is that I need to do it in ETL, but I was hoping that it could be done via a beast mode instead. Basically I have a list of procedures done by our dentists that looks similar to below: Dentist | Procedure | Procedure Date| Appointment Number | Patient Dr B | D0330 |…
-
Drill Path Filter to show Specific Apt's without a Specific Procedure
Hey guys, I'm worried that the answer to my question is that it has to be done in ETL, but I'm hoping it can be done as a beast mode. So the data in question looks similar to what I have below: Doctor | Procedure | Date | Apt # | Patient Dr. B | D0330 | 4/1/22 | 80136 | I. M. Madeup Dr. B | D0126 | 4/1/22 | 80136 | I. M.…
-
Drill Path Filter to show Specific Apt's without a Specific Procedure
Hey guys, I'm afraid that the answer to my question is that I need to do it in ETL, but I was hoping that it could be done via a beast mode instead. Basically I have a list of procedures done by our dentists that looks similar to below: Dentist | Procedure | Procedure Date| Appointment Number | Patient Dr B | D0330 |…
-
Period Over Period Nested Bar
Hey guys, I'm trying to create a week over week bar graph that shows the next 7 day production vs the last 7 day production. That is the easy part, I'm also trying to group the bars by our different locations. Below is an image of what I have so far. Is there an easy way to split up those total production amounts into our…
-
Is there an easy way to calculate the days left in the month to insert in a Beast Mode equation?
I'm working on a Beast Mode where I have a given an amount of production that I want to divide by the remaining days of the month. The method I have below doesn't function the way I want it to. My code segment is below. Is there any easier way to go about doing this? Thanks in advance. (SUM(`Goal`) - SUM(`Production`)) /…
