Forum Discussion
Auto Increment Sequence number on Summarized Table visualization
Can you please share the expected out or some other details of the issue with screenshot or dummy data
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.
I didn't get you please provide expected output and the logic you are thinking