Jump to content

FishTacos

Members
  • Posts

    3
  • Joined

  • Last visited

Posts posted by FishTacos

  1. 2 hours ago, TellMeWhy said:

    Instead of using {@field:field] have you tried the manual SELECT Statement?

    I believe if you used field parameters, it will abide by the rules of the DataPage, so, if it's filtered, it will only check the filtered. If you use SELECT Statement, it will take from the Table itself regardless of the filtered set in the DataPage

    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...