Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hello I am trying to create a line graph visual that includes a projection of program enrollment over time (enrollment numbers on y axis, time on x axis). The project has 10 different sites enrolling patients to participate. The maximum number of individuals that can be enrolled by site is 130. I have the graph and I have the projection but I want to add a new measure that will cap each site at 130 so I can get an accurate estimate on timeline to study completion (enrollment= 1300). The dataset I'm using was designed for another purpose so it is in a less than ideal format but I think it can accomplish what I need. Below is a sample of the data table
Table Name: Test Tab
Site Name | Timepoint | Patient Enrolled (Cumulative) |
Site 1 | January 2022 | 5 |
Site 2 | January 2022 | 9 |
Site 3 | January 2022 | 3 |
Site 1 | February 2022 | 13 |
Site 2 | February 2022 | 22 |
Site 3 | February 2022 | 7 |
Solved! Go to Solution.
@Cfrance28 , Based on what I got,
You can have a measure
max enrollment= 130
Use that as line in visual or as constant line using analytics pane -> constant line -> fx
@Cfrance28 , Based on what I got,
You can have a measure
max enrollment= 130
Use that as line in visual or as constant line using analytics pane -> constant line -> fx
User | Count |
---|---|
12 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
13 | |
11 | |
7 |