Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by FishTacos

  1. It doesn't seem to work. Keep getting formula errors. This is a good suggestion and I was hopeful. Below is what I was using: DENSE_RANK () OVER (PARTITION BY (SELECT cb_vr_results_SEX FROM view_cb_vr_results WHERE cb_vr_results_DISTANCE_SUBMITTED=[@DISTANCE_SUBMITTED]) ORDER BY (SELECT cb_vr_results_TIME FROM view_cb_vr_results WHERE cb_vr_results_DISTANCE_SUBMITTED=[@DISTANCE_SUBMITTED])) [@DISTANCE_SUBMITTED] is a param passed from Search. Am I missing something?
  2. Hello- I am trying to calculate 3 rank values for my data source. 1- overall rank, 2-gender rank, 3-age rank. I have a tabular report displaying each individuals record with a time for a run. Each person needs to have an overall rank, gender rank and age rank. I can accomplish this with a calculated field using RANK functions by each respective data field but my problem is that if you change search criteria it will change the rank. I want the ranks to remain constant regardless of the search filters...almost as if those rank values live on the database table. I have tried to move this from a datapage calculation field to a database trigger to insert the values on the database table but can't seem to get any logic how I want it in the trigger expression builder - is it even capable of doing this? Example of gender rank would be: DENSE_RANK () OVER (PARTITION BY [@field:cb_vr_results_SEX] ORDER BY [@field:cb_vr_results_TIME]). Assigns gender place by time ASC for each M and F. Any help or leads would be helpful. Thank you!
  3. Hello, I need to try and figure out how to calculate values from time/distance. Examples: 1. Calculate miles/hr based on 2 fields: time and distance. Ex- 1:00:00 (hour) and 20 Miles would be 20mph. 2. Calculate pace per mile based on 2 fields: time and distance. Ex- 1:00:00 (hour) and 10 Miles would be 6:00/Mile. Anyone have experience in doing this in Caspio or can offer any help? I haven't had any luck in making these calculations. Any help would be greatly appreciated. Thank you!
  • Create New...