Forum Discussion
Slicer / Button Assistance
I am trying to reduce the number of liceses we use at work. Therefore, am looking for a quick easy way to display the total number of "Active_Status" with a "Last_Logon_Date greater than >9, >6, >3 months. Ideally, I would be able to click a slicer to see the number display in a card.
Further, I would like to see the data displayed in the table, example would be users not logged in in >9, >6, >3 months and display a number below.
Here's an example of the data
Community ChampionA couple of things...
1) can you please include the user id in the sample data? At the moment you can only calculate Account_status and/or Identity_status, but there is no way of knowing how many users the sample data refers to.
2) do you want the period to be static (>3, >6 or > 9) or variable (select any time frame)?
3) you mention Active_status. Is that a different column not included in the sample data or which column does it refer to?