topic Re: Straight table in App Development

Straight table

paulwalker — Thu, 20 Apr 2023 17:52:10 GMT

Hi Community,

I have to create one chart with 3 measures and each months count in one chart. (I feel Pivot table not suitable for this, so used straight table)

I have used straight table (written all the expressions 3 measures and individual months like below)

Here calculations should be dynamic and when user select Mar'23 - chart should show Jan, Feb and Mar along with 3 measures. If user select Feb'23 - Chart should show Jan and Feb along with 3 measures..

let say user select Mar'23

Thanks in Advance!

Re: Straight table

paulwalker — Thu, 20 Apr 2023 17:57:27 GMT

@tresB , any suggestions for better view instead of all individual months calculation ?

Re: Straight table

edwin — Thu, 20 Apr 2023 17:56:47 GMT

my understanding is that you need to display some number of measures that arent turned on/off by the month selection and then you need to add as many measures that represent year to month (in individual months). the way i would do this is
1. create your 3 measures (no condition)
2. create 12 measures (Jan to Dec)
3. the labels would be of course dynamic based on the year
4. each would of course have its own expression to calculate just for the month and year
5. add a condition that if the month <= the selected month then turn it on else off

Re: Straight table

paulwalker — Thu, 20 Apr 2023 21:00:44 GMT

Thanks for reply Edwin, I'm unable to configure hide/show condition.

Re: Straight table

edwin — Thu, 20 Apr 2023 19:10:05 GMT

not sure what a 5-point condition is. but thsi is what i am saying:

this assumes that the data is only for one year starting from Jan
wht i did was add a MonthText Jan to Dec:

the user selects the Month
then for the 12 months my expression is:
Sum({<Month=, MonthText={'Jan'}>}Amount) - this gets the data for the month of Jan
condition is:
=count({<Month={"<=$(vMonth)"}, MonthText={'Jan'}>}MonthText)

Re: Straight table

paulwalker — Thu, 20 Apr 2023 21:10:48 GMT

Is there any better approach instead of hardcoded for all months ??

Re: Straight table

edwin — Thu, 20 Apr 2023 22:08:06 GMT

Build a bridge table between your fact and the calendar. Create pseudo values for perio mint current month then January to December

then pivot the new field