Jump to content
  • 0

Need Week Start (or End) Date on Chart instead of Week Number rollup



I have a Chart (below). Although the user can enter their weight on a daily basis, for this chart I roll it up by week to display. The problem is, that the rollup only gives me a week number option for week. it provides :


I'd like to know what idiot decided that week number was a user friendly roll-up. That was just lazy programming.

That aside, Does anyone know how to get/translate, use another calender option that would provide a rollup by week start (or end)? I can't present the following to my customer base.

Thank you in advance!



Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

I solved this.

I ended up having to do this the hard way by adding a field to the table called WeekEnd

Next I created 2 Items.

Trigger 1: Insert/Update: In a Trigger, whenever a record is inserted/updated, I calculate the end of the week based on the user-entered date. This is the date I use in my Charts.

Task 1: The same logic used in the trigger, but modified to work (For Each Record, Do...) against whole table. This updated table to bring it into sync.

It's a round about way of getting there, and it's not perfect (who want's to see their MAX weight for the week, when what you really want to see your LAST weight for the week), but you work with what you have. I remind myself constantly... There are no free rides.

Thanks to everyone who contributed.


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...