Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All!
I want to set the dimension to two time periods in the morning and in the afternoon.How should I write the expression?
Thanks in advance!
Hi,
Add required two dimension in the chart and put conditional show condition on both:
Dim1 (Afternoon)
=if(num(subfield(now(),' ',2)& ' '&subfield(now(),' ',3))> num(maketime(12,01,00)),1,0)
Dim2 (Morning)
=if(num(subfield(now(),' ',2)& ' '&subfield(now(),' ',3))> num(maketime(00,00,00)) and num(subfield(now(),' ',2)& ' '&subfield(now(),' ',3))< num(maketime(12,00,00)),1,0)
Regards
KC
Do you mean @ morning you need one dimension (Dimension A) and @ afternoon another dimension (Dimension B) and the expression remains same?
Regards
Harish
Hi,
Add required two dimension in the chart and put conditional show condition on both:
Dim1 (Afternoon)
=if(num(subfield(now(),' ',2)& ' '&subfield(now(),' ',3))> num(maketime(12,01,00)),1,0)
Dim2 (Morning)
=if(num(subfield(now(),' ',2)& ' '&subfield(now(),' ',3))> num(maketime(00,00,00)) and num(subfield(now(),' ',2)& ' '&subfield(now(),' ',3))< num(maketime(12,00,00)),1,0)
Regards
KC