Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to build the flowing graph:
The filed i have also includes other dates that i wont be using (like 10/1/2016 and so on), I only need to count late 30, late 60 and late 90.
What is the best way to create a new field using only "late" dates?
Please advise.
Using if statement, may be along these lines:
If(Date - Today() > 90, '90 Days Late',
If(Date - Today() > 60, '60 Days Late',
If(Date - Today() - 30, '30 Days Late'))) as Late_Flag
Maybe there is no need to create a new field. Use set analysis to restrict dimension values to three specific values only, like in:
=count({<[Expected Remediation Date] *= {'30 Days LATE', '60 Days LATE', '90 Days LATE'}>} WhateverYouLikeToCount)
Note: in set analysis, *= is the combined intersection assignment operator.
Peter
30 60 and 90 is already in the table, i do not need to define from today. how would i write without it?
Nevermind the warnings from the syntax checker. The syntax checker is broken; it doesn't understand compound operators like *= but they do work!
Good luck,
Peter
Hi Peter,
would set analysis work if I add another conditions?
=count({<[Expected Remedition Date]*= {'30 Days LATE','60 Days LATE', '90 Days LATE'}>}{<[Plan_2016]*= {1}>}{<[Vendor Type]*= {'Quality Systems}>}[Expected Remedition Date])
my first bracket is highlighted red
Try this:
=Count({<[Expected Remedition Date] *= {'30 Days LATE', '60 Days LATE', '90 Days LATE'}, [Plan_2016] *= {1}, [Vendor Type] *= {'Quality Systems}>}[Expected Remedition Date])
first bracket still red
Which bracket are you talking about? Can you highlight it with Red in your next response?