Forum Discussion

Nelson_Marquez's avatar
Nelson_Marquez
Regular Visitor
5 years ago

Streamline visualization table

Hi community.   I) I have a visualization table built with two tables/queries. It's about the flow of some products, showing the possible origins or load locations for a given destination or unloa...
Need Help
LP2803's avatar
LP2803
Responsive Resident
5 years ago

Hi,

 

for your first question, I see that the "R2 Volume total (m3)" is what making the table to repeat the values.

 

you may need to aggregate (sum/average) this column to not to get the repeatations.

 

for the second question, could you please elaborate more what are you trying to compare?

  • Nelson_Marquez's avatar
    Nelson_Marquez
    Regular Visitor
    5 years ago

    LP2803 thanks for your response.

     

    Even if I remove that field I still have the same issue.

     

    I'd like the source fields to be subjacent just to the destination field, not to the other source field.

     

    Thanks and regards

    • LP2803's avatar
      LP2803
      Responsive Resident
      5 years ago

      For your second query,  the below is what you are trying to achieve?

       

      • Nelson_Marquez's avatar
        Nelson_Marquez
        Regular Visitor
        5 years ago

        That would be the ideal, however I'm building my bisualization table with two different source tables. I guess we can't create measures in the visualization tables (Report tab), right?