Forum Discussion
How to Get Your Question Answered Quickly
Ever wonder why some questions get answered so quickly while others languish or are seemingly completely ignored? Fear not, this article will help guide you into getting your question answered quickl...
Hello,
I have two columns,
1, Datetime
2, Power
Every 1 hour i have data(EXp:-23-01-2021 to 31-01-2021)
Note:25th and 26th i have no data
How can i do 25th and 26th date s Transparent.
Table:
| Date/Time | Power |
| 23-01-2021:00:00:00 | 20 |
| 23-01-2021:01:00:00 | 24 |
| 23-01-2021:02:00:00 | 10 |
| 23-01-2021:03:00:00 | 36 |
| 23-01-2021:04:00:00 | 10 |
| 23-01-2021:05:00:00 | 30 |
| ..... | .. |
| .... | ... |
| 24-01-2021:01:00:00 | 12 |
| 24-01-2021:02:00:00 | 11 |
| 24-01-2021:03:00:00 | 80 |
| 24-01-2021:04:00:00 | 20 |
| ..... | ... |
| .... | ... |
| 24-01-2021:23:00:00 | 20 |
| 27-01-2021:01:00:00 | 15 |
| 27-01-2021:02:00:00 | 29 |
| 27-01-2021:03:00:00 | 22 |
| 27-01-2021:04:00:00 | 66 |
| 27-01-2021:05:00:00 | 7 |
| ..... | ... |
| Conitious every hour i have data | |
Any one help in this issue. subbu3966
Thank you.
use if statement along with hasonevalue then column you want to show otherwise BLANK() , so when your put this to your dashborad it would actualy encounter this is as blank and would not show,