Forum Discussion

IanCockcroft's avatar
IanCockcroft
Icon for Post Patron rankPost Patron
6 years ago
Solved

Indicate if record has not come through yet

Hi guys, I have a bit of a condundrum which I am struggling with. I have a SQL table that gets updated with various system status data. if a system runs and finishes with a success or failure, a re...
  • lbendlin's avatar
    6 years ago

    Use the date from your dates/calendar table as the basis of your visual, not the event date.  Then you can do calculated columns or measures as needed to compute the status for each dates[date], via crossfilter(,,none) if you can create inactive relationships or other table math if not.

     

    Here's an exampe of a calculated column in the dates table with relationship between the date fields.