Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello together,
i have a question about the pie chart. I have the table with the dates:
Lieferdatum | Befuellt_Datum |
20.12.2016 | 20.12.2016 |
16.12.2016 | 18.12.2016 |
14.12.2016 | 14.12.2016 |
12.12.2016 | 12.12.2016 |
10.12.2016 | 11.12.2016 |
08.12.2016 | 09.12.2016 |
05.12.2016 | 05.12.2016 |
03.12.2016 | 03.12.2016 |
30.11.2016 | 30.11.2016 |
Now I wanted to show
If (Lieferdatum = Befuellt_Datum) than "okay"
If (Lieferdatum > Befuellt_Datum) than "okay"
If (Lieferdatum < Befuellt_Datum) than "wrong"
and this integrated in a pie chart. How is that possible?
like this ?
Create those flags in script and then use that flag as dimension in Pie chart
Hi Kevin
If all you want to see in your pie chart is the number or percentage that are "ok" or "wrong" in your load script create a new column by using If (Lieferdatum < Befuellt_Datum,'wrong','ok') as [new field] then use the [new field] as the dimension in your pie chart. I hope this is useful but if I've misunderstood your question please can you provide more information.
Kindest regards
Brian
How can I create a flag?
like this ?
If (Lieferdatum >= Befuellt_Datum) , 'okay',
If (Lieferdatum < Befuellt_Datum) ,'wrong')) as Flag
yes like this
create a calculated dimension in pie chart
If (Lieferdatum >= Befuellt_Datum,'okay',
If (Lieferdatum < Befuellt_Datum,'wrong'))
then use some measure
Thank you.
maybe you can help me again.
In another Table I have the date type like DD.MM.YYYY hh:mm:ss
Lieferdatum | Befuellt_Datum |
20.12.2016 00:00:00 | 20.12.2016 10:12.2016 |
16.12.2016 00:00:00 | 18.12.2016 15:12.2016 |
14.12.2016 00:00:00 | 14.12.2016 10:12.2016 |
12.12.2016 00:00:00 | 12.12.2016 10:12.2016 |
10.12.2016 00:00:00 | 11.12.2016 10:12.2016 |
08.12.2016 00:00:00 | 09.12.2016 10:12.2016 |
05.12.2016 00:00:00 | 05.12.2016 10:12.2016 |
03.12.2016 00:00:00 | 03.12.2016 10:12.2016 |
30.11.2016 00:00:00 | 30.11.2016 10:12.2016 |
Important is just the date not the time. How I can ignore the time?
in script try this
date(floor(Lieferdatum)) as Lieferdatum,
date(floor(Befuellt_Datum)) as Befuellt_Datum
then try