Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So I have a list of last logon times for my users.
I have certain buckets I need to put them in based on their last logon time in the pie chart.
If their last logon time is <= today() - 120, they need to be in the 'Deletion bucket'
If their last logon time is <= today() -90, they need to be in the 'On Watch' bucket
If their last logon time is anything else, they need to be in the 'Valid' bucket.
I can't seem to think about how to set up the buckets for this in the pie chart
Any ideas?
Could maybe do something like this sample.
Hi,
ValueList('Deletion', 'On Watch', 'Valid') as Dimension
If(ValueList('Deletion', 'On Watch', 'Valid') = 'Deletion',
Count({<LastLogonTime={"<=$(=today() - 120)"}>} Users),
If(ValueList('Deletion', 'On Watch', 'Valid') = 'On Watch',
Count({<LastLogonTime={"<=$(=today() - 90)"}>} Users),
Count({<LastLogonTime={">$(=today() - 90)"}>} Users)) as Expressions
The chart says theres no data to display.
If(ValueList('Deletion', 'On Watch', 'Valid') = 'Deletion',
Count({<LastLogonTime={"<=$(=today() - 120)"}>} Users),
If(ValueList('Deletion', 'On Watch', 'Valid') = 'On Watch',
Count({<LastLogonTime={"<=$(=today() - 90)"}>} Users),
Count({<LastLogonTime={">$(=today() - 90)"}>} Users)))
missed one closed bracket
Could maybe do something like this sample.
It still gives the same error
Can u upload sample file
If possible upload the file currently ur working
This gives me the error 'all values below limit' in the pie chart.
And I'm sorry but I cant upload a file.
It was because I had a different equation in there. Thank you!