Forum Discussion

msuser48's avatar
msuser48
Helper I
3 years ago
Solved

Show average values on a chart with fixed X axis

I have the following dataset: PersonId FirstLetterReceivedDate LetterReceivedDate LetterStopDate Letters Y/N 1 01-01-2015 01-01-2015 01-01-2018 1 Yes 1 ...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    msuser48 , You can create an new column like this and use

     

    Year Diff =
    var _diff = datediff( [FirstLetterReceivedDate],[LetterReceived],month)/12
    return
    Switch(True(),
    _diff <=1, " 0- 1",
    _diff <=2, " 1- 2",
    _diff <=3, " 3- 4",
    "GT 3"
    )

amitchandak's avatar
amitchandak
Super User
3 years ago

msuser48 , You can create an new column like this and use

 

Year Diff =
var _diff = datediff( [FirstLetterReceivedDate],[LetterReceived],month)/12
return
Switch(True(),
_diff <=1, " 0- 1",
_diff <=2, " 1- 2",
_diff <=3, " 3- 4",
"GT 3"
)