Forum Discussion

Kornholio's avatar
Kornholio
Helper III
6 years ago

Using a Date filter and KPI

Hi,   I have a date, "Target Date", which has multiple date entries. I have it in a filter by "Relative Date" selections, for things like, weekly, bi weekly, etc. I also have an "Expectations" colu...
Need Help
Kornholio's avatar
Kornholio
Helper III
6 years ago

Alright, bit of a change, so if i have a Period Date filter dropdown and i need for Period 1 to show # of Units as whatever they have, say 30, and the Expectation is set for 60, then when i choose Period 1 and Period 2, the  # of units will double and the Expecation would too. Is there a calc for this? I will send a sheet of data i use if you need it

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Kornholio ,

 

I didn't find "units" column in your sample data but i did find "Expecation" column.

So basically you want the value/sum of "Expecation" multiplied by the count of selected "Period"? And should the target date within the selected "Period"?

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.