Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have a data like this
date balance code
1-jan-2018 500 abc
1-jan-2018 90 def
2-jan-2018 600 def
3-jan-2018 900 rst
6-jan-2018 1200 kdsg
10-jan-2018 1500 sdfg
now i want these balances per day wise means i want to apply filter of month i.e. when i click on jan month then all the dates should be on table like this is i want
code day1 day2 day3 day4 day5 day6 day7 day8 day9 day10... so on
abc 500
def 90 600
rst 900
kdsg 1200
sdfg 1500
how i get this ?
@Gysbert_Wassenaar i did that but this shows that time is in 1 column where i want to contribute that time according to day wise please check image
like this what i want
branch update_month update_day 1 2 3
abc Jan 3:00 4:00 9:00
Looks like you're using Time as a dimension instead of as a measure.
yes i am using time as dimension .. if i use time as measure then how i use .. means i directly call time field in measure or there is some calculation ?
If there's only one Time value per combination of dimension values then you can use sum(Time) or Only(Time) or Avg(Time) or Max(Time) or Min(Time). They'll all return the same result if there's only one Time value.
ok
and also i want to tell this there is 30 /31 days in a month so it looks like long table so is there any alternative to show 30/31 days in any other perspective?