Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello experts,
I am working on some data where count of actions mentioned with their respective outcome. And I want to present 5 times action and incase if comeone has mor ethan that it should come along with 5th column as 5+
Look at this example.
Days | Production | Sale |
1 | 927 | 836 |
2 | 506 | 706 |
3 | 937 | 712 |
4 | 872 | 839 |
5 | 729 | 776 |
6 | 881 | 868 |
7 | 750 | 717 |
8 | 880 | 725 |
9 | 557 | 991 |
10 | 525 | 797 |
11 | 559 | 614 |
12 | 1000 | 771 |
If in the above table i would like to show days as 1,2,3 & 4 individually and rest as 5+
then how should i present them in chart
Kindly help
Regards
Use a calculated dimension as chart dimension: =if(Days<5,Days, '5+')
Find the attached file:
A snapshot of my solution:
what about if i want the latest data of last 5 months not later than that
Like this?
Or this?
Its correct yes this is how i want
If i am not wrong.
in this data if further more days will be added like 13 to 16
then i will get data from 12 13 14 15 16
If correct then let me know how to do it.
M
May be Like this , PFA
Is this what you're looking for?