Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
2 years ago

Formula Query to create Line Chart filtered by the current logged in user

Hi all, I am working on a formula query to try to build a line graph that will show cumulative sales for the current user in the current year and previous two years.  I had this working without the b...
IvanWeiss's avatar
IvanWeiss
Qrew Captain
2 years ago

Nope, that did not work either.  Would I swap out the ToText([Current User]) with the fid maybe?  I didnt try but I am not sure what the TV means



------------------------------
Ivan Weiss
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 years ago

I just did a test to count children of a parent where the current user is the record owner and it worked.

var text QUERY = 
  "{7.EX." & ToText([Record ID#]) & "}"
& " AND " 
& "{4.TV.'" & ToText(User()) & "'}";
Size(
GetRecords($Query, [_DBID_CHILD]))
So maybe its those pesky single quotes that will fix it.
AND {19.TV.'" & ToText([Current User]) & "'}";


------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
  • IvanWeiss's avatar
    IvanWeiss
    Qrew Captain
    2 years ago

    I actually got to work via {19.TV._fid_66}



    ------------------------------
    Ivan Weiss
    ------------------------------