Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys,
I have a line graph that I am trying to show items produced per month. Currently it only shows Jan through September because we haven't collected any data for the rest of the year (Oct, Nov, Dec). I was curious to see how I can get those months to show up anyways with no data collected so far. Here is the current formula I am using to show the total per month.
Sum({$<Program_Dash={'Mechanical Inspection'}, Status_Dash={'Completed'}, Year = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays))))"}>} Processed_Dash)
Can you share the excel file ?
There is no data passed today in the log.
I tried this as well, didn't work.
=Sum(If(ISNULL(Processed_Dash),0,Processed_Dash))