Attempting to map a set of dates into a set of Days-from-Certain-Date to standardize chart data

  • 1
  • Question
  • Updated 1 year ago
  • In Progress
Hello All!

I have a bit of a tricky issue to tackle here. Right now I am using a line chart to show how many accounts have been assigned to a certain account manager in their first 90 days. The graph shows cumulative accounts with each line representing a manager. The issue with this current display is the various starting dates of the managers thus showing staggered lines. In order to clean up the graph and create a standard measure I would like to create a graph that shows Number of Accounts Assigned vs Days from Start Date. By taking the difference between the assignment date and their start date I would then have a standardized data set that can show managers progress neatly laid over each other. Please see my current chart for reference. 


I attempted to use an UI-Only formula field but only got 0's. Not sure exactly how or if I can utilize UI-fields to accomplish this, thus I am now appealing to the infinite wisdom of the skuid community. If anyone has an idea of how this may be accomplished please share! 

Thank you.
Photo of Michael Schniepp

Michael Schniepp

  • 1,808 Points 1k badge 2x thumb

Posted 1 year ago

  • 1
Photo of Skuidward Tentacles (Raymond)

Skuidward Tentacles (Raymond), Champion

  • 17,224 Points 10k badge 2x thumb
What about a salesforce formula field to calc the days from start date.
Photo of Michael Schniepp

Michael Schniepp

  • 1,808 Points 1k badge 2x thumb
we are currently at capacity with Opp fields unfortunately. Also I don't think I would be able to finagle getting a field just for this.
Photo of Peter Hale

Peter Hale, Employee

  • 330 Points 250 badge 2x thumb
You could use a formula field in Skuid to get the days from the start date.  The formula could look something like this:
ABS(NOW() - {{StartDate}})/(1000*24*60*60)
and then use this field in the x-axis potentially
Photo of Michael Schniepp

Michael Schniepp

  • 1,808 Points 1k badge 2x thumb
This was resolved when I used a standard model instead of aggregate model. Just FYI for all! (Taking the difference between dates)