1 Reply Latest reply: Aug 4, 2011 12:45 AM by Erika Jain RSS

    Time calculation

      Hi All,

       

      I have a chart which has the amount of RAM used vs time per user. It's a straigh table right now but will be convereted to a bar chart (stacked).

       

      I want to display the times only for today's date in one chart. And in another chart just for todays date, all times between 6AM and 10AM.

       

      I have calculated a function for time, but its not showing any values.

       

      Please help.

        • Time calculation

          Try This:

           

          In   Dimension:

           

          if(Floor(sampletime)=today(),time(Sampletime))

           

           

          Use instead of Today() , a Variable....like

           

          if(floor(Sampletime)= $(variable1),time(sampletime))

           

          in the Script...define Variable as:

           

          Let variable1 = num(now());

           

          Here the variable will contain the Value of the Time when u reload the data.

           

          Don't define now() in frontend as its value changes every sec.