topic Re: Stacked Bar chart with dates in App Development

Stacked Bar chart with dates

LP27 — Sat, 16 Nov 2024 03:50:57 GMT

Hi Everyone,

I have got the below table-

ID	PR1	PR2	PR3	PR4	PR5	PR6	PR7
A001	01/10/2019	01/20/2019	01/25/2019	01/27/2019	01/29/2019	02/02/2019	02/04/2019
B002	01/15/2019	01/19/2019	01/25/2019	01/27/2019	02/03/2019	02/07/2019	02/07/2019
C003	01/16/2019	01/17/2019	01/26/2019	01/30/2018	02/02/2019	02/18/2019	02/20/2019

Now i need to create a horizontal Stacked Bar chart. I have created the Stacked Bar Chart.

But the issue is I am not getting the right format of dates in Stacked Bar chart, not sure what is the issue.

Please find the image attached to have a look at my Stacked Bar chart.

Please let me know if you have questions.

Thanks in advance!

Re: Stacked Bar chart with dates

Kushal_Chawda — Thu, 12 Dec 2019 14:53:27 GMT

would you be able to share sample app?

Re: Stacked Bar chart with dates

LP27 — Thu, 12 Dec 2019 14:57:34 GMT

App is actually big, but the table which i shared in post is exactly the
same and the format of date is in same format only.

Re: Stacked Bar chart with dates

patilamay — Thu, 12 Dec 2019 15:00:46 GMT

What's the expression you're using in you bar chart?

Thanks,

Re: Stacked Bar chart with dates

Kushal_Chawda — Thu, 12 Dec 2019 15:02:04 GMT

are you applying Date() function over these fields?

Re: Stacked Bar chart with dates

manoranjan_d — Thu, 12 Dec 2019 15:09:25 GMT

try to use date () in the chart or script for the fields

Re: Stacked Bar chart with dates

LP27 — Thu, 12 Dec 2019 15:10:29 GMT

Actually, I know this should be wrong.

For Dim - I add ID

For Measures- I add sum(PR1) has 1 measure and sum(PR2) has 2nd measure ans so on...

Re: Stacked Bar chart with dates

LP27 — Thu, 12 Dec 2019 15:11:40 GMT

I tried date() it dint do magic.

Re: Stacked Bar chart with dates

LP27 — Thu, 12 Dec 2019 15:12:21 GMT

I tried and it was still the same.

Re: Stacked Bar chart with dates

manoranjan_d — Thu, 12 Dec 2019 15:16:17 GMT

please let us know your actual requirement, what things need to be done on the chart.

Re: Stacked Bar chart with dates

LP27 — Thu, 12 Dec 2019 15:21:30 GMT

I need Stacked Bar Chart as attached in image.

Like for each Id, i need to display the dates stacked from PR1 to PR7.

Note: if you observe the image, the date format is not in right format.

Re: Stacked Bar chart with dates

Kushal_Chawda — Thu, 12 Dec 2019 15:23:24 GMT

Instead sum use only function on Date fields

Re: Stacked Bar chart with dates

LP27 — Thu, 12 Dec 2019 15:24:57 GMT

I tried that as well.

It dint work out well.

Re: Stacked Bar chart with dates

Kushal_Chawda — Thu, 12 Dec 2019 15:35:08 GMT

I am worried without looking at your app it will be hard to tell what is the issue?

What is the dimension and measure used in the chart?

Re: Stacked Bar chart with dates

manoranjan_d — Thu, 12 Dec 2019 16:04:38 GMT

When coming to stacked bar the dates are getting summed up but in the non stacked the date format are correct. attached the screen shot.

in the stacked bar chart the dates are sum up example

1/10/2019+ 1/20/2019+1/25/2019 = 2/26/2257

1/10/2019

1/20/2019

1/25/2019

Re: Stacked Bar chart with dates

Kushal_Chawda — Thu, 12 Dec 2019 16:38:32 GMT

use below expressions

=date(sum(PR1))...... for all expression

Go to chart properties -> appearance -> x-axis option -> Range -> Custom-> Min/Max

in Min: use min(PR1)

in Max: use max(PR7)

Re: Stacked Bar chart with dates

LP27 — Thu, 12 Dec 2019 17:01:01 GMT

It Should not Sum up. I want to have it like that only in stacked bar.

Re: Stacked Bar chart with dates

LP27 — Thu, 12 Dec 2019 17:17:30 GMT

I tried with date(sum(PR1))) and did the same expression till PR7, there is no change 😞

Re: Stacked Bar chart with dates

andoryuu — Thu, 12 Dec 2019 18:20:13 GMT

What are your DateFormat and TimestampFormat variables set to in your data load script? Default US formatting is the following:

SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

That's what your data appears to be in, but if it's not you can either change your default date format or ensure the values are brought in as dates and then specify the format of the date thusly:

LOAD ID, DATE(DATE#(PR1,'M/D/YYYY'),'YourFormatString') as PR1;

SQL SELECT ID, PR1

FROM Table;

You may also want to floor your date if you are dealing with timestamps in the import (and want to group by date).

DATE(FLOOR(DATE#(PR1,'M/D/YYYY')),'YourFormatString') as PR1;

Re: Stacked Bar chart with dates

LP27 — Thu, 12 Dec 2019 18:25:37 GMT

I am using US Date format and there is no time stamp in my data.

I did not understand this part -

SQL SELECT ID, PR1

FROM Table;

Not sure how to scrip this!

Also in the below script , what do you mean by 'YourFormatString'

DATE(FLOOR(DATE#(PR1,'M/D/YYYY')),'YourFormatString') as PR1;

Thanks in advance!