Scaffolding missing dates
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Experts,
I have a list of error identified date for products. I am creating a bar chart maping Months in X axis and affected products in Y axis and also calculating avg line per year ( total products affected / available months for that year).
I am able to add dates from first date til last date but I dont want all date. I just need 1 date in the missing months. Just to display month in the graph with value 0 and use the count of month for Average calculation.
I want to replace null (Product column ) with 0 because I dont want to count those values.
Can someonehelp ?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You shared the workflow, but not the dataset. If you don't need all the days, try adding a month to the date rather the a day. You can use this formula to replace nulls with zeros: IF IsNull([FieldName]) THEN 0 ELSE [FieldName] ENDIF.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks
