How to visualize time values in SAC stories.

[former_member1058235]

I am working on timesheets but SAC is not allowing me to set time columns as measures. There are no other measures in my dataset. I have to visualize average employee and department time in, time out, lunch in, lunch out, hours worked etc. can anyone help me with this ?

[avsalynin]

haroonazhar63

about "time columns as measure" - i think, you can try through Calculation new measure - Dimension To Measure:

about count smth with dates, i'll suggest you to use Calculation new measure - Difference From (before that, you can count the number of unique rows (through the Aggregation function) for some of the dimensions)