Forum Discussion

stuarthokie's avatar
stuarthokie
Frequent Visitor
2 years ago

Native Query to Pivot Large Volumes of Data

Hello!  I have a challenge for which I have not seen a resolution posted.  I have seen similar issues resolved, but none like what seems to be my normal challenge.  I am green to the more complex wor...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Use Performance Analyzer on the Matrix visual. Copy the query and examine it.

stuarthokie's avatar
stuarthokie
Frequent Visitor
2 years ago

There is no query to copy which makes sense.  All I am doing is selecting rows, columns, and values to place in the Matrix:

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    That's not all you are doing.  You are also applying filters.

     

    Click Start Recording, Refresh Visuals, Copy Query.

    • stuarthokie's avatar
      stuarthokie
      Frequent Visitor
      2 years ago

      I did not refresh visuals previously, thanks!  I'll disect this code when I have time and get back to the thread.

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi stuarthokie ,

        Did your problem get solved? If so, please mark lbendlin 's answer as the solution.

         

        Best Regards,
        Wenbin Zhou