MikeG
Cloud Apps
Joined 2 years ago
User Profile
User Widgets
Contributions
- 2.3KViews1like0Comments
Re: Running Rate
so it didnt work. here is what it looks like when I do this in Looker. Notice the total placements is static, and only changes when I apply a filter on a date range. DE_LENGTH Running Cures Total Placements Running Cure Rate 0 10 10000 0.10% 1 25 10000 0.25% 2 45 10000 0.45% 3 100 10000 1.00% 4 300 10000 3.00% 5 450 10000 4.50% 6 556 10000 5.56% 7 685 10000 6.85% 8 978 10000 9.78% 9 1056 10000 10.56% 10 2500 10000 25.00% when I try to replicate, Total Placements, is being influenced by DE_Length and it looks like this Need to figure out how to get the Total Placements to be the actual Total of the date range Im looking at and not be based on the DE_Length, Hope this makes sense2.3KViews0likes0CommentsRunning Rate
Hi folks, hoping someone can help me with a Running Rate. I have pasted an example of how I have accomplished this in Looker, but I cant seem to figure it out in Sisense. To Level set, in my Dashboard I have a Date Filter called Placement Dates. I then want to calculate the Running Cure Rate by DE Length to calculate the running cure, in Looker I would do a running sum of accounts that have cured/total placements(for the time period selected in the filters) this is what it looks like. DE_Length Champion Running Cure Percentage Challenger Running Cure Percentage 0 0.12% 0.12% 1 17.97% 17.58% 2 23.96% 24.80% 3 30.42% 30.85% 4 36.05% 36.47% 5 41.33% 40.71% 6 44.51% 43.84% 7 49.15% 47.80% I cant seem to do the same in Sisense.Solved2.5KViews0likes6Comments