I have a table with rows and seat data. The problem is, the seat just keeps going up. So, if I have 10 rows of ten seats, the seat data goes from 1--100, when I want it to reset to 1 when the row increments. How do I do this? Can I make if statements outside of a load statement? And I can't set variables inside of a load statement.
What you can do is to have time intervals, and when you click on an X value, for example 6pm, the graph shows the X values such as 6:00, 6:15, 6:45 etc., this is done first. integer value of the hour, and declaring a master dimension of the gerarchy type, here you first put the integer value and as a second dimension you add the one that contains the hour and minutes.