Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have the following data:
ID | Time |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 12 |
5 | 2 |
6 | 0 |
etc.
I have represented in a graph the percentage of IDs that have the time 0, 1, 2, 3 and 12 (image 1).
I has used the next code:
=Num((Count(Time)*100/Count({T1}total Time))/100,'##,##%')
Now, I want to create a new column. This column is the percentage (with respect to the total) of the IDs whose time is < 3 (image 2).
I have tried with sum and aggr, count, etc, but I have not been successful.
Could you help me, please?
Thanks!
Hi,
It seems that you want to add a value in your dimension column,
so I think it's better to solve it in back-end, like you concatenate a part of data that the value of "time" column is time.
Aiolos Zhao
Hi Aiolos,
Thanks for you answer!
My problem is that the graph is linked to a List Box. The List Box contains the date when the measurement was made. Therefore, if I add the value in back-end, I won't filter the graph by date.