Hi N h,
What is calculation that is being used from absence?
Would it be possible to post the packaged workbook (twbx file) or a sample workbook?
Sorry I can't post workbook.
But there is absence function for another case = DATEDIFF('month',[purchasetime],NOW() ). Here I divide users into two groups: those who made a purchase in this month and those who have not made.
After that I use function
active_inactive = IIF ([absence] =0, 'Active', 'Inactive').
Next I tried to do something like this:
active = IF ([active_inactive])="Active" THEN COUNTD([user_uid]) END.
It gives me NULL value, but when I output user_uid and active_inactive in text table some people have label active and some - inactive.
I think that my last function is wrong but I don't know how to fix it.
I have reattached a sample workbook using Superstore. The third calculation needs to be a count distinct of the Active or Inactive calculation. Then, place your user_id on the level of detail shelf (in this case State) and Active or Inactive on the color shelf.
Hope this helps!
active or inactive pie.twbx.zip 341.1 KB
Thank you very much!
My mistake was that I took a minimum of absence, so active_inactive was in measures and not in dimensions so i couldn't use it in pie chart.