Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've been searching for an answer for this but I'm coming up blank, it doesn't seem too complex so I'm not sure what I'm missing.
attached is a file with a chart, in the chart are 2 dates, each has information. I have one date selected, with one piece of information, which totals 5 IDs for that thing. There are a total of 7 IDs for that date, and that's what I want.
I have 2 text boxes where I've been trying TOTAL, ALL, {1} but it still just reads 5 instead of 7.
Please help.
NOTE: one box should read 5 (number of items selected for that date) and the other should read 7 (total number of items for that date).
May be this
=Count({<thisDate>}distinct ID)
Hi Sunny,
Ultimately that counts all IDs over both dates. Clear everything and see the 7-17 date, which has 4 records total.
If you select 'that' as one of the items, one number changes to 2 (number of items selected) and the other remains 7 because that's how many "that"s there are throughout both dates.
In that instance it should be 2 for the selected, and 4 for how many are total of that date.
Try this
=Count({<thing>}distinct ID)
Try this
=count({< [thisDate] = {"$(=Date(Max([thisDate]), 'YYYY-MM-DD'))"},thing>}distinct ID)
Ok that's starting to make sense to me, but how about if I try to get a percentage of the total by dividing the count by the =count({<thing>}distinct ID) in the chart? I just get 100% even when the boxes have clearly different numbers
edit: initially posted wrong qvw, updated to "datetrial2"
Ok that's starting to make sense to me, but how about if I try to get a percentage of the total by dividing the count by the =count({<thing>}distinct ID) in the chart? I just get 100% even when the boxes have clearly different numbers
Either use this as your expression
Count (DISTINCT ID) /
count(TOTAL {<thing>}distinct ID)
or remove thing as your dimension