Pie Chart Help

[#1]

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?

[CELAMBARASAN]

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

[#3]

The chart says theres no data to display.

[CELAMBARASAN]

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

[#5 · Accepted solution]

Could maybe do something like this sample.

[#6]

It still gives the same error

[CELAMBARASAN]

Can u upload sample file

[CELAMBARASAN]

If possible upload the file currently ur working

[#9]

This gives me the error 'all values below limit' in the pie chart.

And I'm sorry but I cant upload a file.

[#10]

It was because I had a different equation in there. Thank you!