Forum Discussion

spider_Monkey's avatar
spider_Monkey
Icon for Helper I rankHelper I
4 years ago
Solved

Visualizing Data values between dates

Hello Friends,   I am trying to build out a visulization that will show me how many reports (Reports Goal) between the time periods below. So one example would be between 1/2-1/15 there would be 1...
Need Help
Show and Tell
spider_Monkey's avatar
spider_Monkey
Icon for Helper I rankHelper I
4 years ago

So I built a new table outside of query editor based off data from anohter table. 

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

    As long as you included the index column there you are good. Doesn't matter where in the ETL process you do it.

    • spider_Monkey's avatar
      spider_Monkey
      Icon for Helper I rankHelper I
      4 years ago

      Okay, so I am using union to unpivot this and I should be able to get there. Do you happen to have a screen shot of the visualizations pane from the graph you provided? 

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

        Column = [Person] & [Index]