Filter

Nikki — Mon, 27 Mar 2017 11:44:45 GMT

I have 1 table with columns called "forecast days" "date" "resource name" and so on

i set the page filter to allow the user to select the month

i then need a number figure which does the following:

tell me the number of resources that have more than 20 days assigned (which is forecast days) to them as a sum for that month

i cant seem to get any number displaying other than 1...

please help

thanks

Nikki

Re: Filter

Eric_Zhang — Wed, 29 Mar 2017 06:37:12 GMT

Nikki

For me, the requirement is not clear. Could you please post some sample data and

Nikki wrote:

Hi

I have 1 table with columns called "forecast days" "date" "resource name" and so on

i set the page filter to allow the user to select the month

i then need a number figure which does the following:

tell me the number of resources that have more than 20 days assigned (which is forecast days) to them as a sum for that month

i cant seem to get any number displaying other than 1...

please help

thanks

Nikki

Nikki

When saying page filter, do you mean a slicer visual? What is the "number figure", is that a card visual? If yes, What do you put in the card visual? Have you tried using any measure?

You question is not quite clear for me, could you please post some sample data and snapshot to show the exact purpose?

topic Filter in Developer

Filter

Re: Filter