Forum Discussion
Auto Increment Sequence number on Summarized Table visualization
Hello mh2587 ,Please see the screen shot below , This report shows Employee Timesheet Status monthly.
in another table(Table B) i have each employee daily timesheet , which i am summarizing here to get the total hours and missing hours till the date.
I want a custom index column in Table A which will start with 1 , and as the rows increases in the table it will take +1 increment. its fine if foe the next month it will continue the series and will not start from 1 again.
Table A
Table B
Kindly let me know if you need any further details , Thanks in advance.
Row Number = RANKX( ALL(TableA) ,% Time Recorded) //I am assuming the % Time Recorded will be a measure not calculated column
Write this measure and put it in the visual
Hello mh2587 , here in tableA which table i should mention because all tables have data on daily basis activity and in this visual i need grouped(till the date) result.