Forum Discussion

bfaivre's avatar
bfaivre
Regular Visitor
9 years ago

Plot Values (y axis) vs. Time (x axis)

Hello,

 

I’m sure I’m missing something really basic here. But I have data that I retrieve from a database. The first columns represent timestamps and the second columns represents values. I simply want a plot of these values on the y axis vs. the timestamps on the x axis. However, when I try what I think is obvious, I get a count of the values and timestamps. How can I plot all of these values over time?

 

Thanks in advance,

 

Brian

13 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    Make sure that your Value is an actual number and didn't come in as Text. You can go to data model, the Modeling tab and check its Data Type and convert it if necessary. Otherwise, you are correct, all you will get is a Count aggregation for a Text column in your visual.

    • bfaivre's avatar
      bfaivre
      Regular Visitor
      9 years ago

      Hi,

       

      Thanks for the response. My values are the appropriate types ("Date/Time" and "Decimal Number"). Still giving me the counts.

       

      Brian

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        9 years ago

        So, in your Values area for the visualization, can you use the drop down and select a different aggregation than Count? Or, can you change the default aggregation type in the model?