Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
assuming i have this table:
col1 | col2 |
A | 272 |
A | 214 |
A | 483 |
B | 457 |
B | 278 |
B | 327 |
B | 363 |
A | 324 |
B | 433 |
A | 153 |
B | 596 |
A | 350 |
A | 153 |
B | 520 |
A | 343 |
B | 325 |
A | 433 |
I want to create bar chart with x-axis as the following bin range:
<200 , 200-250, 251-300,301-350, 351-400, >400
i try the class function ( class(col2,50) ), but i need the option to create also min range (<200) and max range(>400).
In the class function it create with final range.
The y-axis just count freq of A according to the bin range.
does anyone have a solution (without change or add any data to the DB)?
thnx.
Try something like this:
=if(Col2<200,'<200',if(Col2>400,'400',class(Col2,50)))
Try something like this:
=if(Col2<200,'<200',if(Col2>400,'400',class(Col2,50)))
thnx Gysbert, but i still have 2 problems:
First- i want to sort the x-axis as: col2<200,200-250,251-300, .... , col2>400 i try sort by expression but it didnt work.
Second- i want to color the min col and the max col with different colors than the rest of the cols.