Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Static Date Comparison

Hi,   I am trying to have a static date table, which I have created, and compare this to a Query pull table.    I am trying to see that for example, on March 19, 2020, how many Work Requests are ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

Anonymous ,

 

So in the table above, the number of "Open" Work Requests would be 1 as of 3/19/2020

 

I am having trouble creating measures in my Date table to compare to the Query pull table, or to adjust based on a date being used in the dashboard filter

I'm confused on your description. Could you share the sample data of Query pull table and clarify more details about the logic of calculating "Open" Work Requests?

 

Regards,

Jimmy Tao

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-yuta-msft ,

the Opened Work Request just means the date that the Work Request was recieved in the system. There is no calculation behind it

 

My question is how to show the number of Work Requests that are incomplete on a certain day.. if that makes sense

 

Thank you!
Sarah