-
Sort by Top 20
Hi, I am currently looking at a healthcare practice's insurance list, which is hundreds long. I would like to create a chart with only the top 20 most commonly used insurances. Is there a way to do so in beastmode? I've tried chart properties → general → maximum rows (20) but it didn't work. Thanks!
-
Heat Map Hours Off
Hi, I am trying to make a heatmap. I created a beastmode to help organize the hours to go in chronological order (attached screenshot). However, this doesn't seem to be working (attached screenshot). I am not organizing the times by count in the filters. Could anyone help me figure out what I'm doing wrong? Thanks!
-
Percentage Calculation
Hi - I am trying to find the % of one column of items compared to another. Specifically, the percentage of "online appointments" (a filtered option of "all appointments") compared to "all orders submitted". I cannot figure out the formula. Previously, when figuring out the % of online scheduled appointments compared to all…
-
Google Analytics - Referrals
Hello, I am trying to create a graph using Google Analytics, specifically on referrals (Acquisition -> All Traffic -> Referrals). However, when I connect and select which data to include, I am not pulling the right numbers. Does anyone have advice on which metrics to pull in? Thanks!
-
Count Distinct Variance
Hello, I am currently creating a bar chart where I use a count distinct formula for unique client IDs as the y-axis, and the series is location. I've noticed that when i add or remove the series from the bar chart, the y-axis's values change. I'm not sure what is going on, any advice would be helpful. Thanks!
-
Heatmap - No data
I have created a heatmap for online activity, though some spaces are showing up as "no data" and greyed out. Is it possible to assign a value of "1" to where there is no data, so the heatmap would be more visually pleasing or something similar so there is no grey section? thanks!
-
Timezones
Is there a way to convert timezones for certain graphs within beast modes? I am looking at online activity for different clients within different timezones ( the metric is 'appt_created_time_utc') and cannot figure out how to adjust each graph to reflect their specific timezones.
-
Division Question
Hello, I am trying to find a formula to see the total utilization for online scheduling vs offline scheduling for certain exam types. Online vs. Offline exams are within the same SQL column ('appt_source' will either = 'OFFLINE' or 'ONLINE') whereas exam types are within a separate column ('Modalities'). Any suggestions on…
