Відео

Can you let me know why you are trying to apply the filter? Here we are trying to compare last year vs previous year

I don’t think that would impact the dynamic functionality

Ideally, it should work as worked for me. Can you check if you are using the correct formulae

If suppose the target achieved is 60% then the remaining out of 100% will be 40%. The complete donut chart shows 100%.

Can you give more details on the requirement? Here, we are comparing sales of the year selected by the user with the previous year sales.

@@helpful_tipss I need to calculate Qtr over Qtr in TableView using CalculatedFields. I don't want to use QuickTable, WindowFunction, or Lookup. Only want to make key using CalculatedFields. So the requirement is, I need Qtr over Qtr in TableForm for all the rows. Calculation should be at row level. I don't want to use parameters because it will only give me for a particular Qtr. But I want the calculation should be there for all the Qtrs. Is there any possible way because I am able to create it using parameters. But I want it to be done for all the Qtrs, not only for a specific one. And also want to mention that I don't have data till current date. So when I put today, I don't get values. And when I use maxDate, then I only get data for most prior and most recent Qtr. I don’t want to use tabulae prep or any etl or self join So please help me with some calculations.

I need to calculate Qtr over Qtr in TableView using CalculatedFields. I don't want to use QuickTable, WindowFunction, or Lookup. Only want to make key using CalculatedFields. So the requirement is, I need Qtr over Qtr in TableForm for all the rows. Calculation should be at row level. I don't want to use parameters because it will only give me for a particular Qtr. But I want the calculation should be there for all the Qtrs. Is there any possible way because I am able to create it using parameters. But I want it to be done for all the Qtrs, not only for a specific one. And also want to mention that I don't have data till current date. So when I put today, I don't get values. And when I use maxDate, then I only get data for most prior and most recent Qtr. I don’t want to use tabulae prep or any etl or self join So please help me with some calculations.

I don’t think that would be possible. It will reset filters to ‘All’

Awesome, thank you! 😀

Glad it helped 🙂

Thank you Ritesh. Glad to hear that you found the content really helpful 🙂

The color of the highest bar will be same in all the regions.

It should work. Make sure you are following the steps exactly mentioned in the tutorial

Please check if the you are giving the correct syntax as explained in the video

Great to hear that you found the video helpful. Appreciate your positive feedback 👍🏻

Glad it was helpful! 🙂

Glad you enjoyed it! 🙂

It totally depends on the scenario whether we need to show those records or not. This was just an example that I shared to let everyone know that creating relationship can filter out records and if the use case you are working on wants you to show those records then we can use the option of “show items with no data”. Hope that answers your question.

Most welcome 🙂

Thank you so much 😀

You're welcome 👍🏻

Glad to hear that 👍🏻

Glad it was helpful! 🙂

Great to hear! 😃

Glad it was helpful!🙂

Glad it was helpful! 👍🏻