Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey everyone, it's been a while since I've coded anything. Just need a little refresher. I am simply trying to get some information to show in a textbox on a dashboard I am building. Lets say I wanted to add the sum of Processed_Dash in Mechanical Inspection that are completed from 6/1/2017 and 6/2/2017. What is the correct syntax to pull this information in a textbox expression? Thanks
Hi,
one solution might be:
=Sum({$<Program_Dash={'AAA'},Date_Dash={'6/1/2017','6/2/2017'}>} Processed_Dash)
hope this helps
regards
Marco
Hi,
one solution might be:
=Sum({$<Program_Dash={'AAA'},Date_Dash={'6/1/2017','6/2/2017'}>} Processed_Dash)
hope this helps
regards
Marco
Does 6/1/2017 and 6/2/2017 are constants, If so Marco solution works like chart, If it is not static then you must build up the dynamic expression that part you have to explain little more
This seems to be working, but now the requirements will be needed for yesterday.
I believe this is the correct way to do so, just is pulling up today's data for some reason.
Sum({$<Program_Dash={'Mechanical Inspection'},Date_Dash={'date(Today()-1)'}>} Processed_Dash)
I was able to use the today function to get Today's date and retrieve the data using the equation, Using this equation, I need to retrieve yesterday's data, but no data is pulling up. Thanks!
Sum({$<Program_Dash={'Mechanical Inspection'},Date_Dash={'date(Today()-1)'}>} Processed_Dash)