Forum Discussion

sbotros's avatar
sbotros
Frequent Visitor
2 years ago
Solved

Star schema filtering in visuals

Hello all - looking for some quick troubleshooting/second pair of eyes as I've been staring at the problem for too long at this point.    After previously using a single table schema for individual...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Facts: something you measure

    Dimensions: something you filter by

     

    Re-examine your data and identify which column belongs where, how many tables you need etc.

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

That's not a star schema - yet.  Make all joins single directional.

  • sbotros's avatar
    sbotros
    Frequent Visitor
    2 years ago

    Thanks for the response! I had initially tried single direction joins and it did not work.

    I've also tried using only the dimension tables fields as my sources for the visuals and that also doesn't work. 

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

      Facts: something you measure

      Dimensions: something you filter by

       

      Re-examine your data and identify which column belongs where, how many tables you need etc.