Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to make a graph to count the number of distinct changelogs + detailID occurring in the last week.
I have these two formula's in various other parts of the app and thought I could combine the count distinct with the look for the last week, but am not having any luck.
=count(distinct ChangeLog&'-'&DetailID)
=Count({<InputType = {'Error'}, Date = {">=$(=Date(Today()-7, 'YYYY-MM-DD'))"}>} InputType)
Date | Version | Site | ChangeLog | DetailID |
2017-12-09 | 2.5 | AAA | abcd | 1 |
2017-12-09 | 2.3 | SSS | abcd | 2 |
2017-12-07 | 2.3 | BBB | abcd | 1 |
2017-11-31 | 2.1 | AAA | efghi | 3 |
Any help would be much appreciated.
Thanks
This doesn't work?
=Count({<InputType = {'Error'}, Date = {">=$(=Date(Today()-7, 'YYYY-MM-DD'))"}>} DISTINCT ChangeLog&'-'&DetailID)
This doesn't work?
=Count({<InputType = {'Error'}, Date = {">=$(=Date(Today()-7, 'YYYY-MM-DD'))"}>} DISTINCT ChangeLog&'-'&DetailID)
That does seem to work, I was just having issues where to put the distinct (I was trying to put it up near the count).
Thanks for the help